APPS.OKL_OPI_PVT dependencies on IEX_CASES_ALL_B

Line 1036: l_case_number IEX_CASES_ALL_B.CASE_NUMBER%TYPE;

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
1040: ,ica.case_number

Line 1042: ,iex_cases_all_b ica

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';
1046: BEGIN

Line 1255: FROM iex_cases_all_b ica

1251: SELECT ica.owner_resource_id
1252: ,jre.source_name
1253: ,jre.source_phone
1254: ,jre.source_email
1255: FROM iex_cases_all_b ica
1256: ,jtf_rs_resource_extns jre
1257: WHERE ica.cas_id = cp_cas_id
1258: AND ica.owner_resource_id = jre.resource_id;
1259: BEGIN