APPS.MTH_CALENDAR_PKG dependencies on DUAL

Line 224: (SELECT LEVEL AS quarter FROM dual CONNECT BY LEVEL<=4) q

220: SYSDATE
221:
222: FROM MTH_GREGORIAN_CALENDAR CAL,
223:
224: (SELECT LEVEL AS quarter FROM dual CONNECT BY LEVEL<=4) q
225:
226: WHERE CAL.CALENDAR_QUARTER_ID IS NULL AND
227: CAL. CAL_YEAR_NUMBER >= P_START_YEAR;
228:

Line 339: (SELECT LEVEL AS MONTH FROM dual CONNECT BY LEVEL<=3) MONTH

335: SYSDATE AS CREATION_DATE,
336: SYSDATE AS LAST_UPDATE_DATE
337: FROM MTH_GREGORIAN_CALENDAR cal,
338:
339: (SELECT LEVEL AS MONTH FROM dual CONNECT BY LEVEL<=3) MONTH
340:
341: WHERE cal.CALENDAR_QUARTER_ID IS NOT NULL
342: AND cal.CALENDAR_MONTH_ID IS NULL
343: AND cal. CAL_YEAR_NUMBER >= P_START_YEAR;

Line 492: (SELECT LEVEL AS DAY_IN_MONTH FROM dual CONNECT BY LEVEL<=31) days

488: SYSDATE AS LAST_UPDATE_DATE
489:
490: FROM MTH_GREGORIAN_CALENDAR cal,
491:
492: (SELECT LEVEL AS DAY_IN_MONTH FROM dual CONNECT BY LEVEL<=31) days
493:
494: WHERE cal.DAY_ID IS NULL
495: AND cal.CALENDAR_MONTH_ID IS NOT NULL
496: AND cal.CAL_YEAR_NUMBER >= P_START_YEAR

Line 550: FROM dual

546: UNION
547: SELECT report_date day
548: FROM mth_day_d) days,
549: (SELECT LEVEL HOUR
550: FROM dual
551: CONNECT BY LEVEL <= 24) hours
552: ) cal_hours
553: ON
554: ( mhd.hour_pk = cal_hours.hour_pk)

Line 608: SELECT To_Number(To_Char(v_month_end_date, 'D')) into v_week_day_on_month_end FROM dual;

604: v_next_yr_start_dte := (P_START_MONTH ) || '/1/' || (P_YEAR + 1);
605: v_month_end_date := to_date(v_next_yr_start_dte, 'mm/dd/yyyy' ) - 1;
606:
607: -- 2. Find out the week day for the end of month of the year and end day of week
608: SELECT To_Number(To_Char(v_month_end_date, 'D')) into v_week_day_on_month_end FROM dual;
609: v_end_week_day := CASE WHEN P_START_WEEK_DAY = 1 THEN 7
610: ELSE P_START_WEEK_DAY - 1 END;
611:
612: -- 3. Calculate the year end date by comparing the week day of the month end with

Line 777: (select LEVEL AS quarter from dual connect by LEVEL <= 4) q

773:
774: SYSDATE,
775: SYSDATE
776: FROM MTH_445_PERIOD_CALENDAR cal,
777: (select LEVEL AS quarter from dual connect by LEVEL <= 4) q
778: WHERE cal.FISCAL_QUARTER_ID IS NULL
779: AND cal.FIS_YEAR_NUMBER >= P_START_YEAR;
780:
781: /*

Line 895: (select LEVEL AS MONTH from dual connect by LEVEL <= 3) MONTHS

891: ((FIS_QUARTER_NUMBER - 1) * 3 + MONTH) AS MONTH_OF_FISCAL_YEAR,
892: SYSDATE AS CREATION_DATE,
893: SYSDATE AS LAST_UPDATE_DATE
894: FROM MTH_445_PERIOD_CALENDAR cal,
895: (select LEVEL AS MONTH from dual connect by LEVEL <= 3) MONTHS
896: WHERE cal.FISCAL_QUARTER_ID IS NOT NULL
897: AND cal.FISCAL_MONTH_ID IS NULL
898: AND cal.FIS_YEAR_NUMBER >= P_START_YEAR;
899:

Line 1027: (select LEVEL AS WEEK from dual connect by LEVEL <= 6) WEEKS

1023: SYSDATE AS CREATION_DATE,
1024: SYSDATE AS LAST_UPDATE_DATE
1025:
1026: FROM MTH_445_PERIOD_CALENDAR cal,
1027: (select LEVEL AS WEEK from dual connect by LEVEL <= 6) WEEKS
1028: --at most 6 weeks in one month
1029: WHERE cal.FISCAL_MONTH_ID IS NOT NULL AND
1030: cal.FISCAL_WEEK_ID IS NULL AND
1031: cal.FIS_YEAR_NUMBER >= P_START_YEAR AND

Line 1177: (select LEVEL AS DAY_IN_WEEK from dual connect by LEVEL <= 7) days

1173: SYSDATE AS CREATION_DATE,
1174: SYSDATE AS LAST_UPDATE_DATE
1175:
1176: FROM MTH_445_PERIOD_CALENDAR cal,
1177: (select LEVEL AS DAY_IN_WEEK from dual connect by LEVEL <= 7) days
1178: WHERE cal.DAY_ID IS NULL
1179: AND cal.FISCAL_WEEK_ID IS NOT NULL
1180: AND cal.FIS_YEAR_NUMBER >= P_START_YEAR;
1181: