APPS.DDR_TIME_TRANSFORM_PKG dependencies on DDR_R_DAY_TODATE_TRANS

Line 594: /* Populate DDR_R_DAY_TODATE_TRANS table */

590: and NYR.YR_CD(+) = YR.YR_CD + 1
591: ;
592:
593: /*Starting data population for todate transformations*/
594: /* Populate DDR_R_DAY_TODATE_TRANS table */
595: delete from DDR_R_DAY_TODATE_TRANS
596: where (DAY_CD,CLNDR_CD) in (
597: select DAY_CD,CLNDR_CD
598: from DDR_TIME_BSNS_DAY_V

Line 595: delete from DDR_R_DAY_TODATE_TRANS

591: ;
592:
593: /*Starting data population for todate transformations*/
594: /* Populate DDR_R_DAY_TODATE_TRANS table */
595: delete from DDR_R_DAY_TODATE_TRANS
596: where (DAY_CD,CLNDR_CD) in (
597: select DAY_CD,CLNDR_CD
598: from DDR_TIME_BSNS_DAY_V
599: where ORG_CD = p_org_cd

Line 603: INSERT INTO DDR_R_DAY_TODATE_TRANS(

599: where ORG_CD = p_org_cd
600: and YR_CD between to_char(p_start_year) and to_char(p_end_year)
601: );
602:
603: INSERT INTO DDR_R_DAY_TODATE_TRANS(
604: MFG_ORG_CD,
605: DAY_TODATE_TRANS_ID,
606: DAY_CD,
607: CLNDR_CD,

Line 622: DDR_R_DAY_TODATE_TRANS_SEQ.NEXTVAL,

618: LAST_UPDATE_LOGIN
619: )
620: select
621: YTD.MFG_ORG_CD,
622: DDR_R_DAY_TODATE_TRANS_SEQ.NEXTVAL,
623: YTD.DAY_CD,
624: YTD.CLNDR_CD,
625: 'BSNS',
626: YTD.YR_DAY_CD,