DBA Data[Home] [Help]

APPS.PSP_ENC_CREATE_LINES dependencies on FND_CONCURRENT_REQUESTS

Line 6634: FROM fnd_concurrent_requests

6630:
6631: CURSOR action_parameters_cur IS
6632: SELECT fnd_number.canonical_to_number(NVL(argument11, -1)),
6633: argument12
6634: FROM fnd_concurrent_requests
6635: WHERE request_id = l_request_id;
6636:
6637: CURSOR enc_payrolls_cur IS
6638: SELECT pep.payroll_id

Line 6827: FROM fnd_concurrent_requests fcr,

6823:
6824: CURSOR payroll_id_cur IS
6825: SELECT fnd_number.canonical_to_number(NVL(argument11, -1)),
6826: argument12
6827: FROM fnd_concurrent_requests fcr,
6828: psp_enc_processes pep
6829: WHERE pep.payroll_action_id = p_payroll_action_id
6830: AND fcr.request_id = pep.request_id;
6831:

Line 7751: FROM fnd_concurrent_requests fcr,

7747: l_st_count NUMBER(15);
7748:
7749: CURSOR payroll_id_cur IS
7750: SELECT argument12
7751: FROM fnd_concurrent_requests fcr,
7752: psp_enc_processes pep
7753: WHERE pep.payroll_action_id = p_payroll_action_id
7754: AND fcr.request_id = pep.request_id;
7755:

Line 8840: fnd_concurrent_requests fcr

8836: fnd_date.canonical_to_date(NVL(argument20, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8837: fnd_number.canonical_to_number(NVL(argument21, '-1')),
8838: fnd_date.canonical_to_date(NVL(argument22, fnd_date.date_to_canonical(TRUNC(SYSDATE))))
8839: FROM psp_enc_processes pep,
8840: fnd_concurrent_requests fcr
8841: WHERE pep.payroll_action_id = p_payroll_action_id
8842: AND fcr.request_id = pep.request_id;
8843:
8844: CURSOR enc_payroll_cur IS

Line 8903: fnd_concurrent_requests fcr,

8899:
8900: CURSOR process_descr_cur IS
8901: SELECT pep.request_id || ': ' || fcpt.user_concurrent_program_name
8902: FROM psp_enc_processes pep,
8903: fnd_concurrent_requests fcr,
8904: fnd_concurrent_programs_tl fcpt
8905: WHERE EXISTS (SELECT 1
8906: FROM psp_enc_summary_lines pesl
8907: WHERE pesl.payroll_action_id = pep.payroll_action_id