APPS.AMS_THLDCHK_PVT dependencies on AMS_ACT_METRICS_ALL

Line 1441: FROM ams_act_metrics_all act,ams_metrics_all_b met

1437: CURSOR c_met_det(l_act_met_id NUMBER) IS
1438: SELECT act.metric_uom_code metric_uom_code,
1439: act.transaction_currency_code transaction_currency_code,
1440: met.uom_type
1441: FROM ams_act_metrics_all act,ams_metrics_all_b met
1442: WHERE act.activity_metric_id = l_act_met_id
1443: AND act.metric_id = met.metric_id ;
1444:
1445: l_chk1_met_rec c_met_det%ROWTYPE;

Line 1584: l_table_name := 'ams_act_metrics_all' ;

1580: AMS_Utility_PVT.debug_message('Sonali 1');
1581:
1582: END IF;
1583:
1584: l_table_name := 'ams_act_metrics_all' ;
1585: l_pk_name := 'activity_metric_id' ;
1586: l_pk_value := l_thldchk_rec.chk1_source_code_metric_id ;
1587: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;
1588: l_additional_where_clause := ' arc_act_metric_used_by = '||''''

Line 1672: l_table_name := 'ams_act_metrics_all' ;

1668: -- FETCH c_source_det_eveo INTO l_chk2_source_id ;
1669: -- CLOSE c_source_det_eveo ;
1670: --END IF;
1671:
1672: l_table_name := 'ams_act_metrics_all' ;
1673: l_pk_name := 'activity_metric_id' ;
1674: l_pk_value := l_thldchk_rec.chk2_source_code_metric_id ;
1675: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;
1676: l_additional_where_clause := ' arc_act_metric_used_by = '||''''