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_CLNDR_DAY_V

Line 862: FROM DDR_TIME_CLNDR_DAY_V

858: FROM DDR_R_DAY_TRANS
859: WHERE (DAY_CD,CLNDR_CD) IN
860: (SELECT DAY_CD,
861: CLNDR_CD
862: FROM DDR_TIME_CLNDR_DAY_V
863: WHERE YR_CD BETWEEN TO_CHAR(p_start_year) AND TO_CHAR(p_end_year)
864: );
865: WHILE (V_START_YEAR <=P_END_YEAR)
866: LOOP

Line 930: FROM DDR_TIME_CLNDR_DAY_V BDAY,

926: g_creation_date,
927: g_last_updated_by,
928: g_last_update_date,
929: g_last_update_login
930: FROM DDR_TIME_CLNDR_DAY_V BDAY,
931: DDR_TIME_CLNDR_DAY_V PDAY,
932: DDR_TIME_CLNDR_DAY_V PWK,
933: DDR_TIME_CLNDR_DAY_V PMNTH,
934: DDR_TIME_CLNDR_DAY_V PQTR,

Line 931: DDR_TIME_CLNDR_DAY_V PDAY,

927: g_last_updated_by,
928: g_last_update_date,
929: g_last_update_login
930: FROM DDR_TIME_CLNDR_DAY_V BDAY,
931: DDR_TIME_CLNDR_DAY_V PDAY,
932: DDR_TIME_CLNDR_DAY_V PWK,
933: DDR_TIME_CLNDR_DAY_V PMNTH,
934: DDR_TIME_CLNDR_DAY_V PQTR,
935: DDR_TIME_CLNDR_DAY_V PYR,

Line 932: DDR_TIME_CLNDR_DAY_V PWK,

928: g_last_update_date,
929: g_last_update_login
930: FROM DDR_TIME_CLNDR_DAY_V BDAY,
931: DDR_TIME_CLNDR_DAY_V PDAY,
932: DDR_TIME_CLNDR_DAY_V PWK,
933: DDR_TIME_CLNDR_DAY_V PMNTH,
934: DDR_TIME_CLNDR_DAY_V PQTR,
935: DDR_TIME_CLNDR_DAY_V PYR,
936: DDR_TIME_CLNDR_DAY_V NDAY,

Line 933: DDR_TIME_CLNDR_DAY_V PMNTH,

929: g_last_update_login
930: FROM DDR_TIME_CLNDR_DAY_V BDAY,
931: DDR_TIME_CLNDR_DAY_V PDAY,
932: DDR_TIME_CLNDR_DAY_V PWK,
933: DDR_TIME_CLNDR_DAY_V PMNTH,
934: DDR_TIME_CLNDR_DAY_V PQTR,
935: DDR_TIME_CLNDR_DAY_V PYR,
936: DDR_TIME_CLNDR_DAY_V NDAY,
937: DDR_TIME_CLNDR_DAY_V NWK,

Line 934: DDR_TIME_CLNDR_DAY_V PQTR,

930: FROM DDR_TIME_CLNDR_DAY_V BDAY,
931: DDR_TIME_CLNDR_DAY_V PDAY,
932: DDR_TIME_CLNDR_DAY_V PWK,
933: DDR_TIME_CLNDR_DAY_V PMNTH,
934: DDR_TIME_CLNDR_DAY_V PQTR,
935: DDR_TIME_CLNDR_DAY_V PYR,
936: DDR_TIME_CLNDR_DAY_V NDAY,
937: DDR_TIME_CLNDR_DAY_V NWK,
938: DDR_TIME_CLNDR_DAY_V NMNTH,

Line 935: DDR_TIME_CLNDR_DAY_V PYR,

931: DDR_TIME_CLNDR_DAY_V PDAY,
932: DDR_TIME_CLNDR_DAY_V PWK,
933: DDR_TIME_CLNDR_DAY_V PMNTH,
934: DDR_TIME_CLNDR_DAY_V PQTR,
935: DDR_TIME_CLNDR_DAY_V PYR,
936: DDR_TIME_CLNDR_DAY_V NDAY,
937: DDR_TIME_CLNDR_DAY_V NWK,
938: DDR_TIME_CLNDR_DAY_V NMNTH,
939: DDR_TIME_CLNDR_DAY_V NQTR,

Line 936: DDR_TIME_CLNDR_DAY_V NDAY,

932: DDR_TIME_CLNDR_DAY_V PWK,
933: DDR_TIME_CLNDR_DAY_V PMNTH,
934: DDR_TIME_CLNDR_DAY_V PQTR,
935: DDR_TIME_CLNDR_DAY_V PYR,
936: DDR_TIME_CLNDR_DAY_V NDAY,
937: DDR_TIME_CLNDR_DAY_V NWK,
938: DDR_TIME_CLNDR_DAY_V NMNTH,
939: DDR_TIME_CLNDR_DAY_V NQTR,
940: DDR_TIME_CLNDR_DAY_V NYR

Line 937: DDR_TIME_CLNDR_DAY_V NWK,

933: DDR_TIME_CLNDR_DAY_V PMNTH,
934: DDR_TIME_CLNDR_DAY_V PQTR,
935: DDR_TIME_CLNDR_DAY_V PYR,
936: DDR_TIME_CLNDR_DAY_V NDAY,
937: DDR_TIME_CLNDR_DAY_V NWK,
938: DDR_TIME_CLNDR_DAY_V NMNTH,
939: DDR_TIME_CLNDR_DAY_V NQTR,
940: DDR_TIME_CLNDR_DAY_V NYR
941: where BDAY.YR_CD = TO_CHAR(v_start_year)

Line 938: DDR_TIME_CLNDR_DAY_V NMNTH,

