DBA Data[Home] [Help]

APPS.MTH_CALENDAR_PKG dependencies on MTH_DAY_D

Line 548: FROM mth_day_d) days,

544: FROM mth_445_period_calendar
545: WHERE day IS NOT NULL
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

Line 1432: FROM mth_day_d s,

1428: over (ORDER BY REPORT_DATE) PREV_REPORT_DATE,
1429: s.*,
1430: mss.SYSTEM_PK as SYSTEM_FK,
1431: P_SESSION_NO as RUN_ID
1432: FROM mth_day_d s,
1433: mth_systems_setup mss
1434: WHERE s.system_fk_key = mss.system_pk_key)e
1435: WHERE PREV_REPORT_DATE + 1 <> REPORT_DATE);
1436: /*UNION

Line 1711: from MTH_DAY_D;

1707: from MTH_WEEK_D;
1708:
1709: select count(*)
1710: into v_day_err
1711: from MTH_DAY_D;
1712:
1713: select count(*)
1714: into v_time_hrcy_err
1715: from MTH_TIME_HIERARCHY;