DBA Data[Home] [Help]

APPS.PSP_ENC_CREATE_LINES dependencies on FND_CONCURRENT_REQUESTS

Line 6378: FROM fnd_concurrent_requests

6374:
6375: CURSOR action_parameters_cur IS
6376: SELECT fnd_number.canonical_to_number(NVL(argument11, -1)),
6377: argument12
6378: FROM fnd_concurrent_requests
6379: WHERE request_id = l_request_id;
6380:
6381: CURSOR enc_payrolls_cur IS
6382: SELECT pep.payroll_id

Line 6570: FROM fnd_concurrent_requests fcr,

6566:
6567: CURSOR payroll_id_cur IS
6568: SELECT fnd_number.canonical_to_number(NVL(argument11, -1)),
6569: argument12
6570: FROM fnd_concurrent_requests fcr,
6571: psp_enc_processes pep
6572: WHERE pep.payroll_action_id = p_payroll_action_id
6573: AND fcr.request_id = pep.request_id;
6574:

Line 7439: FROM fnd_concurrent_requests fcr,

7435: l_st_count NUMBER(15);
7436:
7437: CURSOR payroll_id_cur IS
7438: SELECT argument12
7439: FROM fnd_concurrent_requests fcr,
7440: psp_enc_processes pep
7441: WHERE pep.payroll_action_id = p_payroll_action_id
7442: AND fcr.request_id = pep.request_id;
7443:

Line 8516: fnd_concurrent_requests fcr

8512: fnd_date.canonical_to_date(NVL(argument20, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8513: fnd_number.canonical_to_number(NVL(argument21, '-1')),
8514: fnd_date.canonical_to_date(NVL(argument22, fnd_date.date_to_canonical(TRUNC(SYSDATE))))
8515: FROM psp_enc_processes pep,
8516: fnd_concurrent_requests fcr
8517: WHERE pep.payroll_action_id = p_payroll_action_id
8518: AND fcr.request_id = pep.request_id;
8519:
8520: CURSOR enc_payroll_cur IS

Line 8579: fnd_concurrent_requests fcr,

8575:
8576: CURSOR process_descr_cur IS
8577: SELECT pep.request_id || ': ' || fcpt.user_concurrent_program_name
8578: FROM psp_enc_processes pep,
8579: fnd_concurrent_requests fcr,
8580: fnd_concurrent_programs_tl fcpt
8581: WHERE EXISTS (SELECT 1
8582: FROM psp_enc_summary_lines pesl
8583: WHERE pesl.payroll_action_id = pep.payroll_action_id