APPS.HR_SUIT_MATCH_UTILITY_WEB dependencies on OTA_ACTIVITY_VERSIONS

Line 805: ||' FROM ota_activity_versions'

801: ||p_ids
802: ||')';
803: ELSIF p_search_type = g_class_type THEN --class
804: l_dynamic_sql := 'SELECT activity_version_id, version_name'
805: ||' FROM ota_activity_versions'
806: ||' WHERE activity_version_id IN ('
807: ||p_ids
808: ||')';
809: ELSIF p_search_type = g_people_type THEN --people

Line 3415: ,ota_activity_versions oav

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;
3419: