DBA Data[Home] [Help]

APPS.OKL_CNTRCT_FIN_EXT_MASTER_PVT dependencies on FND_CONCURRENT_PROGRAMS

Line 96: fnd_concurrent_programs pgm

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'
100: and request_id <> p_request_id

Line 106: fnd_concurrent_programs pgm

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'
110: and request_id <> p_request_id