APPS.OTA_LCI_BUS dependencies on OTA_CATEGORY_USAGES

Line 34: , ota_category_usages ctu

30: cursor csr_sec_grp is
31: select pbg.security_group_id,
32: pbg.legislation_code
33: from per_business_groups_perf pbg
34: , ota_category_usages ctu
35: , ota_lp_cat_inclusions lci
36: where ctu.category_usage_id = p_category_usage_id
37: and lci.category_usage_id = ctu.category_usage_id
38: and lci.learning_path_id = p_learning_path_id

Line 116: ,ota_category_usages ctu

112: --
113: cursor csr_leg_code is
114: select pbg.legislation_code
115: from per_business_groups_perf pbg
116: ,ota_category_usages ctu
117: ,ota_lp_cat_inclusions lci
118: where ctu.category_usage_id = p_category_usage_id
119: and lci.category_usage_id = ctu.category_usage_id
120: and lci.learning_path_id = p_learning_path_id

Line 402: FROM ota_category_usages

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

Line 825: from ota_category_usages ctu

821: --
822: cursor sel_check_dates is
823: select start_date_active
824: , end_date_active
825: from ota_category_usages ctu
826: where ctu.category_usage_id = p_category_usage_id;
827: --
828: Begin
829: --