Advertisement
Guest User

Untitled

a guest
Jun 24th, 2017
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.       SELECT MAX(limit) INTO lnLimitDoc
  2.         FROM PPF_FUPLIMIT
  3.         WHERE iddocument = inIdDocument
  4.           AND Valid = 'Y'
  5.           AND ROWNUM < 2
  6.           AND SYSDATE BETWEEN ValidFrom AND ValidTo
  7.         ORDER BY createdat;
  8.       SELECT MAX(limit) INTO lnLimitDoc
  9.         FROM PPF_FUPLIMIT
  10.         WHERE TYPE = 'DEFAULT'
  11.           AND Valid = 'Y'
  12.           AND ROWNUM < 2
  13.           AND SYSDATE BETWEEN ValidFrom AND ValidTo
  14.         ORDER BY createdat;  
  15.       IF lnLimitDoc IS NOT NULL THEN    
  16.         lnLimit := lnLimitDoc + lnSysPar;
  17.       ELSIF lnLimitSys IS NOT NULL THEN
  18.         lnLimit := lnLimitSys + lnSysPar;
  19.       ELSE
  20.         lnLimit := lnSysPar;
  21.       END IF;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement