APPS.OKL_CNTRCT_FIN_EXT_MASTER_PVT dependencies on FND_CONCURRENT_REQUESTS

Line 95: from fnd_concurrent_requests req,

91: AND process_status = 'PENDING_ASSIGNMENT';
92:
93: CURSOR parent_sts_csr(p_request_id NUMBER) IS
94: SELECT count(*)
95: from fnd_concurrent_requests req,
96: fnd_concurrent_programs pgm
97: where req.PRIORITY_REQUEST_ID = p_request_id
98: and req.concurrent_program_id = pgm.concurrent_program_id
99: and req.PHASE_CODE = 'C'

Line 105: from fnd_concurrent_requests req,

101: and STATUS_CODE = 'E';
102:
103: CURSOR parent_warn_sts_csr(p_request_id NUMBER) IS
104: SELECT count(*)
105: from fnd_concurrent_requests req,
106: fnd_concurrent_programs pgm
107: where req.priority_request_id = p_request_id
108: and req.concurrent_program_id = pgm.concurrent_program_id
109: and req.phase_code = 'C'