APPS.OTA_EVT_SHD dependencies on OTA_FINANCE_LINES
Line 970: from OTA_FINANCE_LINES TFL,
966: ) return number is
967: --
968: cursor C1 is
969: select sum (TFL.MONEY_AMOUNT) 970: from OTA_FINANCE_LINES TFL, 971: OTA_DELEGATE_BOOKINGS TDB
972: where TDB.EVENT_ID = P_EVENT_ID
973: and TFL.BOOKING_ID = TDB.BOOKING_ID
974: and TFL.CANCELLED_FLAG <> 'Y';