APPS.OKL_RELEASE_PVT dependencies on OKX_AST_LOCS_V
Line 1969: FROM okx_ast_locs_v
1965: AND status = 'A';
1966:
1967: CURSOR chk_fa_loc_csr(p_location_id IN NUMBER) IS
1968: SELECT 'Y' 1969: FROM okx_ast_locs_v 1970: WHERE id1= p_location_id
1971: AND NVL(enabled_flag,'Y') = 'Y'
1972: AND TRUNC(SYSDATE) BETWEEN NVL(start_date_active, TRUNC(SYSDATE))
1973: AND NVL(end_date_active, TRUNC(SYSDATE));