DBA Data[Home] [Help]

APPS.CST_REVENUECOGSMATCH_PVT dependencies on FND_CONCURRENT_PROGRAMS_VL

Line 7388: FROM fnd_concurrent_requests FCR, fnd_concurrent_programs_vl FCP

7384: AND ROWNUM = 1; */
7385:
7386: CURSOR cu_exec IS
7387: SELECT FCP.user_concurrent_program_name
7388: FROM fnd_concurrent_requests FCR, fnd_concurrent_programs_vl FCP
7389: WHERE FCR.program_application_id = p_app_id
7390: AND FCP.application_id = p_app_id
7391: AND (FCR.argument3 = TO_CHAR(p_ledger_id) OR
7392: -- User submits a request for ledger A and CP for all ledger is running

Line 7401: FROM fnd_concurrent_requests FCR, fnd_concurrent_programs_vl FCP

7397: AND FCP.concurrent_program_name IN ('CSTRCMCR1','CSTRCMCR','CSTRCMCR3');
7398:
7399: CURSOR cu_exec_all IS
7400: SELECT FCP.user_concurrent_program_name
7401: FROM fnd_concurrent_requests FCR, fnd_concurrent_programs_vl FCP
7402: WHERE FCR.program_application_id = p_app_id
7403: AND FCP.application_id = p_app_id
7404: AND FCR.phase_code = 'R'
7405: AND FCR.request_id <> FND_GLOBAL.CONC_REQUEST_ID