APPS.DDR_TIME_TRANSFORM_PKG dependencies on DDR_TIME_CLNDR_MNTH_V

Line 1536: FROM DDR_TIME_CLNDR_MNTH_V

1532: FROM DDR_R_MNTH_TRANS
1533: WHERE (MNTH_CD,CLNDR_CD) IN
1534: (SELECT MNTH_CD,
1535: CLNDR_CD
1536: FROM DDR_TIME_CLNDR_MNTH_V
1537: WHERE YR_CD BETWEEN TO_CHAR(p_start_year) AND TO_CHAR(p_end_year)
1538: );
1539: INSERT
1540: INTO DDR_R_MNTH_TRANS

Line 1597: FROM DDR_TIME_CLNDR_MNTH_V MNTH,

1593: g_creation_date,
1594: g_last_updated_by,
1595: g_last_update_date,
1596: g_last_update_login
1597: FROM DDR_TIME_CLNDR_MNTH_V MNTH,
1598: DDR_TIME_CLNDR_MNTH_V PMNTH,
1599: DDR_TIME_CLNDR_MNTH_V PQTR,
1600: DDR_TIME_CLNDR_MNTH_V PYR,
1601: DDR_TIME_CLNDR_MNTH_V NMNTH,

Line 1598: DDR_TIME_CLNDR_MNTH_V PMNTH,

1594: g_last_updated_by,
1595: g_last_update_date,
1596: g_last_update_login
1597: FROM DDR_TIME_CLNDR_MNTH_V MNTH,
1598: DDR_TIME_CLNDR_MNTH_V PMNTH,
1599: DDR_TIME_CLNDR_MNTH_V PQTR,
1600: DDR_TIME_CLNDR_MNTH_V PYR,
1601: DDR_TIME_CLNDR_MNTH_V NMNTH,
1602: DDR_TIME_CLNDR_MNTH_V NQTR,

Line 1599: DDR_TIME_CLNDR_MNTH_V PQTR,

1595: g_last_update_date,
1596: g_last_update_login
1597: FROM DDR_TIME_CLNDR_MNTH_V MNTH,
1598: DDR_TIME_CLNDR_MNTH_V PMNTH,
1599: DDR_TIME_CLNDR_MNTH_V PQTR,
1600: DDR_TIME_CLNDR_MNTH_V PYR,
1601: DDR_TIME_CLNDR_MNTH_V NMNTH,
1602: DDR_TIME_CLNDR_MNTH_V NQTR,
1603: DDR_TIME_CLNDR_MNTH_V NYR

Line 1600: DDR_TIME_CLNDR_MNTH_V PYR,

1596: g_last_update_login
1597: FROM DDR_TIME_CLNDR_MNTH_V MNTH,
1598: DDR_TIME_CLNDR_MNTH_V PMNTH,
1599: DDR_TIME_CLNDR_MNTH_V PQTR,
1600: DDR_TIME_CLNDR_MNTH_V PYR,
1601: DDR_TIME_CLNDR_MNTH_V NMNTH,
1602: DDR_TIME_CLNDR_MNTH_V NQTR,
1603: DDR_TIME_CLNDR_MNTH_V NYR
1604: WHERE MNTH.YR_CD BETWEEN TO_CHAR(p_start_year) AND TO_CHAR(p_end_year)

Line 1601: DDR_TIME_CLNDR_MNTH_V NMNTH,

1597: FROM DDR_TIME_CLNDR_MNTH_V MNTH,
1598: DDR_TIME_CLNDR_MNTH_V PMNTH,
1599: DDR_TIME_CLNDR_MNTH_V PQTR,
1600: DDR_TIME_CLNDR_MNTH_V PYR,
1601: DDR_TIME_CLNDR_MNTH_V NMNTH,
1602: DDR_TIME_CLNDR_MNTH_V NQTR,
1603: DDR_TIME_CLNDR_MNTH_V NYR
1604: WHERE MNTH.YR_CD BETWEEN TO_CHAR(p_start_year) AND TO_CHAR(p_end_year)
1605: AND PMNTH.CLNDR_CD(+) = MNTH.CLNDR_CD

