APPS.OTA_WF dependencies on OTA_DELEGATE_BOOKINGS

Line 1103: ota_delegate_bookings

1099: IS
1100: SELECT
1101: null
1102: FROM
1103: ota_delegate_bookings
1104: WHERE
1105: line_id = l_line_id;
1106:
1107:

Line 1227: ota_delegate_bookings tdb, ota_booking_status_types bst

1223: IS
1224: SELECT
1225: bst.type
1226: FROM
1227: ota_delegate_bookings tdb, ota_booking_status_types bst
1228: WHERE
1229: line_id = to_number(itemkey)AND
1230: bst.booking_status_type_id = tdb.booking_status_type_id;
1231:

Line 1339: ota_delegate_bookings tdb,

1335: IS
1336: SELECT
1337: bst.type
1338: FROM
1339: ota_delegate_bookings tdb,
1340: ota_booking_status_types bst
1341: WHERE
1342: line_id = to_number(itemkey)AND
1343: bst.booking_status_type_id = tdb.booking_status_type_id;

Line 1560: OTA_DELEGATE_BOOKINGS

1556: CURSOR C_ENROLLMENT IS
1557: SELECT
1558: Booking_status_type_id
1559: FROM
1560: OTA_DELEGATE_BOOKINGS
1561: WHERE
1562: Line_id = to_number(itemkey);
1563:
1564: --

Line 1836: ota_delegate_bookings tdb,

1832: IS
1833: SELECT
1834: bst.type
1835: FROM
1836: ota_delegate_bookings tdb,
1837: ota_booking_status_types bst
1838: WHERE
1839: event_id = l_event_id AND
1840: bst.booking_status_type_id = tdb.booking_status_type_id;