APPS.EAM_CONSTRUCTION_EST_PVT dependencies on EAM_CONSTRUCTION_UNITS

Line 1940: px_cu_tbl IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_UNITS_TBL,

1936: p_commit IN VARCHAR2,
1937: p_init_msg_list IN VARCHAR2,
1938: p_validation_level IN NUMBER,
1939: p_org_id IN NUMBER,
1940: px_cu_tbl IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_UNITS_TBL,
1941: x_return_status OUT NOCOPY VARCHAR2,
1942: x_msg_count OUT NOCOPY NUMBER,
1943: x_msg_data OUT NOCOPY VARCHAR2
1944: )

Line 1996: FROM EAM_CONSTRUCTION_UNITS

1992: px_cu_tbl(l_index).DESCRIPTION,
1993: px_cu_tbl(l_index).ORGANIZATION_ID,
1994: px_cu_tbl(l_index).CU_EFFECTIVE_FROM,
1995: px_cu_tbl(l_index).CU_EFFECTIVE_TO
1996: FROM EAM_CONSTRUCTION_UNITS
1997: WHERE CU_ID = px_cu_tbl(l_index).CU_ID
1998: AND ORGANIZATION_ID = p_org_id
1999: AND CU_EFFECTIVE_FROM <= SYSDATE
2000: AND (CU_EFFECTIVE_TO IS NULL OR CU_EFFECTIVE_TO > SYSDATE);

Line 2062: FROM EAM_CONSTRUCTION_UNITS ECU,

2058: ECU.ORGANIZATION_ID,
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

Line 2123: FROM EAM_CONSTRUCTION_UNITS

2119: SELECT CU_NAME,
2120: DESCRIPTION
2121: INTO l_activities_rec.CU_NAME,
2122: l_activities_rec.CU_DESCRIPTION
2123: FROM EAM_CONSTRUCTION_UNITS
2124: WHERE CU_ID = l_activities_rec.CU_ID;
2125: EXCEPTION
2126: WHEN OTHERS THEN
2127: NULL;