DBA Data[Home] [Help]

APPS.MTH_UTIL_PKG dependencies on MTH_DAY_D

Line 4592: SELECT REPORT_DATE DAY FROM MTH_DAY_D )) CATCH_ALL

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
4593: WHERE NVL ( STG.SYSTEM_FK , MTH_UTIL_PKG.MTH_UA_GET_VAL ) = SP.SYSTEM_PK
4594: AND NVL(PD.TO_DATE,SYSDATE) >= TRUNC(SYSDATE)
4595: AND PD.PLANT_PK_KEY = MOL.PLANT_FK_KEY
4596: AND MOL.SYSTEM_FK_KEY = SP.SYSTEM_PK_KEY