APPS.GL_WF_JE_APPROVAL_PKG dependencies on DUAL

Line 299: FROM DUAL;

295:
296: -- Get Approval run id
297: SELECT GL_JE_APPROVAL_S.nextval
298: INTO l_approval_run_id
299: FROM DUAL;
300:
301: -- Get AOL user name and person id
302: SELECT user_name, nvl(employee_id, -1)
303: INTO l_fnd_user_name, l_preparer_id

Line 767: FROM DUAL

763: l_invalid_error VARCHAR2(2000);
764:
765: CURSOR check_untaxed IS
766: SELECT 'untaxed journals'
767: FROM DUAL
768: WHERE EXISTS
769: (SELECT 'UNTAXED'
770: FROM GL_JE_HEADERS JEH, GL_LEDGERS LED
771: WHERE JEH.je_batch_id = l_je_batch_id

Line 943: FROM DUAL

939: l_non_stat_cursor VARCHAR2(40);
940:
941: CURSOR non_stat IS
942: SELECT 'non stat journal exists'
943: FROM DUAL
944: WHERE EXISTS
945: (SELECT 'X'
946: FROM GL_JE_HEADERS
947: WHERE je_batch_id = l_je_batch_id