APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on OTA_MAND_MULTI_ENR_REQUESTS

Line 55: FROM OTA_MAND_MULTI_ENR_REQUESTS

51: JOB_ID,
52: POSITION_ID,
53: USERGROUP_ID,
54: CERTIFICATION_ID
55: FROM OTA_MAND_MULTI_ENR_REQUESTS
56: WHERE conc_program_request_id = p_conc_request_id;
57:
58: CURSOR unprocessed_enrollments(l_conc_reqID NUMBER) IS
59: SELECT distinct

Line 89: OTA_MAND_MULTI_ENR_REQUESTS requests,

85: reqm.create_enrollment create_enrollment,
86: reqm.error_message error_message
87: FROM
88: OTA_MAND_MULTI_ENR_REQ_MEMBERS reqm,
89: OTA_MAND_MULTI_ENR_REQUESTS requests,
90: ota_events_tl evt_tl
91: WHERE
92: evt_tl.event_id = reqm.event_id
93: AND(reqm.create_enrollment = 'N' or reqm.error_message IS NOT NULL)

Line 107: OTA_MAND_MULTI_ENR_REQUESTS requests,

103: reqm.create_enrollment create_enrollment,
104: reqm.error_message error_message
105: FROM
106: OTA_MAND_MULTI_ENR_REQ_MEMBERS reqm,
107: OTA_MAND_MULTI_ENR_REQUESTS requests,
108: ota_certifications_tl cert_tl
109: WHERE
110: cert_tl.certification_id = reqm.certification_id
111: AND(reqm.create_enrollment = 'N' or reqm.error_message IS NOT NULL)