APPS.OKL_RELEASE_PVT dependencies on OKX_AST_LOCS_V
Line 1945: FROM okx_ast_locs_v
1941: AND status = 'A';
1942:
1943: CURSOR chk_fa_loc_csr(p_location_id IN NUMBER) IS
1944: SELECT 'Y' 1945: FROM okx_ast_locs_v 1946: WHERE id1= p_location_id
1947: AND NVL(enabled_flag,'Y') = 'Y'
1948: AND TRUNC(SYSDATE) BETWEEN NVL(start_date_active, TRUNC(SYSDATE))
1949: AND NVL(end_date_active, TRUNC(SYSDATE));