[Home] [Help]
668: -- Cursor to get FTE value
669: CURSOR csr_get_fte_value (c_assignment_id NUMBER, c_effective_date DATE)
670: IS
671: SELECT VALUE fte
672: FROM per_assignment_budget_values_f
673: WHERE assignment_id = c_assignment_id
674: AND unit = 'FTE'
675: AND c_effective_date BETWEEN effective_start_date
676: AND effective_end_date