DBA Data[Home] [Help]

APPS.OTA_TRB_BUS dependencies on OTA_RESOURCE_BOOKINGS

Line 35: , ota_resource_bookings trb

31: cursor csr_sec_grp is
32: select pbg.security_group_id,
33: pbg.legislation_code
34: from per_business_groups_perf pbg
35: , ota_resource_bookings trb
36: , ota_suppliable_resources tsr
37: where trb.resource_booking_id = p_resource_booking_id
38: and trb.supplied_resource_id = tsr.supplied_resource_id
39: and pbg.business_group_id = tsr.business_group_id;

Line 107: , ota_resource_bookings trb

103: --
104: cursor csr_leg_code is
105: select pbg.legislation_code
106: from per_business_groups_perf pbg
107: , ota_resource_bookings trb
108: , ota_suppliable_Resources tsr
109: where trb.resource_booking_id = p_resource_booking_id
110: and trb.supplied_resource_id = tsr.supplied_resource_id
111: and pbg.business_group_id = tsr.business_group_id;

Line 257: ,p_descflex_name => 'OTA_RESOURCE_BOOKINGS'

253: -- b) During insert.
254: --
255: hr_dflex_utility.ins_or_upd_descflex_attribs
256: (p_appl_short_name => 'OTA'
257: ,p_descflex_name => 'OTA_RESOURCE_BOOKINGS'
258: ,p_attribute_category => p_rec.trb_information_category
259: ,p_attribute1_name => 'TRB_INFORMATION1'
260: ,p_attribute1_value => p_rec.trb_information1
261: ,p_attribute2_name => 'TRB_INFORMATION2'