6: -- Bug 4442484: Include 'S'kipped assacts in c_range_code
7: c_range_cursor constant varchar2(32767) :=
8: 'select
9: distinct pds.person_id
10: from per_periods_of_service pds,
11: per_assignments_f asg,
12: pay_payroll_actions ppa
13: where ppa.payroll_action_id = :payroll_action_id
14: and asg.payroll_id = to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, ''PAYROLL_ID'', null))
113: select
114: asg.assignment_id
115: --
116: from per_assignments_f asg,
117: per_periods_of_service pds,
118: pay_payroll_actions ppa
119: --
120: where ppa.payroll_action_id = p_payroll_action_id
121: and pds.person_id between p_start_person_id and p_end_person_id
226: select
227: asg.assignment_id
228: --
229: from per_assignments_f asg,
230: per_periods_of_service pds,
231: pay_payroll_actions ppa
232: --
233: where ppa.payroll_action_id = p_payroll_action_id
234: and pds.person_id between p_start_person_id and p_end_person_id