APPS.CSD_RECALLS_PVT dependencies on CSD_RECALL_STATUSES_B

Line 1245: FROM csd_recall_headers_b,csd_recall_statuses_b crs

1241: END IF;
1242: ELSE
1243: INSERT INTO csd_recall_metrics(metric_id,recall_number)
1244: (SELECT csd_recall_metrics_s1.NEXTVAL,recall_number
1245: FROM csd_recall_headers_b,csd_recall_statuses_b crs
1246: WHERE recall_flow_status_id = crs.status_id
1247: AND crs.status_code <> 'C'
1248: AND NOT EXISTS ( SELECT 'exists'
1249: FROM csd_recall_metrics crm

Line 1258: csd_recall_statuses_b crs

1254: SELECT DISTINCT metric_id
1255: BULK COLLECT INTO l_metric_ids
1256: FROM csd_recall_metrics crm,
1257: csd_recall_headers_b crh,
1258: csd_recall_statuses_b crs
1259: WHERE crh.recall_number = crm.recall_number
1260: AND crh.recall_flow_status_id = crs.status_id
1261: AND crs.status_code <> 'C'
1262: AND crm.metric_id NOT IN (SELECT * FROM TABLE(CAST(l_metric_ids AS JTF_NUMBER_TABLE)));