APPS.CN_SRP_PERIOD_QUOTAS_PKG dependencies on CN_SRP_PERIOD_QUOTAS_EXT_ALL

Line 1395: INTO cn_srp_period_quotas_ext_all

1391: END IF;
1392: FOR i_seq IN 2..l_number_dim
1393: LOOP
1394: INSERT
1395: INTO cn_srp_period_quotas_ext_all
1396: (
1397: srp_period_quota_ext_id,
1398: srp_period_quota_id ,
1399: input_sequence ,

Line 1419: FROM cn_srp_period_quotas_ext_all

1415: x_org_id
1416: FROM dual
1417: WHERE NOT EXISTS
1418: (SELECT 1
1419: FROM cn_srp_period_quotas_ext_all
1420: WHERE srp_period_quota_id = x_srp_period_quota_id
1421: AND input_sequence = i_seq
1422: );
1423: END LOOP;

Line 1426: FROM cn_srp_period_quotas_ext_all

1422: );
1423: END LOOP;
1424: ELSIF x_operation = 'DELETE' THEN
1425: DELETE
1426: FROM cn_srp_period_quotas_ext_all
1427: WHERE srp_period_quota_id = x_srp_period_quota_id;
1428: END IF;
1429: END;
1430: -- Name