APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on OTA_MANDATORY_ENR_REQUESTS

Line 39: FROM ota_mandatory_enr_requests

35: JOB_ID,
36: POSITION_ID,
37: USERGROUP_ID,
38: CERTIFICATION_ID
39: FROM ota_mandatory_enr_requests
40: WHERE conc_program_request_id = p_conc_request_id;
41:
42: CURSOR get_all_mand_multi_enr_reqs(p_conc_request_id IN NUMBER) IS
43: SELECT

Line 69: ota_mandatory_enr_requests requests,

65: reqm.create_enrollment create_enrollment,
66: reqm.error_message error_message
67: FROM
68: ota_mandatory_enr_req_members reqm,
69: ota_mandatory_enr_requests requests,
70: ota_events_tl evt_tl
71: WHERE
72: evt_tl.event_id = reqm.event_id
73: AND(reqm.create_enrollment = 'N' or reqm.error_message IS NOT NULL)