APPS.HRI_OPL_MULTI_THREAD dependencies on FND_CONCURRENT_PROGRAMS

Line 217: FROM fnd_concurrent_programs cp

213: -- that have been submitted before the current process
214: -- within the same request set
215: CURSOR mtmasters_cur IS
216: SELECT count(req.request_id) count
217: FROM fnd_concurrent_programs cp
218: ,fnd_executables ex
219: ,fnd_concurrent_requests req
220: WHERE ex.executable_id = cp.executable_id
221: AND cp.concurrent_program_id = req.concurrent_program_id

Line 478: FROM fnd_concurrent_programs prg,

474: -- which is being run
475: --
476: CURSOR c_process_name IS
477: SELECT concurrent_program_name
478: FROM fnd_concurrent_programs prg,
479: fnd_concurrent_requests req
480: WHERE prg.concurrent_program_id = req.concurrent_program_id
481: AND req.request_id = fnd_global.conc_request_id;
482: --

Line 1799: ,fnd_concurrent_programs prg

1795: SELECT
1796: req.argument4
1797: FROM
1798: fnd_concurrent_requests req
1799: ,fnd_concurrent_programs prg
1800: WHERE req.concurrent_program_id = prg.concurrent_program_id
1801: AND req.program_application_id = prg.application_id
1802: AND prg.concurrent_program_name = 'HRI_MTHD_CHILD_PROCESS'
1803: AND req.request_id = fnd_global.conc_request_id;