DBA Data[Home] [Help]

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));