APPS.OTA_ACI_BUS dependencies on OTA_CATEGORY_USAGES

Line 35: , ota_category_usages ctu

31: select pbg.security_group_id,
32: pbg.legislation_code
33: from per_business_groups_perf pbg
34: , ota_act_cat_inclusions aci
35: , ota_category_usages ctu
36: where aci.activity_version_id = p_activity_version_id
37: and aci.category_usage_id = p_category_usage_id
38: and pbg.business_group_id = ctu.business_group_id
39: and ctu.category_usage_id = aci.category_usage_id;

Line 116: , ota_category_usages ctu

112: cursor csr_leg_code is
113: select pbg.legislation_code
114: from per_business_groups_perf pbg
115: , ota_act_cat_inclusions aci
116: , ota_category_usages ctu
117: where aci.activity_version_id = p_activity_version_id
118: and aci.category_usage_id = p_category_usage_id
119: and pbg.business_group_id = ctu.business_group_id
120: and ctu.category_usage_id = aci.category_usage_id ;

Line 404: FROM ota_category_usages

400: SELECT
401: start_date_active,
402: nvl(end_date_active, hr_api.g_eot ),
403: type
404: FROM ota_category_usages
405: WHERE category_usage_id =p_category_usage_id;
406:
407: CURSOR csr_course_start_end_date IS
408: SELECT

Line 659: from ota_category_usages aci

655: --
656: cursor sel_check_dates is
657: select start_date_active
658: , end_date_active
659: from ota_category_usages aci
660: where aci.category_usage_id = p_category_usage_id;
661: --
662: Begin
663: --