Line 1602: DDR_TIME_CLNDR_MNTH_V NQTR,

1598: DDR_TIME_CLNDR_MNTH_V PMNTH,
1599: DDR_TIME_CLNDR_MNTH_V PQTR,
1600: DDR_TIME_CLNDR_MNTH_V PYR,
1601: DDR_TIME_CLNDR_MNTH_V NMNTH,
1602: DDR_TIME_CLNDR_MNTH_V NQTR,
1603: DDR_TIME_CLNDR_MNTH_V NYR
1604: WHERE MNTH.YR_CD BETWEEN TO_CHAR(p_start_year) AND TO_CHAR(p_end_year)
1605: AND PMNTH.CLNDR_CD(+) = MNTH.CLNDR_CD
1606: AND PMNTH.MNTH_CD(+) = add_month(MNTH.MNTH_CD,-1)

Line 1603: DDR_TIME_CLNDR_MNTH_V NYR

1599: DDR_TIME_CLNDR_MNTH_V PQTR,
1600: DDR_TIME_CLNDR_MNTH_V PYR,
1601: DDR_TIME_CLNDR_MNTH_V NMNTH,
1602: DDR_TIME_CLNDR_MNTH_V NQTR,
1603: DDR_TIME_CLNDR_MNTH_V NYR
1604: WHERE MNTH.YR_CD BETWEEN TO_CHAR(p_start_year) AND TO_CHAR(p_end_year)
1605: AND PMNTH.CLNDR_CD(+) = MNTH.CLNDR_CD
1606: AND PMNTH.MNTH_CD(+) = add_month(MNTH.MNTH_CD,-1)
1607: AND PQTR.CLNDR_CD(+) = MNTH.CLNDR_CD

Line 1880: FROM DDR_TIME_CLNDR_MNTH_V

1876: FROM DDR_R_MNTH_TODATE_TRANS
1877: WHERE (MNTH_CD,CLNDR_CD) IN
1878: (SELECT MNTH_CD,
1879: CLNDR_CD
1880: FROM DDR_TIME_CLNDR_MNTH_V
1881: WHERE YR_CD BETWEEN TO_CHAR(P_START_YEAR) AND TO_CHAR(P_END_YEAR)
1882: );
1883: INSERT
1884: INTO DDR_R_MNTH_TODATE_TRANS

Line 1929: FROM DDR_TIME_CLNDR_MNTH_V A,

1925: A.CLNDR_CD CLNDR_CD,
1926: A.CLNDR_TYP CLNDR_TYP,
1927: B.MNTH_CD YR_MNTH_CD,
1928: B.CLNDR_MNTH_ID YR_MNTH_ID
1929: FROM DDR_TIME_CLNDR_MNTH_V A,
1930: DDR_TIME_CLNDR_MNTH_V B
1931: WHERE A.YR_CD = B.YR_CD
1932: AND A.MNTH_CD >= B.MNTH_CD
1933: AND A.ORG_CD = B.ORG_CD

Line 1930: DDR_TIME_CLNDR_MNTH_V B

1926: A.CLNDR_TYP CLNDR_TYP,
1927: B.MNTH_CD YR_MNTH_CD,
1928: B.CLNDR_MNTH_ID YR_MNTH_ID
1929: FROM DDR_TIME_CLNDR_MNTH_V A,
1930: DDR_TIME_CLNDR_MNTH_V B
1931: WHERE A.YR_CD = B.YR_CD
1932: AND A.MNTH_CD >= B.MNTH_CD
1933: AND A.ORG_CD = B.ORG_CD
1934: AND A.YR_CD BETWEEN TO_CHAR(p_start_year) AND TO_CHAR(p_end_year)