934: DDR_TIME_CLNDR_DAY_V PQTR,
935: DDR_TIME_CLNDR_DAY_V PYR,
936: DDR_TIME_CLNDR_DAY_V NDAY,
937: DDR_TIME_CLNDR_DAY_V NWK,
938: DDR_TIME_CLNDR_DAY_V NMNTH,
939: DDR_TIME_CLNDR_DAY_V NQTR,
940: DDR_TIME_CLNDR_DAY_V NYR
941: where BDAY.YR_CD = TO_CHAR(v_start_year)
942: AND PDAY.CLNDR_CD(+) = BDAY.CLNDR_CD

Line 939: DDR_TIME_CLNDR_DAY_V NQTR,

935: DDR_TIME_CLNDR_DAY_V PYR,
936: DDR_TIME_CLNDR_DAY_V NDAY,
937: DDR_TIME_CLNDR_DAY_V NWK,
938: DDR_TIME_CLNDR_DAY_V NMNTH,
939: DDR_TIME_CLNDR_DAY_V NQTR,
940: DDR_TIME_CLNDR_DAY_V NYR
941: where BDAY.YR_CD = TO_CHAR(v_start_year)
942: AND PDAY.CLNDR_CD(+) = BDAY.CLNDR_CD
943: AND PDAY.DAY_CD(+) = add_day(BDAY.DAY_CD,-1)

Line 940: DDR_TIME_CLNDR_DAY_V NYR

936: DDR_TIME_CLNDR_DAY_V NDAY,
937: DDR_TIME_CLNDR_DAY_V NWK,
938: DDR_TIME_CLNDR_DAY_V NMNTH,
939: DDR_TIME_CLNDR_DAY_V NQTR,
940: DDR_TIME_CLNDR_DAY_V NYR
941: where BDAY.YR_CD = TO_CHAR(v_start_year)
942: AND PDAY.CLNDR_CD(+) = BDAY.CLNDR_CD
943: AND PDAY.DAY_CD(+) = add_day(BDAY.DAY_CD,-1)
944: AND PWK.CLNDR_CD(+) = BDAY.CLNDR_CD

Line 1020: FROM DDR_TIME_CLNDR_DAY_V BDAY,

1016: g_creation_date,
1017: g_last_updated_by,
1018: g_last_update_date,
1019: g_last_update_login
1020: FROM DDR_TIME_CLNDR_DAY_V BDAY,
1021: DDR_TIME_CLNDR_DAY_V PDAY,
1022: DDR_TIME_CLNDR_DAY_V PWK,
1023: DDR_TIME_CLNDR_DAY_V PMNTH,
1024: DDR_TIME_CLNDR_DAY_V PQTR,

Line 1021: DDR_TIME_CLNDR_DAY_V PDAY,

1017: g_last_updated_by,
1018: g_last_update_date,
1019: g_last_update_login
1020: FROM DDR_TIME_CLNDR_DAY_V BDAY,
1021: DDR_TIME_CLNDR_DAY_V PDAY,
1022: DDR_TIME_CLNDR_DAY_V PWK,
1023: DDR_TIME_CLNDR_DAY_V PMNTH,
1024: DDR_TIME_CLNDR_DAY_V PQTR,
1025: DDR_TIME_CLNDR_DAY_V PYR,

Line 1022: DDR_TIME_CLNDR_DAY_V PWK,

1018: g_last_update_date,
1019: g_last_update_login
1020: FROM DDR_TIME_CLNDR_DAY_V BDAY,
1021: DDR_TIME_CLNDR_DAY_V PDAY,
1022: DDR_TIME_CLNDR_DAY_V PWK,
1023: DDR_TIME_CLNDR_DAY_V PMNTH,
1024: DDR_TIME_CLNDR_DAY_V PQTR,
1025: DDR_TIME_CLNDR_DAY_V PYR,
1026: DDR_TIME_CLNDR_DAY_V NDAY,

Line 1023: DDR_TIME_CLNDR_DAY_V PMNTH,

1019: g_last_update_login
1020: FROM DDR_TIME_CLNDR_DAY_V BDAY,
1021: DDR_TIME_CLNDR_DAY_V PDAY,
1022: DDR_TIME_CLNDR_DAY_V PWK,
1023: DDR_TIME_CLNDR_DAY_V PMNTH,
1024: DDR_TIME_CLNDR_DAY_V PQTR,
1025: DDR_TIME_CLNDR_DAY_V PYR,
1026: DDR_TIME_CLNDR_DAY_V NDAY,
1027: DDR_TIME_CLNDR_DAY_V NWK,

Line 1024: DDR_TIME_CLNDR_DAY_V PQTR,

1020: FROM DDR_TIME_CLNDR_DAY_V BDAY,
1021: DDR_TIME_CLNDR_DAY_V PDAY,
1022: DDR_TIME_CLNDR_DAY_V PWK,
1023: DDR_TIME_CLNDR_DAY_V PMNTH,
1024: DDR_TIME_CLNDR_DAY_V PQTR,
1025: DDR_TIME_CLNDR_DAY_V PYR,
1026: DDR_TIME_CLNDR_DAY_V NDAY,
1027: DDR_TIME_CLNDR_DAY_V NWK,
1028: DDR_TIME_CLNDR_DAY_V NMNTH,

Line 1025: DDR_TIME_CLNDR_DAY_V PYR,

1021: DDR_TIME_CLNDR_DAY_V PDAY,
1022: DDR_TIME_CLNDR_DAY_V PWK,
1023: DDR_TIME_CLNDR_DAY_V PMNTH,
1024: DDR_TIME_CLNDR_DAY_V PQTR,
1025: DDR_TIME_CLNDR_DAY_V PYR,
1026: DDR_TIME_CLNDR_DAY_V NDAY,
1027: DDR_TIME_CLNDR_DAY_V NWK,
1028: DDR_TIME_CLNDR_DAY_V NMNTH,
1029: DDR_TIME_CLNDR_DAY_V NQTR,

Line 1026: DDR_TIME_CLNDR_DAY_V NDAY,

