[Home] [Help]
151: stperson number,
152: endperson number,
153: c_assign_year number,
154: c_tax_unit_id pay_assignment_actions.tax_unit_id%type,
155: c_assign_set hr_assignment_set_amendments.assignment_set_id%type,
156: c_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type
157: ) is
158: select act.assignment_action_id,
159: act.assignment_id,
165: and act.tax_unit_id = c_tax_unit_id
166: and to_number(act.serial_number) between stperson and endperson
167: and exists ( select 1
168: from per_assignments_f paf,
169: hr_assignment_set_amendments hasa
170: where hasa.assignment_set_id = c_assign_set
171: and hasa.assignment_id = paf.assignment_id
172: and upper(hasa.include_or_exclude) = 'I'
173: and c_assign_set is not null