APPS.OTA_BULK_ENROLL_UTIL dependencies on OTA_CPR_UTILITY

Line 228: AND ota_cpr_utility.is_mand_crs_prereqs_completed(brm.person_id

224: WHERE ber.bulk_enr_request_id = brm.bulk_enr_request_id
225: AND ber.bulk_enr_request_id = p_bulk_enr_request_id
226: AND evt.event_id = ber.object_id
227: AND ber.object_type = 'CL'
228: AND ota_cpr_utility.is_mand_crs_prereqs_completed(brm.person_id
229: , NULL
230: , brm.person_id
231: , 'E'
232: , evt.activity_version_id) = 'N';

Line 243: AND ota_cpr_utility.is_mand_comp_prereqs_completed(brm.person_id, evt.activity_version_id) = 'N';

239: WHERE ber.bulk_enr_request_id = brm.bulk_enr_request_id
240: AND ber.bulk_enr_request_id = p_bulk_enr_request_id
241: AND evt.event_id = ber.object_id
242: AND ber.object_type = 'CL'
243: AND ota_cpr_utility.is_mand_comp_prereqs_completed(brm.person_id, evt.activity_version_id) = 'N';
244:
245: BEGIN
246: p_unfulfil_course_prereqs := 0;
247: p_unfulfil_comp_prereqs := 0;