[Home] [Help]
80: w4_end_date in date)
81: RETURN NUMBER
82:
83: IS
84: l_bal_aaid pay_assignment_actions.assignment_action_id%type;
85: l_balance pay_run_result_values.result_value%type :=null;
86: l_hours_ytd number := 0;
87: l_gross_ytd number := 0;
88: l_gross_per_week number :=0;
91: -- Bug 3349705 - Cursor to fetch the latest assignment action id.
92: --
93: CURSOR c_get_latest_asg(p_person_id number ) IS
94: select paa.assignment_action_id
95: from pay_assignment_actions paa,
96: per_all_assignments_f paf,
97: pay_payroll_actions ppa,
98: pay_action_classifications pac
99: where paf.person_id = p_person_id
137:
138: Begin
139: select paa1.assignment_action_id
140: into l_bal_aaid
141: from pay_assignment_actions paa1,
142: per_assignments_f paf2,
143: pay_payroll_actions ppa2,
144: pay_action_classifications pac2
145: where paf2.person_id = w4_person_id
154: w4_end_date
155: and not exists (select ''
156: FROM pay_action_classifications pac,
157: pay_payroll_actions ppa,
158: pay_assignment_actions paa,
159: per_assignments_f paf1
160: WHERE paf1.person_id = w4_person_id
161: AND paa.assignment_id = paf1.assignment_id
162: AND paa.tax_unit_id = w4_tax_unit_id