DBA Data[Home] [Help]

APPS.OTA_COST_TRANSFER_TO_GL_PKG dependencies on OTA_EVENTS

Line 203: ota_events evt,

199: SELECT sum(fl.money_amount)
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

Line 240: ota_events evt

236: SELECT null
237: FROM ota_finance_lines fl,
238: ota_delegate_bookings tdb,
239: ota_booking_status_types bst,
240: ota_events evt
241: WHERE fl.finance_header_id = l_finance_header_id and
242: tdb.booking_id = fl.booking_id and
243: bst.booking_status_type_id = tdb.booking_status_type_id and
244: evt.event_id = tdb.event_id and

Line 261: ota_events evt,

257: SELECT null
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

Line 1138: ota_events evt,

1134: fl.sequence_number
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