DBA Data[Home] [Help]

APPS.DDR_TIME_TRANSFORM_PKG dependencies on DDR_TIME_BSNS_YR_V

Line 533: from DDR_TIME_BSNS_YR_V

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
535: and YR_CD between to_char(p_start_year) and to_char(p_end_year)
536: );
537:

Line 580: DDR_TIME_BSNS_YR_V YR,

576: g_last_updated_by,
577: g_last_update_date,
578: g_last_update_login
579: from
580: DDR_TIME_BSNS_YR_V YR,
581: DDR_TIME_BSNS_YR_V PYR,
582: DDR_TIME_BSNS_YR_V NYR
583: where YR.ORG_CD = p_org_cd
584: and YR.YR_CD between to_char(p_start_year) and to_char(p_end_year)

Line 581: DDR_TIME_BSNS_YR_V PYR,

577: g_last_update_date,
578: g_last_update_login
579: from
580: DDR_TIME_BSNS_YR_V YR,
581: DDR_TIME_BSNS_YR_V PYR,
582: DDR_TIME_BSNS_YR_V NYR
583: where YR.ORG_CD = p_org_cd
584: and YR.YR_CD between to_char(p_start_year) and to_char(p_end_year)
585: and PYR.ORG_CD(+) = YR.ORG_CD

Line 582: DDR_TIME_BSNS_YR_V NYR

578: g_last_update_login
579: from
580: DDR_TIME_BSNS_YR_V YR,
581: DDR_TIME_BSNS_YR_V PYR,
582: DDR_TIME_BSNS_YR_V NYR
583: where YR.ORG_CD = p_org_cd
584: and YR.YR_CD between to_char(p_start_year) and to_char(p_end_year)
585: and PYR.ORG_CD(+) = YR.ORG_CD
586: and PYR.CLNDR_CD(+) = YR.CLNDR_CD