APPS.OTA_COST_TRANSFER_TO_GL_PKG dependencies on OTA_DELEGATE_BOOKINGS

Line 47: l_single_business_group_id ota_delegate_bookings.business_group_id%type:=

43: l_rec_desc VARCHAR2(35) := 'ota_receiving_cc_batch_generated';
44: l_value fnd_profile_option_values.profile_option_value%TYPE;
45: l_finance_header_id OTA_FINANCE_HEADERS.FINANCE_HEADER_ID%type;
46: l_exist varchar2(1);
47: l_single_business_group_id ota_delegate_bookings.business_group_id%type:=
48: fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
49: l_business_group_id ota_delegate_bookings.business_group_id%type:= null;
50:
51: ---*** New variables declared for Bug#2457158

Line 49: l_business_group_id ota_delegate_bookings.business_group_id%type:= null;

45: l_finance_header_id OTA_FINANCE_HEADERS.FINANCE_HEADER_ID%type;
46: l_exist varchar2(1);
47: l_single_business_group_id ota_delegate_bookings.business_group_id%type:=
48: fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
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;

Line 52: l_booking_id ota_delegate_bookings.booking_id%TYPE;

48: fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
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

Line 201: ota_delegate_bookings tdb,

197: /* Bug 3611693 Modified the cursor to take care of new Delivery Mode */
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

Line 238: ota_delegate_bookings tdb,

234: ---*** for the cursor FL_CHK for bug#2457158.
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

Line 259: ota_delegate_bookings tdb,

255: /* bug no 3611693 Modified the cursor to take care of delivery mode*/
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

Line 1121: from OTA_DELEGATE_BOOKINGS

1117: sequence_number
1118: FROM ota_finance_lines
1119: WHERE finance_header_id = p_finance_header_id and
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')); */

Line 1136: ota_delegate_bookings tdb,

1132: fl.object_version_number,
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