APPS.OTA_TAV_API_BUSINESS_RULES dependencies on OTA_CATEGORY_USAGES

Line 997: ota_category_usages ctu,

993: select
994: ctu.start_date_active,
995: nvl(ctu.end_date_active, hr_api.g_eot)
996: from
997: ota_category_usages ctu,
998: ota_act_cat_inclusions aci
999: where
1000: ctu.category_usage_id = aci.category_usage_id
1001: and aci.activity_version_id = p_activity_version_id

Line 2135: select 1 from ota_offerings off,ota_category_usages cat

2131: ota_activity_versions
2132: where activity_version_id <> p_activity_version_id;
2133:
2134: cursor cur_offerings is
2135: select 1 from ota_offerings off,ota_category_usages cat
2136: where cat.type ='DM'
2137: and (cat.online_flag = 'Y' or( cat.online_flag = 'N' and cat.synchronous_flag = 'N'))
2138: and cat.category_usage_id = off.delivery_mode_id
2139: and off.activity_version_id = p_activity_version_id;