APPS.DDR_TIME_TRANSFORM_PKG dependencies on DDR_R_QTR_TODATE_TRANS

Line 780: /* Populate DDR_R_QTR_TODATE_TRANS table */

776: AND A.YR_CD between to_char(p_start_year) and to_char(p_end_year)
777: ORDER BY A.MNTH_CD,
778: B.MNTH_CD) YTD;
779:
780: /* Populate DDR_R_QTR_TODATE_TRANS table */
781: delete from DDR_R_QTR_TODATE_TRANS
782: where (QTR_CD,CLNDR_CD) in (
783: select QTR_CD,CLNDR_CD
784: from DDR_TIME_BSNS_QTR_V

Line 781: delete from DDR_R_QTR_TODATE_TRANS

777: ORDER BY A.MNTH_CD,
778: B.MNTH_CD) YTD;
779:
780: /* Populate DDR_R_QTR_TODATE_TRANS table */
781: delete from DDR_R_QTR_TODATE_TRANS
782: where (QTR_CD,CLNDR_CD) in (
783: select QTR_CD,CLNDR_CD
784: from DDR_TIME_BSNS_QTR_V
785: where ORG_CD = p_org_cd

Line 789: INSERT INTO DDR_R_QTR_TODATE_TRANS(

785: where ORG_CD = p_org_cd
786: and YR_CD between to_char(p_start_year) and to_char(p_end_year)
787: );
788:
789: INSERT INTO DDR_R_QTR_TODATE_TRANS(
790: MFG_ORG_CD,
791: QTR_TODATE_TRANS_ID,
792: QTR_ID,
793: QTR_CD,

Line 810: DDR_R_QTR_TODATE_TRANS_SEQ.NEXTVAL,

806: LAST_UPDATE_LOGIN
807: )
808: select
809: YTD.MFG_ORG_CD,
810: DDR_R_QTR_TODATE_TRANS_SEQ.NEXTVAL,
811: YTD.QTR_ID,
812: YTD.QTR_CD,
813: YTD.CLNDR_CD,
814: 'BSNS',