DBA Data[Home] [Help]

APPS.EAM_CONSTRUCTION_EST_PVT dependencies on EAM_CONSTRUCTION_UNIT_DETAILS

Line 2063: EAM_CONSTRUCTION_UNIT_DETAILS ECUD

2059: ECUD.ACCT_CLASS_CODE,
2060: ECUD.ACTIVITY_ID,
2061: ECUD.CU_ACTIVITY_QTY
2062: FROM EAM_CONSTRUCTION_UNITS ECU,
2063: EAM_CONSTRUCTION_UNIT_DETAILS ECUD
2064: WHERE ECU.CU_ID = p_cu_id
2065: AND ECU.CU_ID = ECUD.CU_ID
2066: AND ECU.CU_EFFECTIVE_FROM < SYSDATE + 1
2067: AND (ECU.CU_EFFECTIVE_TO IS NULL OR ECU.CU_EFFECTIVE_TO > SYSDATE)