APPS.CSD_RECALLS_PVT dependencies on CSD_RECALL_METRICS_S1

Line 1239: INSERT INTO csd_recall_metrics(metric_id,recall_number) values(csd_recall_metrics_s1.NEXTVAL,p_recall_number)

1235: l_metric_ids(1) := -1;
1236: END;
1237: IF l_metric_ids(1) = -1
1238: THEN
1239: INSERT INTO csd_recall_metrics(metric_id,recall_number) values(csd_recall_metrics_s1.NEXTVAL,p_recall_number)
1240: RETURNING metric_id INTO l_metric_ids(1);
1241: END IF;
1242: ELSE
1243: INSERT INTO csd_recall_metrics(metric_id,recall_number)

Line 1244: (SELECT csd_recall_metrics_s1.NEXTVAL,recall_number

1240: RETURNING metric_id INTO l_metric_ids(1);
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'