APPS.OTA_COST_TRANSFER_TO_GL_PKG dependencies on OTA_BOOKING_STATUS_TYPES

Line 202: ota_booking_status_types bst,

198: CURSOR FL IS
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

Line 239: ota_booking_status_types bst,

235: /* CURSOR FL_CHK IS
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

Line 260: ota_booking_status_types bst,

256: CURSOR FL_CHK IS
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

Line 1124: FROM OTA_BOOKING_STATUS_TYPES

1120: booking_id in (Select Booking_id
1121: from OTA_DELEGATE_BOOKINGS
1122: WHERE booking_status_type_id in
1123: (Select Booking_status_type_id
1124: FROM OTA_BOOKING_STATUS_TYPES
1125: WHERE Type = 'A')); */
1126:
1127:
1128: /* Bug 3611693 Modified the cursor to take care of new Delivery Mode */

Line 1137: ota_booking_status_types bst,

1133: fl.date_raised,
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