APPS.PA_SWEEPER dependencies on DUAL

Line 1061: from dual

1057: ,l_PktBurdenMethodCodeTab(k)
1058: ,l_PktVendorIdTab(k)
1059: ,l_PktDocHdrId2Tab(k)
1060: ,l_PktDocDistTypeTab(k)
1061: from dual
1062: where l_PktBcCommTab(k) is null
1063: and l_PktRlmiTab(k) is not null
1064: and l_PktBdgtVerTab(k) is not null
1065: and l_PktDocTypTab(k) in ('AP', 'PO', 'REQ', 'CC_P_CO', 'CC_C_CO', 'CC_P_PAY', 'CC_C_PAY')

Line 1355: from dual where l_InsDocTypTab(p) in ('EXP', 'AP','PO','REQ','CC_C_CO','CC_P_CO','CC_C_PAY','CC_P_PAY');

1351: fnd_global.conc_request_id,
1352: fnd_global.conc_program_id,
1353: fnd_global.prog_appl_id,
1354: sysdate
1355: from dual where l_InsDocTypTab(p) in ('EXP', 'AP','PO','REQ','CC_C_CO','CC_P_CO','CC_C_PAY','CC_P_PAY');
1356:
1357: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1358: pa_debug.g_err_stage := 'Log: After inserting balances';
1359: pa_debug.write_file('LOG',pa_debug.g_err_stage);