APPS.OKL_OPI_PVT dependencies on IEX_CASE_OBJECTS

Line 1035: l_cas_id IEX_CASE_OBJECTS.CAS_ID%TYPE;

1031: x_case_number OUT NOCOPY VARCHAR2,
1032: x_return_status OUT NOCOPY VARCHAR2) AS
1033:
1034: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1035: l_cas_id IEX_CASE_OBJECTS.CAS_ID%TYPE;
1036: l_case_number IEX_CASES_ALL_B.CASE_NUMBER%TYPE;
1037:
1038: CURSOR l_case_csr(cp_contract_id IN NUMBER) IS
1039: SELECT ico.cas_id

Line 1041: FROM iex_case_objects ico

1037:
1038: CURSOR l_case_csr(cp_contract_id IN NUMBER) IS
1039: SELECT ico.cas_id
1040: ,ica.case_number
1041: FROM iex_case_objects ico
1042: ,iex_cases_all_b ica
1043: WHERE ico.object_id = cp_contract_id
1044: AND ico.cas_id = ica.cas_id
1045: AND ica.active_flag = 'Y';