APPS.DDR_BASE_UTIL_PKG dependencies on DDR_S_SYND_CNSMPTN_DATA

Line 1544: FROM ddr_s_synd_cnsmptn_data

1540: v_FUNC_MSG VARCHAR2(1) := 'N';
1541:
1542: CURSOR c1 IS
1543: SELECT *
1544: FROM ddr_s_synd_cnsmptn_data
1545: WHERE (MEASURE_SET, SRC_CD, CHNL_TYP_CD, GEO_SUB_RGN_ID, GEO_RGN_ID,MFG_ITM_HCHY_LVL,
1546: MFG_ITM_HCHY_ID, MKT_AREA_ID, RTL_ORG_HCHY_LVL, RTL_ORG_HCHY_ID,RTL_ORG_CD, PERIOD_ID,AO_HCHY_CD ,ACCT_CD)
1547: IN (SELECT MEASURE_SET, SRC_CD, CHNL_TYP_CD, GEO_SUB_RGN_ID, GEO_RGN_ID,MFG_ITM_HCHY_LVL,
1548: MFG_ITM_HCHY_ID, MKT_AREA_ID, RTL_ORG_HCHY_LVL, RTL_ORG_HCHY_ID,RTL_ORG_CD, PERIOD_ID, AO_HCHY_CD,ACCT_CD

Line 1549: FROM ddr_s_synd_cnsmptn_data

1545: WHERE (MEASURE_SET, SRC_CD, CHNL_TYP_CD, GEO_SUB_RGN_ID, GEO_RGN_ID,MFG_ITM_HCHY_LVL,
1546: MFG_ITM_HCHY_ID, MKT_AREA_ID, RTL_ORG_HCHY_LVL, RTL_ORG_HCHY_ID,RTL_ORG_CD, PERIOD_ID,AO_HCHY_CD ,ACCT_CD)
1547: IN (SELECT MEASURE_SET, SRC_CD, CHNL_TYP_CD, GEO_SUB_RGN_ID, GEO_RGN_ID,MFG_ITM_HCHY_LVL,
1548: MFG_ITM_HCHY_ID, MKT_AREA_ID, RTL_ORG_HCHY_LVL, RTL_ORG_HCHY_ID,RTL_ORG_CD, PERIOD_ID, AO_HCHY_CD,ACCT_CD
1549: FROM ddr_s_synd_cnsmptn_data
1550: GROUP BY MEASURE_SET, SRC_CD, CHNL_TYP_CD, GEO_SUB_RGN_ID, GEO_RGN_ID,MFG_ITM_HCHY_LVL,
1551: MFG_ITM_HCHY_ID, MKT_AREA_ID, RTL_ORG_HCHY_LVL, RTL_ORG_HCHY_ID,RTL_ORG_CD, PERIOD_ID, AO_HCHY_CD,ACCT_CD
1552: HAVING COUNT(*) > 1)
1553: FOR UPDATE;

Line 1616: DELETE ddr_s_synd_cnsmptn_data

1612: rec.RTL_ORG_CD,rec.AO_HCHY_CD,rec.ACCT_CD
1613: );
1614:
1615: -- delete duplicate records from staging table --
1616: DELETE ddr_s_synd_cnsmptn_data
1617: WHERE CURRENT OF c1;
1618:
1619: END LOOP; --}
1620: