Advertisement
Guest User

Untitled

a guest
Jun 24th, 2017
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT COALESCE(DocLimit, SysLimit, 0) FROM (
  2.       SELECT limit AS DocLimit, 1 AS GROUP FROM PPF_FUPLIMIT
  3.           WHERE iddocument = inIdDocument
  4.           AND Valid = 'Y'
  5.           AND ROWNUM < 2
  6.           AND SYSDATE BETWEEN ValidFrom AND ValidTo ORDER BY createdat
  7.           JOIN        
  8.       SELECT limit AS SysLimit, 2 AS GROUP FROM PPF_FUPLIMIT
  9.           WHERE TYPE = 'DEFAULT'
  10.           AND Valid = 'Y'
  11.           AND ROWNUM < 2
  12.           AND SYSDATE BETWEEN ValidFrom AND ValidTo ORDER BY createdat
  13.           GROUP BY GROUP);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement