APPS.OTA_RUD_BUS dependencies on OTA_SUPPLIABLE_RESOURCES

Line 104: , ota_suppliable_resources tsr

100: cursor csr_leg_code is
101: select pbg.legislation_code
102: from per_business_groups_perf pbg
103: , ota_resource_usages rud
104: , ota_suppliable_resources tsr
105: where rud.resource_usage_id = p_resource_usage_id
106: and rud.supplied_resource_id = tsr.supplied_Resource_id
107: and pbg.business_group_id = tsr.business_group_id;
108: --

Line 306: from ota_suppliable_resources tsr

302: --
303: cursor c1 is
304: select tsr.start_date,
305: tsr.end_date
306: from ota_suppliable_resources tsr
307: where tsr.supplied_resource_id = p_supplied_resource_id;
308: --
309: begin
310: --

Line 362: from ota_suppliable_resources tsr,

358: l_ok varchar2 (3);
359: --
360: cursor c1 is
361: select 'YES'
362: from ota_suppliable_resources tsr,
363: ota_offerings off
364: where tsr.supplied_resource_id = p_supplied_resource_id
365: and off.offering_id = p_offering_id
366: and tsr.business_group_id = off.business_group_id;

Line 424: ota_suppliable_resources tsr

420: Cursor cur_res_type is
421: select
422: tsr.resource_type
423: from
424: ota_suppliable_resources tsr
425: where
426: tsr.supplied_resource_id = p_supplied_resource_id;
427:
428: Begin

Line 533: l_resource_type ota_suppliable_resources.resource_type%Type;

529: (p_rec in ota_rud_shd.g_rec_type
530: ) is
531: --
532: l_proc varchar2 (72) := g_package || 'check_usage_reason';
533: l_resource_type ota_suppliable_resources.resource_type%Type;
534: --
535: Cursor Get_Resource_type is
536: select resource_type
537: from ota_suppliable_resources

Line 537: from ota_suppliable_resources

533: l_resource_type ota_suppliable_resources.resource_type%Type;
534: --
535: Cursor Get_Resource_type is
536: select resource_type
537: from ota_suppliable_resources
538: where supplied_resource_id = p_rec.supplied_resource_id;
539: --
540: begin
541: --