APPS.DDR_TIME_TRANSFORM_PKG dependencies on DDR_R_MNTH_TODATE_TRANS

Line 716: /* Populate DDR_R_MNTH_TODATE_TRANS table */

712: AND A.YR_CD between to_char(p_start_year) and to_char(p_end_year)
713: ORDER BY A.WK_CD,
714: B.WK_CD) YTD;
715:
716: /* Populate DDR_R_MNTH_TODATE_TRANS table */
717: delete from DDR_R_MNTH_TODATE_TRANS
718: where (MNTH_CD,CLNDR_CD) in (
719: select MNTH_CD,CLNDR_CD
720: from DDR_TIME_BSNS_MNTH_V

Line 717: delete from DDR_R_MNTH_TODATE_TRANS

713: ORDER BY A.WK_CD,
714: B.WK_CD) YTD;
715:
716: /* Populate DDR_R_MNTH_TODATE_TRANS table */
717: delete from DDR_R_MNTH_TODATE_TRANS
718: where (MNTH_CD,CLNDR_CD) in (
719: select MNTH_CD,CLNDR_CD
720: from DDR_TIME_BSNS_MNTH_V
721: where ORG_CD = p_org_cd

Line 725: INSERT INTO DDR_R_MNTH_TODATE_TRANS(

721: where ORG_CD = p_org_cd
722: and YR_CD between to_char(p_start_year) and to_char(p_end_year)
723: );
724:
725: INSERT INTO DDR_R_MNTH_TODATE_TRANS(
726: MFG_ORG_CD,
727: MNTH_TODATE_TRANS_ID,
728: MNTH_ID,
729: MNTH_CD,

Line 746: DDR_R_MNTH_TODATE_TRANS_SEQ.NEXTVAL,

742: LAST_UPDATE_LOGIN
743: )
744: select
745: YTD.MFG_ORG_CD,
746: DDR_R_MNTH_TODATE_TRANS_SEQ.NEXTVAL,
747: YTD.MNTH_ID,
748: YTD.MNTH_CD,
749: YTD.CLNDR_CD,
750: 'BSNS',