APPS.AMS_UPGRADE_RECORDS_PKG dependencies on AMS_ACT_METRICS_ALL

Line 146: FROM ams_act_metrics_all c

142: AND TRUNC(a.last_update_date)= TRUNC(b.last_update_date)
143: )
144: )
145: AND NOT EXISTS (SELECT 1
146: FROM ams_act_metrics_all c
147: WHERE hst.activity_metric_id = c.activity_metric_id)
148: AND hst.activity_metric_id BETWEEN l_start_id AND l_end_id;
149:
150:

Line 322: WHERE NOT EXISTS (SELECT 'x' FROM ams_act_metrics_all b

318: a.EX_START_NODE,
319: a.HIERARCHY_TYPE,
320: a.DEPEND_ACT_METRIC
321: FROM ams_act_metric_hst a
322: WHERE NOT EXISTS (SELECT 'x' FROM ams_act_metrics_all b
323: WHERE a.activity_metric_id = b.activity_metric_id)
324: AND last_update_date =
325: (SELECT MAX(c.last_update_date)
326: FROM ams_act_metric_hst c