1652: s.*,
1653: mdh.HIERARCHY_NAME,
1654: mss.SYSTEM_PK as SYSTEM_FK,
1655: P_SESSION_NO as RUN_ID
1656: FROM mth_year_d s,
1657: mth_dim_hierarchy mdh,
1658: mth_systems_setup mss
1659: WHERE mdh.hierarchy_id = s.hierarchy_id
1660: and mdh.dimension_name = 'TIME'
1691: ROLLBACK;
1692:
1693: select count(*)
1694: into v_year_err
1695: from MTH_YEAR_D;
1696:
1697: select count(*)
1698: into v_quarter_err
1699: from MTH_QUARTER_D;