DBA Data[Home] [Help]

APPS.AMS_WFTRIG_PVT dependencies on AMS_ACT_METRICS_ALL

Line 1007: -- FROM ams_act_metrics_all

1003: l_chk2_metric_id NUMBER;
1004:
1005: -- CURSOR c_metric_det(p_metric_id NUMBER) IS
1006: -- SELECT arc_act_metric_used_by, arc_metric_used_by_id
1007: -- FROM ams_act_metrics_all
1008: -- WHERE activity_metric_id = p_metric_id;
1009:
1010: l_chk1_source_type VARCHAR2(30);
1011: l_chk2_source_type VARCHAR2(30);

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: