[Home] [Help]
910: l_return NUMBER;
911: CURSOR csr_get_fte_value
912: IS
913: SELECT value
914: FROM PER_ASSIGNMENT_BUDGET_VALUES_F
915: WHERE assignment_id = g_assignment_id
916: AND UNIT = 'FTE'
917: AND p_claim_date between effective_start_date
918: AND effective_end_date;