1022: DDR_TIME_CLNDR_DAY_V PWK,
1023: DDR_TIME_CLNDR_DAY_V PMNTH,
1024: DDR_TIME_CLNDR_DAY_V PQTR,
1025: DDR_TIME_CLNDR_DAY_V PYR,
1026: DDR_TIME_CLNDR_DAY_V NDAY,
1027: DDR_TIME_CLNDR_DAY_V NWK,
1028: DDR_TIME_CLNDR_DAY_V NMNTH,
1029: DDR_TIME_CLNDR_DAY_V NQTR,
1030: DDR_TIME_CLNDR_DAY_V NYR

Line 1027: DDR_TIME_CLNDR_DAY_V NWK,

1023: DDR_TIME_CLNDR_DAY_V PMNTH,
1024: DDR_TIME_CLNDR_DAY_V PQTR,
1025: DDR_TIME_CLNDR_DAY_V PYR,
1026: DDR_TIME_CLNDR_DAY_V NDAY,
1027: DDR_TIME_CLNDR_DAY_V NWK,
1028: DDR_TIME_CLNDR_DAY_V NMNTH,
1029: DDR_TIME_CLNDR_DAY_V NQTR,
1030: DDR_TIME_CLNDR_DAY_V NYR
1031: where BDAY.YR_CD = TO_CHAR(v_start_year)

Line 1028: DDR_TIME_CLNDR_DAY_V NMNTH,

1024: DDR_TIME_CLNDR_DAY_V PQTR,
1025: DDR_TIME_CLNDR_DAY_V PYR,
1026: DDR_TIME_CLNDR_DAY_V NDAY,
1027: DDR_TIME_CLNDR_DAY_V NWK,
1028: DDR_TIME_CLNDR_DAY_V NMNTH,
1029: DDR_TIME_CLNDR_DAY_V NQTR,
1030: DDR_TIME_CLNDR_DAY_V NYR
1031: where BDAY.YR_CD = TO_CHAR(v_start_year)
1032: AND PDAY.CLNDR_CD(+) = BDAY.CLNDR_CD

Line 1029: DDR_TIME_CLNDR_DAY_V NQTR,

1025: DDR_TIME_CLNDR_DAY_V PYR,
1026: DDR_TIME_CLNDR_DAY_V NDAY,
1027: DDR_TIME_CLNDR_DAY_V NWK,
1028: DDR_TIME_CLNDR_DAY_V NMNTH,
1029: DDR_TIME_CLNDR_DAY_V NQTR,
1030: DDR_TIME_CLNDR_DAY_V NYR
1031: where BDAY.YR_CD = TO_CHAR(v_start_year)
1032: AND PDAY.CLNDR_CD(+) = BDAY.CLNDR_CD
1033: AND PDAY.DAY_CD(+) = add_day(BDAY.DAY_CD,-1)

Line 1030: DDR_TIME_CLNDR_DAY_V NYR

1026: DDR_TIME_CLNDR_DAY_V NDAY,
1027: DDR_TIME_CLNDR_DAY_V NWK,
1028: DDR_TIME_CLNDR_DAY_V NMNTH,
1029: DDR_TIME_CLNDR_DAY_V NQTR,
1030: DDR_TIME_CLNDR_DAY_V NYR
1031: where BDAY.YR_CD = TO_CHAR(v_start_year)
1032: AND PDAY.CLNDR_CD(+) = BDAY.CLNDR_CD
1033: AND PDAY.DAY_CD(+) = add_day(BDAY.DAY_CD,-1)
1034: AND PWK.CLNDR_CD(+) = BDAY.CLNDR_CD

Line 1110: FROM DDR_TIME_CLNDR_DAY_V BDAY,

1106: g_creation_date,
1107: g_last_updated_by,
1108: g_last_update_date,
1109: g_last_update_login
1110: FROM DDR_TIME_CLNDR_DAY_V BDAY,
1111: DDR_TIME_CLNDR_DAY_V PDAY,
1112: DDR_TIME_CLNDR_DAY_V PWK,
1113: DDR_TIME_CLNDR_DAY_V PMNTH,
1114: DDR_TIME_CLNDR_DAY_V PQTR,

Line 1111: DDR_TIME_CLNDR_DAY_V PDAY,

1107: g_last_updated_by,
1108: g_last_update_date,
1109: g_last_update_login
1110: FROM DDR_TIME_CLNDR_DAY_V BDAY,
1111: DDR_TIME_CLNDR_DAY_V PDAY,
1112: DDR_TIME_CLNDR_DAY_V PWK,
1113: DDR_TIME_CLNDR_DAY_V PMNTH,
1114: DDR_TIME_CLNDR_DAY_V PQTR,
1115: DDR_TIME_CLNDR_DAY_V PYR,

Line 1112: DDR_TIME_CLNDR_DAY_V PWK,

1108: g_last_update_date,
1109: g_last_update_login
1110: FROM DDR_TIME_CLNDR_DAY_V BDAY,
1111: DDR_TIME_CLNDR_DAY_V PDAY,
1112: DDR_TIME_CLNDR_DAY_V PWK,
1113: DDR_TIME_CLNDR_DAY_V PMNTH,
1114: DDR_TIME_CLNDR_DAY_V PQTR,
1115: DDR_TIME_CLNDR_DAY_V PYR,
1116: DDR_TIME_CLNDR_DAY_V NDAY,

Line 1113: DDR_TIME_CLNDR_DAY_V PMNTH,

1109: g_last_update_login
1110: FROM DDR_TIME_CLNDR_DAY_V BDAY,
1111: DDR_TIME_CLNDR_DAY_V PDAY,
1112: DDR_TIME_CLNDR_DAY_V PWK,
1113: DDR_TIME_CLNDR_DAY_V PMNTH,
1114: DDR_TIME_CLNDR_DAY_V PQTR,
1115: DDR_TIME_CLNDR_DAY_V PYR,
1116: DDR_TIME_CLNDR_DAY_V NDAY,
1117: DDR_TIME_CLNDR_DAY_V NWK,

Line 1114: DDR_TIME_CLNDR_DAY_V PQTR,

1110: FROM DDR_TIME_CLNDR_DAY_V BDAY,
1111: DDR_TIME_CLNDR_DAY_V PDAY,
1112: DDR_TIME_CLNDR_DAY_V PWK,
1113: DDR_TIME_CLNDR_DAY_V PMNTH,
1114: DDR_TIME_CLNDR_DAY_V PQTR,
1115: DDR_TIME_CLNDR_DAY_V PYR,
1116: DDR_TIME_CLNDR_DAY_V NDAY,
1117: DDR_TIME_CLNDR_DAY_V NWK,
1118: DDR_TIME_CLNDR_DAY_V NMNTH,

Line 1115: DDR_TIME_CLNDR_DAY_V PYR,

1111: DDR_TIME_CLNDR_DAY_V PDAY,
1112: DDR_TIME_CLNDR_DAY_V PWK,
1113: DDR_TIME_CLNDR_DAY_V PMNTH,
1114: DDR_TIME_CLNDR_DAY_V PQTR,
1115: DDR_TIME_CLNDR_DAY_V PYR,
1116: DDR_TIME_CLNDR_DAY_V NDAY,
1117: DDR_TIME_CLNDR_DAY_V NWK,
1118: DDR_TIME_CLNDR_DAY_V NMNTH,
1119: DDR_TIME_CLNDR_DAY_V NQTR,

Line 1116: DDR_TIME_CLNDR_DAY_V NDAY,

1112: DDR_TIME_CLNDR_DAY_V PWK,
1113: DDR_TIME_CLNDR_DAY_V PMNTH,
1114: DDR_TIME_CLNDR_DAY_V PQTR,
1115: DDR_TIME_CLNDR_DAY_V PYR,
1116: DDR_TIME_CLNDR_DAY_V NDAY,
1117: DDR_TIME_CLNDR_DAY_V NWK,
1118: DDR_TIME_CLNDR_DAY_V NMNTH,
1119: DDR_TIME_CLNDR_DAY_V NQTR,
1120: DDR_TIME_CLNDR_DAY_V NYR

Line 1117: DDR_TIME_CLNDR_DAY_V NWK,

1113: DDR_TIME_CLNDR_DAY_V PMNTH,
1114: DDR_TIME_CLNDR_DAY_V PQTR,
1115: DDR_TIME_CLNDR_DAY_V PYR,
1116: DDR_TIME_CLNDR_DAY_V NDAY,
1117: DDR_TIME_CLNDR_DAY_V NWK,
1118: DDR_TIME_CLNDR_DAY_V NMNTH,
1119: DDR_TIME_CLNDR_DAY_V NQTR,
1120: DDR_TIME_CLNDR_DAY_V NYR
1121: where BDAY.YR_CD = TO_CHAR(v_start_year)

Line 1118: DDR_TIME_CLNDR_DAY_V NMNTH,

1114: DDR_TIME_CLNDR_DAY_V PQTR,
1115: DDR_TIME_CLNDR_DAY_V PYR,
1116: DDR_TIME_CLNDR_DAY_V NDAY,
1117: DDR_TIME_CLNDR_DAY_V NWK,
1118: DDR_TIME_CLNDR_DAY_V NMNTH,
1119: DDR_TIME_CLNDR_DAY_V NQTR,
1120: DDR_TIME_CLNDR_DAY_V NYR
1121: where BDAY.YR_CD = TO_CHAR(v_start_year)
1122: AND PDAY.CLNDR_CD(+) = BDAY.CLNDR_CD

Line 1119: DDR_TIME_CLNDR_DAY_V NQTR,

1115: DDR_TIME_CLNDR_DAY_V PYR,
1116: DDR_TIME_CLNDR_DAY_V NDAY,
1117: DDR_TIME_CLNDR_DAY_V NWK,
1118: DDR_TIME_CLNDR_DAY_V NMNTH,
1119: DDR_TIME_CLNDR_DAY_V NQTR,
1120: DDR_TIME_CLNDR_DAY_V NYR
1121: where BDAY.YR_CD = TO_CHAR(v_start_year)
1122: AND PDAY.CLNDR_CD(+) = BDAY.CLNDR_CD
1123: AND PDAY.DAY_CD(+) = add_day(BDAY.DAY_CD,-1)

Line 1120: DDR_TIME_CLNDR_DAY_V NYR

1116: DDR_TIME_CLNDR_DAY_V NDAY,
1117: DDR_TIME_CLNDR_DAY_V NWK,
1118: DDR_TIME_CLNDR_DAY_V NMNTH,
1119: DDR_TIME_CLNDR_DAY_V NQTR,
1120: DDR_TIME_CLNDR_DAY_V NYR
1121: where BDAY.YR_CD = TO_CHAR(v_start_year)
1122: AND PDAY.CLNDR_CD(+) = BDAY.CLNDR_CD
1123: AND PDAY.DAY_CD(+) = add_day(BDAY.DAY_CD,-1)
1124: AND PWK.CLNDR_CD(+) = BDAY.CLNDR_CD

Line 1201: FROM DDR_TIME_CLNDR_DAY_V BDAY,

1197: g_creation_date,
1198: g_last_updated_by,
1199: g_last_update_date,
1200: g_last_update_login
1201: FROM DDR_TIME_CLNDR_DAY_V BDAY,
1202: DDR_TIME_CLNDR_DAY_V PDAY,
1203: DDR_TIME_CLNDR_DAY_V PWK,
1204: DDR_TIME_CLNDR_DAY_V PMNTH,
1205: DDR_TIME_CLNDR_DAY_V PQTR,

Line 1202: DDR_TIME_CLNDR_DAY_V PDAY,

1198: g_last_updated_by,
1199: g_last_update_date,
1200: g_last_update_login
1201: FROM DDR_TIME_CLNDR_DAY_V BDAY,
1202: DDR_TIME_CLNDR_DAY_V PDAY,
1203: DDR_TIME_CLNDR_DAY_V PWK,
1204: DDR_TIME_CLNDR_DAY_V PMNTH,
1205: DDR_TIME_CLNDR_DAY_V PQTR,
1206: DDR_TIME_CLNDR_DAY_V PYR,

Line 1203: DDR_TIME_CLNDR_DAY_V PWK,

1199: g_last_update_date,
1200: g_last_update_login
1201: FROM DDR_TIME_CLNDR_DAY_V BDAY,
1202: DDR_TIME_CLNDR_DAY_V PDAY,
1203: DDR_TIME_CLNDR_DAY_V PWK,
1204: DDR_TIME_CLNDR_DAY_V PMNTH,
1205: DDR_TIME_CLNDR_DAY_V PQTR,
1206: DDR_TIME_CLNDR_DAY_V PYR,
1207: DDR_TIME_CLNDR_DAY_V NDAY,

Line 1204: DDR_TIME_CLNDR_DAY_V PMNTH,

1200: g_last_update_login
1201: FROM DDR_TIME_CLNDR_DAY_V BDAY,
1202: DDR_TIME_CLNDR_DAY_V PDAY,
1203: DDR_TIME_CLNDR_DAY_V PWK,
1204: DDR_TIME_CLNDR_DAY_V PMNTH,
1205: DDR_TIME_CLNDR_DAY_V PQTR,
1206: DDR_TIME_CLNDR_DAY_V PYR,
1207: DDR_TIME_CLNDR_DAY_V NDAY,
1208: DDR_TIME_CLNDR_DAY_V NWK,

Line 1205: DDR_TIME_CLNDR_DAY_V PQTR,

1201: FROM DDR_TIME_CLNDR_DAY_V BDAY,
1202: DDR_TIME_CLNDR_DAY_V PDAY,
1203: DDR_TIME_CLNDR_DAY_V PWK,
1204: DDR_TIME_CLNDR_DAY_V PMNTH,
1205: DDR_TIME_CLNDR_DAY_V PQTR,
1206: DDR_TIME_CLNDR_DAY_V PYR,
1207: DDR_TIME_CLNDR_DAY_V NDAY,
1208: DDR_TIME_CLNDR_DAY_V NWK,
1209: DDR_TIME_CLNDR_DAY_V NMNTH,

Line 1206: DDR_TIME_CLNDR_DAY_V PYR,

1202: DDR_TIME_CLNDR_DAY_V PDAY,
1203: DDR_TIME_CLNDR_DAY_V PWK,
1204: DDR_TIME_CLNDR_DAY_V PMNTH,
1205: DDR_TIME_CLNDR_DAY_V PQTR,
1206: DDR_TIME_CLNDR_DAY_V PYR,
1207: DDR_TIME_CLNDR_DAY_V NDAY,
1208: DDR_TIME_CLNDR_DAY_V NWK,
1209: DDR_TIME_CLNDR_DAY_V NMNTH,
1210: DDR_TIME_CLNDR_DAY_V NQTR,

Line 1207: DDR_TIME_CLNDR_DAY_V NDAY,

1203: DDR_TIME_CLNDR_DAY_V PWK,
1204: DDR_TIME_CLNDR_DAY_V PMNTH,
1205: DDR_TIME_CLNDR_DAY_V PQTR,
1206: DDR_TIME_CLNDR_DAY_V PYR,
1207: DDR_TIME_CLNDR_DAY_V NDAY,
1208: DDR_TIME_CLNDR_DAY_V NWK,
1209: DDR_TIME_CLNDR_DAY_V NMNTH,
1210: DDR_TIME_CLNDR_DAY_V NQTR,
1211: DDR_TIME_CLNDR_DAY_V NYR

Line 1208: DDR_TIME_CLNDR_DAY_V NWK,

1204: DDR_TIME_CLNDR_DAY_V PMNTH,
1205: DDR_TIME_CLNDR_DAY_V PQTR,
1206: DDR_TIME_CLNDR_DAY_V PYR,
1207: DDR_TIME_CLNDR_DAY_V NDAY,
1208: DDR_TIME_CLNDR_DAY_V NWK,
1209: DDR_TIME_CLNDR_DAY_V NMNTH,
1210: DDR_TIME_CLNDR_DAY_V NQTR,
1211: DDR_TIME_CLNDR_DAY_V NYR
1212: where BDAY.YR_CD = TO_CHAR(v_start_year)

Line 1209: DDR_TIME_CLNDR_DAY_V NMNTH,

1205: DDR_TIME_CLNDR_DAY_V PQTR,
1206: DDR_TIME_CLNDR_DAY_V PYR,
1207: DDR_TIME_CLNDR_DAY_V NDAY,
1208: DDR_TIME_CLNDR_DAY_V NWK,
1209: DDR_TIME_CLNDR_DAY_V NMNTH,
1210: DDR_TIME_CLNDR_DAY_V NQTR,
1211: DDR_TIME_CLNDR_DAY_V NYR
1212: where BDAY.YR_CD = TO_CHAR(v_start_year)
1213: AND PDAY.CLNDR_CD(+) = BDAY.CLNDR_CD

Line 1210: DDR_TIME_CLNDR_DAY_V NQTR,

1206: DDR_TIME_CLNDR_DAY_V PYR,
1207: DDR_TIME_CLNDR_DAY_V NDAY,
1208: DDR_TIME_CLNDR_DAY_V NWK,
1209: DDR_TIME_CLNDR_DAY_V NMNTH,
1210: DDR_TIME_CLNDR_DAY_V NQTR,
1211: DDR_TIME_CLNDR_DAY_V NYR
1212: where BDAY.YR_CD = TO_CHAR(v_start_year)
1213: AND PDAY.CLNDR_CD(+) = BDAY.CLNDR_CD
1214: AND PDAY.DAY_CD(+) = add_day(BDAY.DAY_CD,-1)

