648: AND A.YR_CD between to_char(p_start_year) and to_char(p_end_year)
649: ORDER BY A.DAY_CD,
650: B.DAY_CD) YTD;
651:
652: /* Populate DDR_R_WK_TODATE_TRANS table */
653: delete from DDR_R_WK_TODATE_TRANS
654: where (WK_CD,CLNDR_CD) in (
655: select WK_CD,CLNDR_CD
656: from DDR_TIME_BSNS_WK_V
649: ORDER BY A.DAY_CD,
650: B.DAY_CD) YTD;
651:
652: /* Populate DDR_R_WK_TODATE_TRANS table */
653: delete from DDR_R_WK_TODATE_TRANS
654: where (WK_CD,CLNDR_CD) in (
655: select WK_CD,CLNDR_CD
656: from DDR_TIME_BSNS_WK_V
657: where ORG_CD = p_org_cd
657: where ORG_CD = p_org_cd
658: and YR_CD between to_char(p_start_year) and to_char(p_end_year)
659: );
660:
661: INSERT INTO DDR_R_WK_TODATE_TRANS(
662: MFG_ORG_CD,
663: WK_TODATE_TRANS_ID,
664: WK_ID,
665: WK_CD,
678: LAST_UPDATE_LOGIN
679: )
680: select
681: YTD.MFG_ORG_CD,
682: DDR_R_WK_TODATE_TRANS_SEQ.NEXTVAL,
683: YTD.WK_ID,
684: YTD.WK_CD,
685: YTD.CLNDR_CD,
686: 'BSNS',