DBA Data[Home] [Help]

APPS.OTA_COST_TRANSFER_TO_GL_PKG dependencies on OTA_CATEGORY_USAGES

Line 204: ota_category_usages ocu,

200: FROM ota_finance_lines fl,
201: ota_delegate_bookings tdb,
202: ota_booking_status_types bst,
203: ota_events evt,
204: ota_category_usages ocu,
205: ota_offerings off
206: WHERE fl.finance_header_id = l_finance_header_id and
207: tdb.booking_id = fl.booking_id and
208: bst.booking_status_type_id = tdb.booking_status_type_id and

Line 262: ota_category_usages ocu,

258: FROM ota_finance_lines fl,
259: ota_delegate_bookings tdb,
260: ota_booking_status_types bst,
261: ota_events evt,
262: ota_category_usages ocu,
263: ota_offerings off
264: WHERE fl.finance_header_id = l_finance_header_id and
265: tdb.booking_id = fl.booking_id and
266: bst.booking_status_type_id = tdb.booking_status_type_id and

Line 1139: ota_category_usages ocu,

1135: FROM ota_finance_lines fl,
1136: ota_delegate_bookings tdb,
1137: ota_booking_status_types bst,
1138: ota_events evt,
1139: ota_category_usages ocu,
1140: ota_offerings off
1141: WHERE fl.finance_header_id = p_finance_header_id and
1142: tdb.booking_id = fl.booking_id and
1143: bst.booking_status_type_id = tdb.booking_status_type_id and