APPS.EAM_CONSTRUCTION_EST_PVT dependencies on EAM_CONSTRUCTION_UNITS

Line 1805: px_cu_tbl IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_UNITS_TBL,

1801: p_commit IN VARCHAR2,
1802: p_init_msg_list IN VARCHAR2,
1803: p_validation_level IN NUMBER,
1804: p_org_id IN NUMBER,
1805: px_cu_tbl IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_UNITS_TBL,
1806: x_return_status OUT NOCOPY VARCHAR2,
1807: x_msg_count OUT NOCOPY NUMBER,
1808: x_msg_data OUT NOCOPY VARCHAR2
1809: )

Line 1861: FROM EAM_CONSTRUCTION_UNITS

1857: px_cu_tbl(l_index).DESCRIPTION,
1858: px_cu_tbl(l_index).ORGANIZATION_ID,
1859: px_cu_tbl(l_index).CU_EFFECTIVE_FROM,
1860: px_cu_tbl(l_index).CU_EFFECTIVE_TO
1861: FROM EAM_CONSTRUCTION_UNITS
1862: WHERE CU_ID = px_cu_tbl(l_index).CU_ID
1863: AND ORGANIZATION_ID = p_org_id
1864: AND CU_EFFECTIVE_FROM <= SYSDATE
1865: AND (CU_EFFECTIVE_TO IS NULL OR CU_EFFECTIVE_TO > SYSDATE);

Line 1927: FROM EAM_CONSTRUCTION_UNITS ECU,

1923: ECU.ORGANIZATION_ID,
1924: ECUD.ACCT_CLASS_CODE,
1925: ECUD.ACTIVITY_ID,
1926: ECUD.CU_ACTIVITY_QTY
1927: FROM EAM_CONSTRUCTION_UNITS ECU,
1928: EAM_CONSTRUCTION_UNIT_DETAILS ECUD
1929: WHERE ECU.CU_ID = p_cu_id
1930: AND ECU.CU_ID = ECUD.CU_ID
1931: AND ECU.CU_EFFECTIVE_FROM < SYSDATE + 1

Line 1988: FROM EAM_CONSTRUCTION_UNITS

1984: SELECT CU_NAME,
1985: DESCRIPTION
1986: INTO l_activities_rec.CU_NAME,
1987: l_activities_rec.CU_DESCRIPTION
1988: FROM EAM_CONSTRUCTION_UNITS
1989: WHERE CU_ID = l_activities_rec.CU_ID;
1990: EXCEPTION
1991: WHEN OTHERS THEN
1992: NULL;