Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT COALESCE(DocLimit, SysLimit, 0) FROM (
- SELECT limit AS DocLimit, 1 AS GROUP FROM PPF_FUPLIMIT
- WHERE iddocument = inIdDocument
- AND Valid = 'Y'
- AND ROWNUM < 2
- AND SYSDATE BETWEEN ValidFrom AND ValidTo ORDER BY createdat
- JOIN
- SELECT limit AS SysLimit, 2 AS GROUP FROM PPF_FUPLIMIT
- WHERE TYPE = 'DEFAULT'
- AND Valid = 'Y'
- AND ROWNUM < 2
- AND SYSDATE BETWEEN ValidFrom AND ValidTo ORDER BY createdat
- GROUP BY GROUP);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement