DBA Data[Home] [Help]

APPS.OTA_RUD_BUS dependencies on OTA_OFFERINGS

Line 32: , ota_offerings off

28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , ota_resource_usages rud
32: , ota_offerings off
33: where rud.resource_usage_id = p_resource_usage_id
34: and rud.offering_id = off.offering_id
35: and pbg.business_group_id = off.business_group_id;
36: --

Line 248: ota_offerings off

244: select
245: off.start_date
246: ,off.end_date
247: from
248: ota_offerings off
249: where
250: off.offering_id = p_offering_id;
251: --
252: begin

Line 363: ota_offerings off

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