DBA Data[Home] [Help]

APPS.HR_SUIT_MATCH_UTILITY_WEB dependencies on OTA_DELEGATE_BOOKINGS

Line 3414: ,ota_delegate_bookings odb

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
3418: AND oe.activity_version_id = oav.activity_version_id;

Line 3442: FROM ota_delegate_bookings odb

3438: ,p_count out nocopy number) IS
3439:
3440: CURSOR csr_people_by_course IS
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);