APPS.OTA_TRB_INS dependencies on OTA_SUPPLIABLE_RESOURCES

Line 264: from ota_suppliable_resources osr

260: Where orb.event_id = p_rec.event_id
261: and orb.primary_venue_flag = 'Y'
262: and orb.supplied_resource_id in(
263: Select osr.supplied_resource_id
264: from ota_suppliable_resources osr
265: where osr.resource_type = 'V');
266: --
267: Cursor C_Sel3 is
268: SELECT resource_type

Line 269: FROM OTA_SUPPLIABLE_RESOURCES

265: where osr.resource_type = 'V');
266: --
267: Cursor C_Sel3 is
268: SELECT resource_type
269: FROM OTA_SUPPLIABLE_RESOURCES
270: WHERE SUPPLIED_RESOURCE_ID = p_rec.supplied_resource_id;
271: --
272: Cursor C_Sel4 is
273: Select null

Line 280: l_resource_type ota_suppliable_resources.resource_type%type;

276: ota_trb_ins.g_resource_booking_id_i;
277: --
278: l_proc varchar2(72) := g_package||'pre_insert';
279: l_exist varchar2(1);
280: l_resource_type ota_suppliable_resources.resource_type%type;
281: --
282: Begin
283: hr_utility.set_location('Entering:'||l_proc, 5);
284: --