DBA Data[Home] [Help]

APPS.PER_SSHR_CHANGE_PAY dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 5322: from per_assignment_budget_values_f

5318: --
5319: CURSOR csr_fte_BFTE
5320: IS
5321: select nvl(value, 1) val
5322: from per_assignment_budget_values_f
5323: where assignment_id = p_assignment_id
5324: and unit = 'FTE'
5325: and p_effective_date BETWEEN effective_start_date AND effective_end_date;
5326: --

Line 5330: from per_assignment_budget_values_f

5326: --
5327: CURSOR csr_fte_BPFT
5328: IS
5329: select nvl(value, 1) val
5330: from per_assignment_budget_values_f
5331: where assignment_id = p_assignment_id
5332: and unit = 'PFT'
5333: and p_effective_date BETWEEN effective_start_date AND effective_end_date;
5334: --