151: sqlstr := 'SELECT distinct ASG.person_id
152: FROM per_assignments_f ASG,
153: hr_organization_units HOU,
154: pay_payrolls_f PPY,
155: pay_state_rules SR,
156: hr_organization_information HOI,
157: pay_us_asg_reporting puar,
158: pay_payroll_actions PPA
159: WHERE PPA.payroll_action_id = :payroll_action_id
220: sr.jurisdiction_code jurisdiction_code
221: FROM hr_organization_information hoi,
222: pay_payroll_actions ppa,
223: pay_assignment_actions paa,
224: pay_state_rules sr,
225: per_assignments_f asg,
226: pay_payroll_actions ppa_arch
227: WHERE ppa_arch.payroll_action_id = pactid
228: AND asg.person_id between stperson and endperson