Line 1211: DDR_TIME_CLNDR_DAY_V NYR

1207: DDR_TIME_CLNDR_DAY_V NDAY,
1208: DDR_TIME_CLNDR_DAY_V NWK,
1209: DDR_TIME_CLNDR_DAY_V NMNTH,
1210: DDR_TIME_CLNDR_DAY_V NQTR,
1211: DDR_TIME_CLNDR_DAY_V NYR
1212: where BDAY.YR_CD = TO_CHAR(v_start_year)
1213: AND PDAY.CLNDR_CD(+) = BDAY.CLNDR_CD
1214: AND PDAY.DAY_CD(+) = add_day(BDAY.DAY_CD,-1)
1215: AND PWK.CLNDR_CD(+) = BDAY.CLNDR_CD

Line 1291: FROM DDR_TIME_CLNDR_DAY_V BDAY,

1287: g_creation_date,
1288: g_last_updated_by,
1289: g_last_update_date,
1290: g_last_update_login
1291: FROM DDR_TIME_CLNDR_DAY_V BDAY,
1292: DDR_TIME_CLNDR_DAY_V PDAY,
1293: DDR_TIME_CLNDR_DAY_V PWK,
1294: DDR_TIME_CLNDR_DAY_V PMNTH,
1295: DDR_TIME_CLNDR_DAY_V PQTR,

Line 1292: DDR_TIME_CLNDR_DAY_V PDAY,

1288: g_last_updated_by,
1289: g_last_update_date,
1290: g_last_update_login
1291: FROM DDR_TIME_CLNDR_DAY_V BDAY,
1292: DDR_TIME_CLNDR_DAY_V PDAY,
1293: DDR_TIME_CLNDR_DAY_V PWK,
1294: DDR_TIME_CLNDR_DAY_V PMNTH,
1295: DDR_TIME_CLNDR_DAY_V PQTR,
1296: DDR_TIME_CLNDR_DAY_V PYR,

Line 1293: DDR_TIME_CLNDR_DAY_V PWK,

1289: g_last_update_date,
1290: g_last_update_login
1291: FROM DDR_TIME_CLNDR_DAY_V BDAY,
1292: DDR_TIME_CLNDR_DAY_V PDAY,
1293: DDR_TIME_CLNDR_DAY_V PWK,
1294: DDR_TIME_CLNDR_DAY_V PMNTH,
1295: DDR_TIME_CLNDR_DAY_V PQTR,
1296: DDR_TIME_CLNDR_DAY_V PYR,
1297: DDR_TIME_CLNDR_DAY_V NDAY,

Line 1294: DDR_TIME_CLNDR_DAY_V PMNTH,

1290: g_last_update_login
1291: FROM DDR_TIME_CLNDR_DAY_V BDAY,
1292: DDR_TIME_CLNDR_DAY_V PDAY,
1293: DDR_TIME_CLNDR_DAY_V PWK,
1294: DDR_TIME_CLNDR_DAY_V PMNTH,
1295: DDR_TIME_CLNDR_DAY_V PQTR,
1296: DDR_TIME_CLNDR_DAY_V PYR,
1297: DDR_TIME_CLNDR_DAY_V NDAY,
1298: DDR_TIME_CLNDR_DAY_V NWK,

Line 1295: DDR_TIME_CLNDR_DAY_V PQTR,

1291: FROM DDR_TIME_CLNDR_DAY_V BDAY,
1292: DDR_TIME_CLNDR_DAY_V PDAY,
1293: DDR_TIME_CLNDR_DAY_V PWK,
1294: DDR_TIME_CLNDR_DAY_V PMNTH,
1295: DDR_TIME_CLNDR_DAY_V PQTR,
1296: DDR_TIME_CLNDR_DAY_V PYR,
1297: DDR_TIME_CLNDR_DAY_V NDAY,
1298: DDR_TIME_CLNDR_DAY_V NWK,
1299: DDR_TIME_CLNDR_DAY_V NMNTH,

Line 1296: DDR_TIME_CLNDR_DAY_V PYR,

1292: DDR_TIME_CLNDR_DAY_V PDAY,
1293: DDR_TIME_CLNDR_DAY_V PWK,
1294: DDR_TIME_CLNDR_DAY_V PMNTH,
1295: DDR_TIME_CLNDR_DAY_V PQTR,
1296: DDR_TIME_CLNDR_DAY_V PYR,
1297: DDR_TIME_CLNDR_DAY_V NDAY,
1298: DDR_TIME_CLNDR_DAY_V NWK,
1299: DDR_TIME_CLNDR_DAY_V NMNTH,
1300: DDR_TIME_CLNDR_DAY_V NQTR,

Line 1297: DDR_TIME_CLNDR_DAY_V NDAY,

1293: DDR_TIME_CLNDR_DAY_V PWK,
1294: DDR_TIME_CLNDR_DAY_V PMNTH,
1295: DDR_TIME_CLNDR_DAY_V PQTR,
1296: DDR_TIME_CLNDR_DAY_V PYR,
1297: DDR_TIME_CLNDR_DAY_V NDAY,
1298: DDR_TIME_CLNDR_DAY_V NWK,
1299: DDR_TIME_CLNDR_DAY_V NMNTH,
1300: DDR_TIME_CLNDR_DAY_V NQTR,
1301: DDR_TIME_CLNDR_DAY_V NYR

Line 1298: DDR_TIME_CLNDR_DAY_V NWK,

1294: DDR_TIME_CLNDR_DAY_V PMNTH,
1295: DDR_TIME_CLNDR_DAY_V PQTR,
1296: DDR_TIME_CLNDR_DAY_V PYR,
1297: DDR_TIME_CLNDR_DAY_V NDAY,
1298: DDR_TIME_CLNDR_DAY_V NWK,
1299: DDR_TIME_CLNDR_DAY_V NMNTH,
1300: DDR_TIME_CLNDR_DAY_V NQTR,
1301: DDR_TIME_CLNDR_DAY_V NYR
1302: where BDAY.YR_CD = TO_CHAR(v_start_year)

Line 1299: DDR_TIME_CLNDR_DAY_V NMNTH,

1295: DDR_TIME_CLNDR_DAY_V PQTR,
1296: DDR_TIME_CLNDR_DAY_V PYR,
1297: DDR_TIME_CLNDR_DAY_V NDAY,
1298: DDR_TIME_CLNDR_DAY_V NWK,
1299: DDR_TIME_CLNDR_DAY_V NMNTH,
1300: DDR_TIME_CLNDR_DAY_V NQTR,
1301: DDR_TIME_CLNDR_DAY_V NYR
1302: where BDAY.YR_CD = TO_CHAR(v_start_year)
1303: AND PDAY.CLNDR_CD(+) = BDAY.CLNDR_CD

Line 1300: DDR_TIME_CLNDR_DAY_V NQTR,

1296: DDR_TIME_CLNDR_DAY_V PYR,
1297: DDR_TIME_CLNDR_DAY_V NDAY,
1298: DDR_TIME_CLNDR_DAY_V NWK,
1299: DDR_TIME_CLNDR_DAY_V NMNTH,
1300: DDR_TIME_CLNDR_DAY_V NQTR,
1301: DDR_TIME_CLNDR_DAY_V NYR
1302: where BDAY.YR_CD = TO_CHAR(v_start_year)
1303: AND PDAY.CLNDR_CD(+) = BDAY.CLNDR_CD
1304: AND PDAY.DAY_CD(+) = add_day(BDAY.DAY_CD,-1)

Line 1301: DDR_TIME_CLNDR_DAY_V NYR

1297: DDR_TIME_CLNDR_DAY_V NDAY,
1298: DDR_TIME_CLNDR_DAY_V NWK,
1299: DDR_TIME_CLNDR_DAY_V NMNTH,
1300: DDR_TIME_CLNDR_DAY_V NQTR,
1301: DDR_TIME_CLNDR_DAY_V NYR
1302: where BDAY.YR_CD = TO_CHAR(v_start_year)
1303: AND PDAY.CLNDR_CD(+) = BDAY.CLNDR_CD
1304: AND PDAY.DAY_CD(+) = add_day(BDAY.DAY_CD,-1)
1305: AND PWK.CLNDR_CD(+) = BDAY.CLNDR_CD

Line 1383: FROM DDR_TIME_CLNDR_DAY_V BDAY,

1379: g_creation_date,
1380: g_last_updated_by,
1381: g_last_update_date,
1382: g_last_update_login
1383: FROM DDR_TIME_CLNDR_DAY_V BDAY,
1384: DDR_TIME_CLNDR_DAY_V PDAY,
1385: DDR_TIME_CLNDR_DAY_V PWK,
1386: DDR_TIME_CLNDR_DAY_V PMNTH,
1387: DDR_TIME_CLNDR_DAY_V PQTR,

Line 1384: DDR_TIME_CLNDR_DAY_V PDAY,

1380: g_last_updated_by,
1381: g_last_update_date,
1382: g_last_update_login
1383: FROM DDR_TIME_CLNDR_DAY_V BDAY,
1384: DDR_TIME_CLNDR_DAY_V PDAY,
1385: DDR_TIME_CLNDR_DAY_V PWK,
1386: DDR_TIME_CLNDR_DAY_V PMNTH,
1387: DDR_TIME_CLNDR_DAY_V PQTR,
1388: DDR_TIME_CLNDR_DAY_V PYR,

Line 1385: DDR_TIME_CLNDR_DAY_V PWK,

1381: g_last_update_date,
1382: g_last_update_login
1383: FROM DDR_TIME_CLNDR_DAY_V BDAY,
1384: DDR_TIME_CLNDR_DAY_V PDAY,
1385: DDR_TIME_CLNDR_DAY_V PWK,
1386: DDR_TIME_CLNDR_DAY_V PMNTH,
1387: DDR_TIME_CLNDR_DAY_V PQTR,
1388: DDR_TIME_CLNDR_DAY_V PYR,
1389: DDR_TIME_CLNDR_DAY_V NDAY,

Line 1386: DDR_TIME_CLNDR_DAY_V PMNTH,

1382: g_last_update_login
1383: FROM DDR_TIME_CLNDR_DAY_V BDAY,
1384: DDR_TIME_CLNDR_DAY_V PDAY,
1385: DDR_TIME_CLNDR_DAY_V PWK,
1386: DDR_TIME_CLNDR_DAY_V PMNTH,
1387: DDR_TIME_CLNDR_DAY_V PQTR,
1388: DDR_TIME_CLNDR_DAY_V PYR,
1389: DDR_TIME_CLNDR_DAY_V NDAY,
1390: DDR_TIME_CLNDR_DAY_V NWK,

Line 1387: DDR_TIME_CLNDR_DAY_V PQTR,

1383: FROM DDR_TIME_CLNDR_DAY_V BDAY,
1384: DDR_TIME_CLNDR_DAY_V PDAY,
1385: DDR_TIME_CLNDR_DAY_V PWK,
1386: DDR_TIME_CLNDR_DAY_V PMNTH,
1387: DDR_TIME_CLNDR_DAY_V PQTR,
1388: DDR_TIME_CLNDR_DAY_V PYR,
1389: DDR_TIME_CLNDR_DAY_V NDAY,
1390: DDR_TIME_CLNDR_DAY_V NWK,
1391: DDR_TIME_CLNDR_DAY_V NMNTH,

Line 1388: DDR_TIME_CLNDR_DAY_V PYR,

