DBA Data[Home] [Help]

APPS.PSP_ER_WORKFLOW dependencies on FND_CONCURRENT_REQUESTS

Line 77: FROM fnd_concurrent_requests fcr,

73: l_request_id number;
74:
75: CURSOR orig_request_id_cur IS
76: SELECT paa.request_id
77: FROM fnd_concurrent_requests fcr,
78: pay_payroll_actions paa
79: WHERE fcr.request_id = l_request_id
80: AND paa.payroll_action_id = TO_NUMBER(fcr.argument2);
81:

Line 85: fnd_concurrent_requests fcr

81:
82: CURSOR conc_program_name_cur IS
83: SELECT fcp.concurrent_program_name
84: FROM fnd_concurrent_programs fcp,
85: fnd_concurrent_requests fcr
86: WHERE fcp.concurrent_program_id = fcr.concurrent_program_id
87: AND fcr.request_id = l_request_id;
88:
89: CURSOR original_request_id_cur IS