eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.DDR_TIME_TRANSFORM_PKG dependencies on DDR_TIME_BSNS_WK_V

Line 237: from DDR_TIME_BSNS_WK_V

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
239: and YR_CD between to_char(p_start_year) and to_char(p_end_year)
240: );
241:

Line 316: DDR_TIME_BSNS_WK_V WK,

312: g_last_updated_by,
313: g_last_update_date,
314: g_last_update_login
315: from
316: DDR_TIME_BSNS_WK_V WK,
317: DDR_TIME_BSNS_WK_V PWK,
318: DDR_TIME_BSNS_WK_V PMNTH,
319: DDR_TIME_BSNS_WK_V PQTR,
320: DDR_TIME_BSNS_WK_V PYR,

Line 317: DDR_TIME_BSNS_WK_V PWK,

313: g_last_update_date,
314: g_last_update_login
315: from
316: DDR_TIME_BSNS_WK_V WK,
317: DDR_TIME_BSNS_WK_V PWK,
318: DDR_TIME_BSNS_WK_V PMNTH,
319: DDR_TIME_BSNS_WK_V PQTR,
320: DDR_TIME_BSNS_WK_V PYR,
321: DDR_TIME_BSNS_WK_V NWK,

Line 318: DDR_TIME_BSNS_WK_V PMNTH,

314: g_last_update_login
315: from
316: DDR_TIME_BSNS_WK_V WK,
317: DDR_TIME_BSNS_WK_V PWK,
318: DDR_TIME_BSNS_WK_V PMNTH,
319: DDR_TIME_BSNS_WK_V PQTR,
320: DDR_TIME_BSNS_WK_V PYR,
321: DDR_TIME_BSNS_WK_V NWK,
322: DDR_TIME_BSNS_WK_V NMNTH,

Line 319: DDR_TIME_BSNS_WK_V PQTR,

315: from
316: DDR_TIME_BSNS_WK_V WK,
317: DDR_TIME_BSNS_WK_V PWK,
318: DDR_TIME_BSNS_WK_V PMNTH,
319: DDR_TIME_BSNS_WK_V PQTR,
320: DDR_TIME_BSNS_WK_V PYR,
321: DDR_TIME_BSNS_WK_V NWK,
322: DDR_TIME_BSNS_WK_V NMNTH,
323: DDR_TIME_BSNS_WK_V NQTR,

Line 320: DDR_TIME_BSNS_WK_V PYR,

316: DDR_TIME_BSNS_WK_V WK,
317: DDR_TIME_BSNS_WK_V PWK,
318: DDR_TIME_BSNS_WK_V PMNTH,
319: DDR_TIME_BSNS_WK_V PQTR,
320: DDR_TIME_BSNS_WK_V PYR,
321: DDR_TIME_BSNS_WK_V NWK,
322: DDR_TIME_BSNS_WK_V NMNTH,
323: DDR_TIME_BSNS_WK_V NQTR,
324: DDR_TIME_BSNS_WK_V NYR

Line 321: DDR_TIME_BSNS_WK_V NWK,

317: DDR_TIME_BSNS_WK_V PWK,
318: DDR_TIME_BSNS_WK_V PMNTH,
319: DDR_TIME_BSNS_WK_V PQTR,
320: DDR_TIME_BSNS_WK_V PYR,
321: DDR_TIME_BSNS_WK_V NWK,
322: DDR_TIME_BSNS_WK_V NMNTH,
323: DDR_TIME_BSNS_WK_V NQTR,
324: DDR_TIME_BSNS_WK_V NYR
325: where WK.ORG_CD = p_org_cd

Line 322: DDR_TIME_BSNS_WK_V NMNTH,

318: DDR_TIME_BSNS_WK_V PMNTH,
319: DDR_TIME_BSNS_WK_V PQTR,
320: DDR_TIME_BSNS_WK_V PYR,
321: DDR_TIME_BSNS_WK_V NWK,
322: DDR_TIME_BSNS_WK_V NMNTH,
323: DDR_TIME_BSNS_WK_V NQTR,
324: DDR_TIME_BSNS_WK_V NYR
325: where WK.ORG_CD = p_org_cd
326: and WK.YR_CD between to_char(p_start_year) and to_char(p_end_year)

Line 323: DDR_TIME_BSNS_WK_V NQTR,

319: DDR_TIME_BSNS_WK_V PQTR,
320: DDR_TIME_BSNS_WK_V PYR,
321: DDR_TIME_BSNS_WK_V NWK,
322: DDR_TIME_BSNS_WK_V NMNTH,
323: DDR_TIME_BSNS_WK_V NQTR,
324: DDR_TIME_BSNS_WK_V NYR
325: where WK.ORG_CD = p_org_cd
326: and WK.YR_CD between to_char(p_start_year) and to_char(p_end_year)
327: and PWK.ORG_CD(+) = WK.ORG_CD

Line 324: DDR_TIME_BSNS_WK_V NYR

320: DDR_TIME_BSNS_WK_V PYR,
321: DDR_TIME_BSNS_WK_V NWK,
322: DDR_TIME_BSNS_WK_V NMNTH,
323: DDR_TIME_BSNS_WK_V NQTR,
324: DDR_TIME_BSNS_WK_V NYR
325: where WK.ORG_CD = p_org_cd
326: and WK.YR_CD between to_char(p_start_year) and to_char(p_end_year)
327: and PWK.ORG_CD(+) = WK.ORG_CD
328: and PWK.CLNDR_CD(+) = WK.CLNDR_CD

Line 656: from DDR_TIME_BSNS_WK_V

652: /* Populate DDR_R_WK_TODATE_TRANS table */
653: delete from DDR_R_WK_TODATE_TRANS
654: where (WK_CD,CLNDR_CD) in (
655: select WK_CD,CLNDR_CD
656: from DDR_TIME_BSNS_WK_V
657: where ORG_CD = p_org_cd
658: and YR_CD between to_char(p_start_year) and to_char(p_end_year)
659: );
660:

Line 706: FROM DDR_TIME_BSNS_WK_V A,

702: A.WK_ID WK_ID,
703: A.CLNDR_CD CLNDR_CD,
704: B.WK_CD YR_WK_CD,
705: B.WK_ID YR_WK_ID
706: FROM DDR_TIME_BSNS_WK_V A,
707: DDR_TIME_BSNS_WK_V B
708: WHERE A.YR_CD = B.YR_CD
709: AND A.WK_CD >= B.WK_CD
710: AND A.ORG_CD = B.ORG_CD

Line 707: DDR_TIME_BSNS_WK_V B

703: A.CLNDR_CD CLNDR_CD,
704: B.WK_CD YR_WK_CD,
705: B.WK_ID YR_WK_ID
706: FROM DDR_TIME_BSNS_WK_V A,
707: DDR_TIME_BSNS_WK_V B
708: WHERE A.YR_CD = B.YR_CD
709: AND A.WK_CD >= B.WK_CD
710: AND A.ORG_CD = B.ORG_CD
711: AND A.ORG_CD = p_org_cd