[Home] [Help]
5180: --
5181: CURSOR csr_fte_BFTE
5182: IS
5183: select nvl(value, 1) val
5184: from per_assignment_budget_values_f
5185: where assignment_id = p_assignment_id
5186: and unit = 'FTE'
5187: and p_effective_date BETWEEN effective_start_date AND effective_end_date;
5188: --
5188: --
5189: CURSOR csr_fte_BPFT
5190: IS
5191: select nvl(value, 1) val
5192: from per_assignment_budget_values_f
5193: where assignment_id = p_assignment_id
5194: and unit = 'PFT'
5195: and p_effective_date BETWEEN effective_start_date AND effective_end_date;
5196: --