DBA Data[Home] [Help]

APPS.OTA_COST_TRANSFER_TO_GL_PKG dependencies on OTA_SUPPLIABLE_RESOURCES

Line 309: ota_suppliable_resources tsr

305: CURSOR FL_RESOURCE IS
306: SELECT sum(fl.money_amount)
307: FROM ota_finance_lines fl,
308: ota_resource_bookings trb,
309: ota_suppliable_resources tsr
310: WHERE fl.finance_header_id = l_finance_header_id and
311: trb.resource_booking_id = fl.resource_booking_id and
312: trb.required_date_to < (trunc(SYSDATE)+1) and
313: tsr.supplied_resource_id = trb.supplied_resource_id and