APPS.OTA_BULK_ENROLL_UTIL dependencies on OTA_LP_MEMBER_ENROLLMENTS

Line 1718: ota_lp_member_enrollments lme,

1714: SELECT
1715: lme.lp_member_enrollment_id
1716: from
1717: ota_lp_enrollments lpe,
1718: ota_lp_member_enrollments lme,
1719: OTA_LEARNING_PATH_MEMBERS lpm,
1720: ota_events evt
1721: where lpe.learning_path_id= l_lp_id
1722: AND lpe.person_id = l_person_id

Line 1843: UPDATE ota_lp_member_enrollments

1839: AND bulk_enr_request_id = p_enr_request_id;
1840:
1841: FOR lp_mem_enr_to_upd_rec IN csr_get_lp_member_to_upd(l_req_member_rec.person_id, l_request_rec.parent_object_id,l_request_rec.object_id) loop
1842:
1843: UPDATE ota_lp_member_enrollments
1844: SET event_id= l_request_rec.object_id
1845: where lp_member_enrollment_id = lp_mem_enr_to_upd_rec.lp_member_enrollment_id;
1846:
1847: end loop;

Line 1895: UPDATE ota_lp_member_enrollments

1891: AND bulk_enr_request_id = p_enr_request_id;
1892:
1893:
1894: FOR lp_mem_enr_to_upd_rec IN csr_get_lp_member_to_upd(l_req_member_rec.person_id, l_request_rec.parent_object_id,l_request_rec.object_id) loop
1895: UPDATE ota_lp_member_enrollments
1896: SET event_id= l_request_rec.object_id
1897: where lp_member_enrollment_id = lp_mem_enr_to_upd_rec.lp_member_enrollment_id;
1898:
1899: end loop;