APPS.DDR_TIME_TRANSFORM_PKG dependencies on DDR_R_YR_TRANS

Line 529: /* Populate DDR_R_YR_TRANS table */

525: and NYR.CLNDR_CD(+) = QTR.CLNDR_CD
526: and NYR.QTR_CD(+) = add_quarter(QTR.QTR_CD,4)
527: ;
528:
529: /* Populate DDR_R_YR_TRANS table */
530: delete from DDR_R_YR_TRANS
531: where (YR_CD,CLNDR_CD) in (
532: select YR_CD,CLNDR_CD
533: from DDR_TIME_BSNS_YR_V

Line 530: delete from DDR_R_YR_TRANS

526: and NYR.QTR_CD(+) = add_quarter(QTR.QTR_CD,4)
527: ;
528:
529: /* Populate DDR_R_YR_TRANS table */
530: delete from DDR_R_YR_TRANS
531: where (YR_CD,CLNDR_CD) in (
532: select YR_CD,CLNDR_CD
533: from DDR_TIME_BSNS_YR_V
534: where ORG_CD = p_org_cd

Line 538: insert into DDR_R_YR_TRANS (

534: where ORG_CD = p_org_cd
535: and YR_CD between to_char(p_start_year) and to_char(p_end_year)
536: );
537:
538: insert into DDR_R_YR_TRANS (
539: MFG_ORG_CD,
540: YR_TRANS_ID,
541: YR_ID,
542: YR_CD,

Line 561: DDR_R_YR_TRANS_SEQ.NEXTVAL,

557: LAST_UPDATE_LOGIN
558: )
559: select
560: YR.MFG_ORG_CD,
561: DDR_R_YR_TRANS_SEQ.NEXTVAL,
562: YR.YR_ID,
563: YR.YR_CD,
564: YR.CLNDR_CD,
565: 'BSNS',

Line 1694: /* Populate DDR_R_YR_TRANS table */

1690: AND NQTR.QTR_CD(+) = add_quarter(QTR.QTR_CD,1)
1691: AND NYR.ORG_CD(+) = QTR.ORG_CD
1692: AND NYR.CLNDR_CD(+) = QTR.CLNDR_CD
1693: AND NYR.QTR_CD(+) = add_quarter(QTR.QTR_CD,4) ;
1694: /* Populate DDR_R_YR_TRANS table */
1695: DELETE
1696: FROM DDR_R_YR_TRANS
1697: WHERE (YR_CD,CLNDR_CD) IN
1698: (SELECT YR_CD,

Line 1696: FROM DDR_R_YR_TRANS

1692: AND NYR.CLNDR_CD(+) = QTR.CLNDR_CD
1693: AND NYR.QTR_CD(+) = add_quarter(QTR.QTR_CD,4) ;
1694: /* Populate DDR_R_YR_TRANS table */
1695: DELETE
1696: FROM DDR_R_YR_TRANS
1697: WHERE (YR_CD,CLNDR_CD) IN
1698: (SELECT YR_CD,
1699: CLNDR_CD
1700: FROM DDR_TIME_CLNDR_YR_V

Line 1704: INTO DDR_R_YR_TRANS

1700: FROM DDR_TIME_CLNDR_YR_V
1701: WHERE YR_CD BETWEEN TO_CHAR(p_start_year) AND TO_CHAR(p_end_year)
1702: );
1703: INSERT
1704: INTO DDR_R_YR_TRANS
1705: (
1706: MFG_ORG_CD,
1707: YR_TRANS_ID,
1708: YR_ID,

Line 1727: DDR_R_YR_TRANS_SEQ.NEXTVAL,

1723: LAST_UPDATE_DATE,
1724: LAST_UPDATE_LOGIN
1725: )
1726: SELECT YR.ORG_CD,
1727: DDR_R_YR_TRANS_SEQ.NEXTVAL,
1728: YR.CLNDR_YR_ID,
1729: YR.YR_CD,
1730: YR.CLNDR_CD,
1731: YR.CLNDR_TYP,