DBA Data[Home] [Help]

APPS.MTH_UTIL_PKG dependencies on MTH_445_PERIOD_CALENDAR

Line 4588: ) STG ,MTH_SYSTEMS_SETUP SP,MTH_PLANTS_D PD,MTH_ORGANIZATIONS_L MOL,(SELECT DISTINCT DAY FROM(SELECT DAY FROM MTH_445_PERIOD_CALENDAR

4584: FROM
4585: ( SELECT DISTINCT SHIFT_DATE,SOURCE_ORG_CODE,system_fk from
4586: MTH_WORKDAY_SHIFTS_STG STG where STG.processing_flag = v_processing_flag
4587: AND STG.ERR_CODE IS NULL
4588: ) STG ,MTH_SYSTEMS_SETUP SP,MTH_PLANTS_D PD,MTH_ORGANIZATIONS_L MOL,(SELECT DISTINCT DAY FROM(SELECT DAY FROM MTH_445_PERIOD_CALENDAR
4589: UNION
4590: SELECT DAY FROM MTH_GREGORIAN_CALENDAR
4591: UNION
4592: SELECT REPORT_DATE DAY FROM MTH_DAY_D )) CATCH_ALL