DBA Data[Home] [Help]

APPS.AMS_WFTRIG_PVT dependencies on AMS_METRICS_VL

Line 3409: FROM ams_metrics_vl met,ams_act_metrics_all act

3405: -- Cursor to get metric details if the trigger is created for Metric
3406: CURSOR c_metric_det(l_metric_id NUMBER) IS
3407: SELECT met.metrics_name metrics_name,act.act_metric_used_by_id metric_used_by_id,
3408: act.arc_act_metric_used_by metric_used_by
3409: FROM ams_metrics_vl met,ams_act_metrics_all act
3410: WHERE met.metric_id = act.metric_id
3411: AND act.activity_metric_id = l_metric_id ;
3412: l_metric_rec c_metric_det%ROWTYPE;
3413: