DBA Data[Home] [Help]

APPS.HR_SUIT_MATCH_UTILITY_WEB dependencies on OTA_EVENTS

Line 3413: FROM ota_events oe

3409:
3410: CURSOR csr_course_by_person IS
3411: SELECT distinct(oe.activity_version_id) activity_version_id
3412: ,oav.version_name
3413: FROM ota_events oe
3414: ,ota_delegate_bookings odb
3415: ,ota_activity_versions oav
3416: WHERE odb.delegate_person_id = p_person_id
3417: AND odb.event_id = oe.event_id

Line 3445: FROM ota_events oe

3441: SELECT odb.delegate_person_id person_id
3442: FROM ota_delegate_bookings odb
3443: WHERE odb.event_id IN
3444: (SELECT oe.event_id
3445: FROM ota_events oe
3446: WHERE oe.activity_version_id = p_activity_version_id);
3447:
3448: BEGIN
3449: