APPS.DDR_TIME_TRANSFORM_PKG dependencies on DDR_R_WK_TRANS

Line 233: /* Populate DDR_R_WK_TRANS table */

229: and NYR.CLNDR_CD(+) = BDAY.CLNDR_CD
230: and NYR.DAY_CD(+) = add_day(BDAY.DAY_CD,364)
231: ;
232:
233: /* Populate DDR_R_WK_TRANS table */
234: delete from DDR_R_WK_TRANS
235: where (WK_CD,CLNDR_CD) in (
236: select WK_CD,CLNDR_CD
237: from DDR_TIME_BSNS_WK_V

Line 234: delete from DDR_R_WK_TRANS

230: and NYR.DAY_CD(+) = add_day(BDAY.DAY_CD,364)
231: ;
232:
233: /* Populate DDR_R_WK_TRANS table */
234: delete from DDR_R_WK_TRANS
235: where (WK_CD,CLNDR_CD) in (
236: select WK_CD,CLNDR_CD
237: from DDR_TIME_BSNS_WK_V
238: where ORG_CD = p_org_cd

Line 242: insert into DDR_R_WK_TRANS (

238: where ORG_CD = p_org_cd
239: and YR_CD between to_char(p_start_year) and to_char(p_end_year)
240: );
241:
242: insert into DDR_R_WK_TRANS (
243: MFG_ORG_CD,
244: WK_TRANS_ID,
245: WK_ID,
246: WK_CD,

Line 281: DDR_R_WK_TRANS_SEQ.NEXTVAL,

277: LAST_UPDATE_LOGIN
278: )
279: select
280: WK.MFG_ORG_CD,
281: DDR_R_WK_TRANS_SEQ.NEXTVAL,
282: WK.WK_ID,
283: WK.WK_CD,
284: WK.CLNDR_CD,
285: 'BSNS',