APPS.MTH_CALENDAR_PKG dependencies on MTH_SYSTEMS_SETUP

Line 1433: mth_systems_setup mss

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
1437: SELECT REPORT_DATE, USER_ATTR1, USER_ATTR2,

Line 1487: mth_systems_setup mss

1483: mss.SYSTEM_PK as SYSTEM_FK,
1484: P_SESSION_NO as RUN_ID
1485: FROM mth_week_d s,
1486: mth_dim_hierarchy mdh,
1487: mth_systems_setup mss
1488: WHERE mdh.hierarchy_id = s.hierarchy_id
1489: and mdh.dimension_name = 'TIME'
1490: and s.system_fk_key = mss.system_pk_key)e
1491: WHERE START_DATE <> PREV_END_DATE+1);

Line 1544: mth_systems_setup mss

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'
1547: and s.system_fk_key = mss.system_pk_key)e
1548: WHERE START_DATE <> PREV_END_DATE+1);

Line 1601: mth_systems_setup mss

1597: mss.SYSTEM_PK as SYSTEM_FK,
1598: P_SESSION_NO as RUN_ID
1599: FROM mth_quarter_d s,
1600: mth_dim_hierarchy mdh,
1601: mth_systems_setup mss
1602: WHERE mdh.hierarchy_id = s.hierarchy_id
1603: and mdh.dimension_name = 'TIME'
1604: and s.system_fk_key = mss.system_pk_key)e
1605: WHERE START_DATE <> PREV_END_DATE+1);

Line 1658: mth_systems_setup mss

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'
1661: and s.system_fk_key = mss.system_pk_key)e
1662: WHERE START_DATE <> PREV_END_DATE+1);