DBA Data[Home] [Help]

APPS.OTA_BULK_ENROLL_UTIL dependencies on OTA_BULK_ENR_REQUESTS

Line 17: FROM ota_bulk_enr_requests ber

13: , ber.conc_program_request_id
14: , ber.requestor_id
15: , ber.business_group_id
16: ,ber.parent_object_id
17: FROM ota_bulk_enr_requests ber
18: WHERE ber.bulk_enr_request_id = p_enr_request_id;
19:
20: CURSOR csr_get_all_requests(p_enr_request_id NUMBER,p_enr_request_id_end NUMBER) IS
21: SELECT ber.object_type

Line 28: FROM ota_bulk_enr_requests ber

24: , ber.requestor_id
25: , ber.business_group_id
26: ,ber.bulk_enr_request_id
27: ,ber.parent_object_id
28: FROM ota_bulk_enr_requests ber
29: WHERE ber.bulk_enr_request_id between p_enr_request_id and p_enr_request_id_end;
30: CURSOR csr_get_request_members(p_enr_request_id NUMBER) IS
31: SELECT person_id, assignment_id, enrollment_status, error_message, booking_id --added bookingid for 12426494
32: FROM ota_bulk_enr_req_members