APPS.DDR_BASE_UTIL_PKG dependencies on DDR_S_PRMTN_PLN

Line 1288: FROM ddr_s_prmtn_pln

1284: v_FUNC_MSG VARCHAR2(1) := 'N';
1285:
1286: CURSOR c1 IS
1287: SELECT *
1288: FROM ddr_s_prmtn_pln
1289: WHERE (prmtn_typ,prmtn_from_dt,prmtn_to_dt,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id)
1290: IN (SELECT prmtn_typ,prmtn_from_dt,prmtn_to_dt,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id
1291: FROM ddr_s_prmtn_pln
1292: GROUP BY prmtn_typ,prmtn_from_dt,prmtn_to_dt,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id

Line 1291: FROM ddr_s_prmtn_pln

1287: SELECT *
1288: FROM ddr_s_prmtn_pln
1289: WHERE (prmtn_typ,prmtn_from_dt,prmtn_to_dt,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id)
1290: IN (SELECT prmtn_typ,prmtn_from_dt,prmtn_to_dt,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id
1291: FROM ddr_s_prmtn_pln
1292: GROUP BY prmtn_typ,prmtn_from_dt,prmtn_to_dt,org_bsns_unit_id,mfg_sku_item_id,rtl_sku_item_id
1293: HAVING count(*) > 1)
1294: FOR UPDATE;
1295: BEGIN

Line 1395: DELETE ddr_s_prmtn_pln

1391: ,rec.ATTRIBUTE20
1392: );
1393:
1394: -- delete duplicate records from staging table --
1395: DELETE ddr_s_prmtn_pln
1396: WHERE CURRENT OF c1;
1397:
1398: END LOOP; --}
1399: