APPS.DDR_TIME_TRANSFORM_PKG dependencies on DDR_R_QTR_TRANS

Line 449: /* Populate DDR_R_QTR_TRANS table */

445: and NYR.CLNDR_CD(+) = MNTH.CLNDR_CD
446: and NYR.MNTH_CD(+) = add_month(MNTH.MNTH_CD,12)
447: ;
448:
449: /* Populate DDR_R_QTR_TRANS table */
450: delete from DDR_R_QTR_TRANS
451: where (QTR_CD,CLNDR_CD) in (
452: select QTR_CD,CLNDR_CD
453: from DDR_TIME_BSNS_QTR_V

Line 450: delete from DDR_R_QTR_TRANS

446: and NYR.MNTH_CD(+) = add_month(MNTH.MNTH_CD,12)
447: ;
448:
449: /* Populate DDR_R_QTR_TRANS table */
450: delete from DDR_R_QTR_TRANS
451: where (QTR_CD,CLNDR_CD) in (
452: select QTR_CD,CLNDR_CD
453: from DDR_TIME_BSNS_QTR_V
454: where ORG_CD = p_org_cd

Line 458: insert into DDR_R_QTR_TRANS (

454: where ORG_CD = p_org_cd
455: and YR_CD between to_char(p_start_year) and to_char(p_end_year)
456: );
457:
458: insert into DDR_R_QTR_TRANS (
459: MFG_ORG_CD,
460: QTR_TRANS_ID,
461: QTR_ID,
462: QTR_CD,

Line 485: DDR_R_QTR_TRANS_SEQ.NEXTVAL,

481: LAST_UPDATE_LOGIN
482: )
483: select
484: QTR.MFG_ORG_CD,
485: DDR_R_QTR_TRANS_SEQ.NEXTVAL,
486: QTR.QTR_ID,
487: QTR.QTR_CD,
488: QTR.CLNDR_CD,
489: 'BSNS',