APPS.OTA_UTILITY dependencies on OTA_LP_MEMBER_ENROLLMENTS

Line 3484: ota_lp_member_enrollments lpme

3480:
3481: CURSOR lp_cls_enroll_p IS
3482: SELECT lpe.lp_enrollment_id
3483: FROM ota_lp_enrollments lpe,
3484: ota_lp_member_enrollments lpme
3485: WHERE lpe.lp_enrollment_id = lpme.lp_enrollment_id AND
3486: lpe.enrollment_source_code = 'ADMIN' AND
3487: lpe.person_id = p_person_id AND
3488: lpme.event_id = p_event_id;

Line 3493: ota_lp_member_enrollments lpme

3489:
3490: CURSOR lp_cls_enroll_c IS
3491: SELECT lpe.lp_enrollment_id
3492: FROM ota_lp_enrollments lpe,
3493: ota_lp_member_enrollments lpme
3494: WHERE lpe.lp_enrollment_id = lpme.lp_enrollment_id AND
3495: lpe.enrollment_source_code = 'ADMIN' AND
3496: lpe.contact_id = p_contact_id AND
3497: lpme.event_id = p_event_id;