APPS.OTA_CCI_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_cert_cat_inclusions cci
35: , ota_category_usages ctu
36: where ctu.category_usage_id = p_category_usage_id
37: and cci.category_usage_id = ctu.category_usage_id
38: and cci.certification_id = p_certification_id
39: and pbg.business_group_id = ctu.business_group_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_cert_cat_inclusions cci
116: , ota_category_usages ctu
117: where ctu.category_usage_id = p_category_usage_id
118: and cci.category_usage_id = ctu.category_usage_id
119: and cci.certification_id = p_certification_id
120: and pbg.business_group_id = ctu.business_group_id;

Line 401: FROM ota_category_usages

397: CURSOR csr_cat_start_end_date is
398: SELECT
399: start_date_active,
400: nvl(end_date_active, to_date ('31-12-4712', 'DD-MM-YYYY'))
401: FROM ota_category_usages
402: WHERE category_usage_id =p_category_usage_id;
403:
404: CURSOR csr_cert_start_end_date IS
405: SELECT start_date_active,

Line 819: from ota_category_usages ctu

815: --
816: cursor sel_check_dates is
817: select start_date_active
818: , end_date_active
819: from ota_category_usages ctu
820: where ctu.category_usage_id = p_category_usage_id;
821: --
822: Begin
823: --