APPS.PA_SWEEPER dependencies on DUAL

Line 1125: from dual

1121: ,l_PktBurdenMethodCodeTab(k)
1122: ,l_PktVendorIdTab(k)
1123: ,l_PktDocHdrId2Tab(k)
1124: ,l_PktDocDistTypeTab(k)
1125: from dual
1126: where l_PktBcCommTab(k) is null
1127: and l_PktRlmiTab(k) is not null
1128: and l_PktBdgtVerTab(k) is not null
1129: and l_PktDocTypTab(k) in ('AP', 'PO', 'REQ', 'CC_P_CO', 'CC_C_CO', 'CC_P_PAY', 'CC_C_PAY')

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

1415: fnd_global.conc_request_id,
1416: fnd_global.conc_program_id,
1417: fnd_global.prog_appl_id,
1418: sysdate
1419: from dual where l_InsDocTypTab(p) in ('EXP', 'AP','PO','REQ','CC_C_CO','CC_P_CO','CC_C_PAY','CC_P_PAY');
1420:
1421: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */
1422: pa_debug.g_err_stage := 'Log: After inserting balances';
1423: pa_debug.write_file('LOG',pa_debug.g_err_stage);