APPS.CST_REVENUECOGSMATCH_PVT dependencies on FND_CONCURRENT_REQUESTS

Line 7366: FROM fnd_concurrent_requests FCR

7362: AND concurrent_program_name = p_prg_name;
7363:
7364: CURSOR cu_exec(p_prg_id IN NUMBER) IS
7365: SELECT NULL
7366: FROM fnd_concurrent_requests FCR
7367: WHERE FCR.program_application_id = 702
7368: AND FCR.concurrent_program_id = p_prg_id
7369: AND (FCR.argument3 = TO_CHAR(p_ledger_id) OR
7370: -- User submits a request for ledger A and CP for all ledger is running

Line 7379: FROM fnd_concurrent_requests FCR

7375:
7376: -- User submits CP for all ledgers and CP for ledger A is running
7377: CURSOR cu_exec_all(p_prg_id IN NUMBER) IS
7378: SELECT NULL
7379: FROM fnd_concurrent_requests FCR
7380: WHERE FCR.program_application_id = 702
7381: AND FCR.concurrent_program_id = p_prg_id
7382: AND FCR.phase_code = 'R'
7383: AND FCR.request_id <> FND_GLOBAL.CONC_REQUEST_ID

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