APPS.AMS_METRIC_FORMULA_PVT dependencies on AMS_CATEGORIES_VL

Line 1018: SELECT count(1) FROM AMS_CATEGORIES_VL

1014: FROM ams_metrics_all_b
1015: WHERE metric_id = p_metric_id;
1016:
1017: CURSOR c_check_category(p_CATEGORY_ID NUMBER) IS
1018: SELECT count(1) FROM AMS_CATEGORIES_VL
1019: WHERE CATEGORY_ID = p_CATEGORY_ID
1020: and arc_category_created_for = 'METR';
1021:
1022: CURSOR c_check_sub_category(p_CATEGORY_ID NUMBER, p_SUB_CATEGORY_ID NUMBER) IS

Line 1023: SELECT count(1) FROM AMS_CATEGORIES_VL

1019: WHERE CATEGORY_ID = p_CATEGORY_ID
1020: and arc_category_created_for = 'METR';
1021:
1022: CURSOR c_check_sub_category(p_CATEGORY_ID NUMBER, p_SUB_CATEGORY_ID NUMBER) IS
1023: SELECT count(1) FROM AMS_CATEGORIES_VL
1024: WHERE CATEGORY_ID = p_SUB_CATEGORY_ID
1025: and parent_category_id = p_category_id
1026: and arc_category_created_for = 'METR';
1027:

Line 1679: ams_categories_vl c, ams_categories_vl sc, ams_lookups delim,

1675: f.source_value ,
1676: f.source_id,
1677: f.source_sub_id
1678: FROM ams_metric_formulas f, ams_metrics_vl m, ams_lookups opers,
1679: ams_categories_vl c, ams_categories_vl sc, ams_lookups delim,
1680: ams_lookups incsubcat, ams_lookups excsubcat
1681: WHERE f.metric_id = l_metric_id
1682: AND f.source_id = m.metric_id(+)
1683: AND f.source_id = c.category_id(+)