APPS.OTA_TRB_BUS dependencies on OTA_SUPPLIABLE_RESOURCES

Line 36: , ota_suppliable_resources tsr

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;
40: --

Line 108: , ota_suppliable_Resources tsr

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;
112: --

Line 433: from ota_suppliable_resources

429: l_resource_type varchar2(30);
430:
431: cursor get_resource_type is
432: select resource_type
433: from ota_suppliable_resources
434: where supplied_resource_id = p_rec.supplied_resource_id;
435: --
436: Begin
437: hr_utility.set_location('Entering:'||l_proc, 5);

Line 669: from ota_suppliable_resources

665: l_resource_type varchar2(30);
666:
667: cursor get_resource_type is
668: select resource_type
669: from ota_suppliable_resources
670: where supplied_resource_id = p_rec.supplied_resource_id;
671:
672: --
673: Begin