APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on FND_CONCURRENT_PROGRAMS

Line 139: select 1 from fnd_concurrent_requests fcr, fnd_concurrent_programs fcp

135: requestor_id dbms_sql.number_table
136: );
137:
138: cursor csr_check_mand_multi_running(c_conc_req_id fnd_concurrent_requests.REQUEST_ID%type) is
139: select 1 from fnd_concurrent_requests fcr, fnd_concurrent_programs fcp
140: where fcp.CONCURRENT_PROGRAM_NAME = 'OTA_MAND_ENR_MULTI'
141: and fcp.CONCURRENT_PROGRAM_ID = fcr.CONCURRENT_PROGRAM_ID
142: and fcr.STATUS_CODE = 'R' and nvl(PARENT_REQUEST_ID,-1) = -1
143: and fcr.REQUEST_ID <> c_conc_req_id;