APPS.AMS_METRIC_FORMULA_PVT dependencies on AMS_METRICS_ALL_B

Line 1014: FROM ams_metrics_all_b

1010: )
1011: IS
1012: CURSOR c_check_metric_parent(p_metric_id NUMBER) IS
1013: SELECT arc_metric_used_for_object, metric_calculation_type
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

Line 1029: SELECT arc_metric_used_for_object FROM ams_metrics_all_b

1025: and parent_category_id = p_category_id
1026: and arc_category_created_for = 'METR';
1027:
1028: CURSOR c_check_metric_source(p_metric_id NUMBER) IS
1029: SELECT arc_metric_used_for_object FROM ams_metrics_all_b
1030: WHERE metric_id = p_metric_id
1031: and metric_calculation_type <> 'FORMULA';
1032:
1033: l_dummy NUMBER;

Line 1698: l_formula_str ams_metrics_all_b.formula%type;

1694: AND excsubcat.lookup_type = 'AMS_METRIC_STRINGS'
1695: AND excsubcat.lookup_code = 'EXC_SUB_CAT'
1696: ORDER BY f.sequence ASC ;
1697:
1698: l_formula_str ams_metrics_all_b.formula%type;
1699: l_return_status varchar2(1);
1700: l_msg_count number;
1701: l_msg_data varchar2(4000);
1702: