DBA Data[Home] [Help]

APPS.MTH_CALENDAR_PKG dependencies on MTH_PERIOD_D

Line 1542: FROM mth_period_d s,

1538: s.*,
1539: mdh.HIERARCHY_NAME,
1540: mss.SYSTEM_PK as SYSTEM_FK,
1541: P_SESSION_NO as RUN_ID
1542: FROM mth_period_d s,
1543: mth_dim_hierarchy mdh,
1544: mth_systems_setup mss
1545: WHERE mdh.hierarchy_id = s.hierarchy_id
1546: and mdh.dimension_name = 'TIME'

Line 1703: from MTH_PERIOD_D;

1699: from MTH_QUARTER_D;
1700:
1701: select count(*)
1702: into v_period_err
1703: from MTH_PERIOD_D;
1704:
1705: select count(*)
1706: into v_week_err
1707: from MTH_WEEK_D;