APPS.DDR_TIME_TRANSFORM_PKG dependencies on DDR_R_MNTH_TRANS

Line 353: /* Populate DDR_R_MNTH_TRANS table */

349: and NYR.CLNDR_CD(+) = WK.CLNDR_CD
350: and NYR.WK_CD(+) = add_week(WK.WK_CD,52)
351: ;
352:
353: /* Populate DDR_R_MNTH_TRANS table */
354: delete from DDR_R_MNTH_TRANS
355: where (MNTH_CD,CLNDR_CD) in (
356: select MNTH_CD,CLNDR_CD
357: from DDR_TIME_BSNS_MNTH_V

Line 354: delete from DDR_R_MNTH_TRANS

350: and NYR.WK_CD(+) = add_week(WK.WK_CD,52)
351: ;
352:
353: /* Populate DDR_R_MNTH_TRANS table */
354: delete from DDR_R_MNTH_TRANS
355: where (MNTH_CD,CLNDR_CD) in (
356: select MNTH_CD,CLNDR_CD
357: from DDR_TIME_BSNS_MNTH_V
358: where ORG_CD = p_org_cd

Line 362: insert into DDR_R_MNTH_TRANS (

358: where ORG_CD = p_org_cd
359: and YR_CD between to_char(p_start_year) and to_char(p_end_year)
360: );
361:
362: insert into DDR_R_MNTH_TRANS (
363: MFG_ORG_CD,
364: MNTH_TRANS_ID,
365: MNTH_ID,
366: MNTH_CD,

Line 393: DDR_R_MNTH_TRANS_SEQ.NEXTVAL,

389: LAST_UPDATE_LOGIN
390: )
391: select
392: MNTH.MFG_ORG_CD,
393: DDR_R_MNTH_TRANS_SEQ.NEXTVAL,
394: MNTH.MNTH_ID,
395: MNTH.MNTH_CD,
396: MNTH.CLNDR_CD,
397: 'BSNS',