APPS.OTA_COST_TRANSFER_TO_GL_PKG dependencies on OTA_RESOURCE_BOOKINGS

Line 53: l_resource_booking_id ota_resource_bookings.resource_booking_id%TYPE;

49: l_business_group_id ota_delegate_bookings.business_group_id%type:= null;
50:
51: ---*** New variables declared for Bug#2457158
52: l_booking_id ota_delegate_bookings.booking_id%TYPE;
53: l_resource_booking_id ota_resource_bookings.resource_booking_id%TYPE;
54:
55:
56: CURSOR ota_fh_csr is
57: select

Line 308: ota_resource_bookings trb,

304:
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

Line 1178: ota_resource_bookings trb

1174: fl.object_version_number,
1175: fl.date_raised,
1176: fl.sequence_number
1177: FROM ota_finance_lines fl,
1178: ota_resource_bookings trb
1179: WHERE fl.finance_header_id = p_finance_header_id and
1180: trb.resource_booking_id = fl.resource_booking_id and
1181: trb.required_date_to < (trunc(SYSDATE)+1) and
1182: trb.status = 'C' and