APPS.OKL_AM_SERVICE_K_INT_WF dependencies on OKL_ASSET_RETURNS_B
Line 138: FROM OKL_ASSET_RETURNS_B ART
134:
135: -- Get Asset Return Status Code for kle_id
136: CURSOR get_return_dtls_csr(p_kle_id IN NUMBER) IS
137: SELECT ART.ARS_CODE 138: FROM OKL_ASSET_RETURNS_B ART 139: WHERE ART.kle_id = p_kle_id
140: AND ART.ARS_CODE <> 'CANCELLED';
141:
142: l_scrapped_yn VARCHAR2(1) := 'N';