APPS.OTA_TAV_API_BUSINESS_RULES dependencies on OTA_CATEGORY_USAGES

Line 1003: ota_category_usages ctu,

999: select
1000: ctu.start_date_active,
1001: nvl(ctu.end_date_active, hr_api.g_eot)
1002: from
1003: ota_category_usages ctu,
1004: ota_act_cat_inclusions aci
1005: where
1006: ctu.category_usage_id = aci.category_usage_id
1007: and aci.activity_version_id = p_activity_version_id

Line 2141: select 1 from ota_offerings off,ota_category_usages cat

2137: ota_activity_versions
2138: where activity_version_id <> p_activity_version_id;
2139:
2140: cursor cur_offerings is
2141: select 1 from ota_offerings off,ota_category_usages cat
2142: where cat.type ='DM'
2143: and (cat.online_flag = 'Y' or( cat.online_flag = 'N' and cat.synchronous_flag = 'N'))
2144: and cat.category_usage_id = off.delivery_mode_id
2145: and off.activity_version_id = p_activity_version_id;