1384: DDR_TIME_CLNDR_DAY_V PDAY,
1385: DDR_TIME_CLNDR_DAY_V PWK,
1386: DDR_TIME_CLNDR_DAY_V PMNTH,
1387: DDR_TIME_CLNDR_DAY_V PQTR,
1388: DDR_TIME_CLNDR_DAY_V PYR,
1389: DDR_TIME_CLNDR_DAY_V NDAY,
1390: DDR_TIME_CLNDR_DAY_V NWK,
1391: DDR_TIME_CLNDR_DAY_V NMNTH,
1392: DDR_TIME_CLNDR_DAY_V NQTR,

Line 1389: DDR_TIME_CLNDR_DAY_V NDAY,

1385: DDR_TIME_CLNDR_DAY_V PWK,
1386: DDR_TIME_CLNDR_DAY_V PMNTH,
1387: DDR_TIME_CLNDR_DAY_V PQTR,
1388: DDR_TIME_CLNDR_DAY_V PYR,
1389: DDR_TIME_CLNDR_DAY_V NDAY,
1390: DDR_TIME_CLNDR_DAY_V NWK,
1391: DDR_TIME_CLNDR_DAY_V NMNTH,
1392: DDR_TIME_CLNDR_DAY_V NQTR,
1393: DDR_TIME_CLNDR_DAY_V NYR

Line 1390: DDR_TIME_CLNDR_DAY_V NWK,

1386: DDR_TIME_CLNDR_DAY_V PMNTH,
1387: DDR_TIME_CLNDR_DAY_V PQTR,
1388: DDR_TIME_CLNDR_DAY_V PYR,
1389: DDR_TIME_CLNDR_DAY_V NDAY,
1390: DDR_TIME_CLNDR_DAY_V NWK,
1391: DDR_TIME_CLNDR_DAY_V NMNTH,
1392: DDR_TIME_CLNDR_DAY_V NQTR,
1393: DDR_TIME_CLNDR_DAY_V NYR
1394: where BDAY.YR_CD = TO_CHAR(v_start_year)

Line 1391: DDR_TIME_CLNDR_DAY_V NMNTH,

1387: DDR_TIME_CLNDR_DAY_V PQTR,
1388: DDR_TIME_CLNDR_DAY_V PYR,
1389: DDR_TIME_CLNDR_DAY_V NDAY,
1390: DDR_TIME_CLNDR_DAY_V NWK,
1391: DDR_TIME_CLNDR_DAY_V NMNTH,
1392: DDR_TIME_CLNDR_DAY_V NQTR,
1393: DDR_TIME_CLNDR_DAY_V NYR
1394: where BDAY.YR_CD = TO_CHAR(v_start_year)
1395: AND PDAY.CLNDR_CD(+) = BDAY.CLNDR_CD

Line 1392: DDR_TIME_CLNDR_DAY_V NQTR,

1388: DDR_TIME_CLNDR_DAY_V PYR,
1389: DDR_TIME_CLNDR_DAY_V NDAY,
1390: DDR_TIME_CLNDR_DAY_V NWK,
1391: DDR_TIME_CLNDR_DAY_V NMNTH,
1392: DDR_TIME_CLNDR_DAY_V NQTR,
1393: DDR_TIME_CLNDR_DAY_V NYR
1394: where BDAY.YR_CD = TO_CHAR(v_start_year)
1395: AND PDAY.CLNDR_CD(+) = BDAY.CLNDR_CD
1396: AND PDAY.DAY_CD(+) = add_day(BDAY.DAY_CD,-1)

Line 1393: DDR_TIME_CLNDR_DAY_V NYR

1389: DDR_TIME_CLNDR_DAY_V NDAY,
1390: DDR_TIME_CLNDR_DAY_V NWK,
1391: DDR_TIME_CLNDR_DAY_V NMNTH,
1392: DDR_TIME_CLNDR_DAY_V NQTR,
1393: DDR_TIME_CLNDR_DAY_V NYR
1394: where BDAY.YR_CD = TO_CHAR(v_start_year)
1395: AND PDAY.CLNDR_CD(+) = BDAY.CLNDR_CD
1396: AND PDAY.DAY_CD(+) = add_day(BDAY.DAY_CD,-1)
1397: AND PWK.CLNDR_CD(+) = BDAY.CLNDR_CD

Line 1760: FROM DDR_TIME_CLNDR_DAY_V

1756: FROM DDR_R_DAY_TODATE_TRANS
1757: WHERE (DAY_CD,CLNDR_CD) IN
1758: (SELECT DAY_CD,
1759: CLNDR_CD
1760: FROM DDR_TIME_CLNDR_DAY_V
1761: WHERE YR_CD BETWEEN TO_CHAR(p_start_year) AND TO_CHAR(p_end_year)
1762: );
1763: INSERT
1764: INTO DDR_R_DAY_TODATE_TRANS

Line 1803: FROM DDR_TIME_CLNDR_DAY_V A,

1799: A.DAY_CD DAY_CD,
1800: A.CLNDR_CD CLNDR_CD,
1801: A.CLNDR_TYP CLNDR_TYP,
1802: B.DAY_CD YR_DAY_CD
1803: FROM DDR_TIME_CLNDR_DAY_V A,
1804: DDR_TIME_CLNDR_DAY_V B
1805: WHERE A.YR_CD = B.YR_CD
1806: AND A.DAY_CD >= B.DAY_CD
1807: AND A.ORG_CD = B.ORG_CD

Line 1804: DDR_TIME_CLNDR_DAY_V B

1800: A.CLNDR_CD CLNDR_CD,
1801: A.CLNDR_TYP CLNDR_TYP,
1802: B.DAY_CD YR_DAY_CD
1803: FROM DDR_TIME_CLNDR_DAY_V A,
1804: DDR_TIME_CLNDR_DAY_V B
1805: WHERE A.YR_CD = B.YR_CD
1806: AND A.DAY_CD >= B.DAY_CD
1807: AND A.ORG_CD = B.ORG_CD
1808: AND A.YR_CD BETWEEN TO_CHAR(p_start_year) AND TO_CHAR(p_end_year)