APPS.DDR_TIME_TRANSFORM_PKG dependencies on DDR_R_DAY_TRANS

Line 123: /* Populate DDR_R_DAY_TRANS table */

119: )
120: AS
121: BEGIN
122:
123: /* Populate DDR_R_DAY_TRANS table */
124: delete from DDR_R_DAY_TRANS
125: where (DAY_CD,CLNDR_CD) in (
126: select DAY_CD,CLNDR_CD
127: from DDR_TIME_BSNS_DAY_V

Line 124: delete from DDR_R_DAY_TRANS

120: AS
121: BEGIN
122:
123: /* Populate DDR_R_DAY_TRANS table */
124: delete from DDR_R_DAY_TRANS
125: where (DAY_CD,CLNDR_CD) in (
126: select DAY_CD,CLNDR_CD
127: from DDR_TIME_BSNS_DAY_V
128: where ORG_CD = p_org_cd

Line 132: insert into DDR_R_DAY_TRANS (

128: where ORG_CD = p_org_cd
129: and YR_CD between to_char(p_start_year) and to_char(p_end_year)
130: );
131:
132: insert into DDR_R_DAY_TRANS (
133: MFG_ORG_CD,
134: DAY_TRANS_ID,
135: DAY_CD,
136: CLNDR_CD,

Line 162: DDR_R_DAY_TRANS_SEQ.NEXTVAL,

158: LAST_UPDATE_LOGIN
159: )
160: select
161: BDAY.MFG_ORG_CD,
162: DDR_R_DAY_TRANS_SEQ.NEXTVAL,
163: BDAY.DAY_CD,
164: BDAY.CLNDR_CD,
165: 'BSNS',
166: PDAY.DAY_CD,