APPS.AMS_REFRESHMETRIC_PVT dependencies on AMS_CUSTOM_SETUP_ATTR

Line 2493: FROM ams_custom_setup_attr

2489: CURSOR c_setup_attrs (p_custom_setup_id NUMBER) IS
2490: SELECT MAX (DECODE (object_attribute, 'COST', 1, 0)) cost_flag
2491: , MAX (DECODE (object_attribute, 'AMET', 1, 0)) amet_flag
2492: , MAX (DECODE (object_attribute, 'TRACK', 1, 0)) track_flag
2493: FROM ams_custom_setup_attr
2494: WHERE attr_available_flag = 'Y'
2495: AND custom_setup_id = p_custom_setup_id
2496: AND object_attribute IN ('COST', 'AMET', 'TRACK')
2497: ;

Line 2502: FROM ams_custom_setup_attr

2498:
2499: /*** cursor does one pass
2500: CURSOR c_setup_attrs(p_custom_setup_id NUMBER) IS
2501: SELECT object_attribute
2502: FROM ams_custom_setup_attr
2503: WHERE attr_available_flag = 'Y'
2504: AND custom_setup_id = p_custom_setup_id
2505: AND object_attribute IN ('COST', 'AMET');
2506: ***/

Line 2509: l_object_attribute ams_custom_setup_attr.OBJECT_ATTRIBUTE%TYPE;

2505: AND object_attribute IN ('COST', 'AMET');
2506: ***/
2507:
2508: l_setup_rec c_setup_attrs%ROWTYPE;
2509: l_object_attribute ams_custom_setup_attr.OBJECT_ATTRIBUTE%TYPE;
2510: l_metric_id NUMBER;
2511: l_metric_category NUMBER;
2512: l_custom_setup_id NUMBER := NULL;
2513: l_act_metrics_rec Ams_Actmetric_Pvt.act_metric_rec_type;