207: SELECT assignment_id
208: FROM per_all_assignments_f asl
209: ,hr_soft_coding_keyflex hr
210: ,hr_organization_information hoi
211: ,per_absence_attendance_types pat
212: ,per_absence_attendances paa
213: ,pay_payroll_actions ppa
214: where ppa.payroll_action_id = c_p_actid
215: AND asl.person_id BETWEEN stperson AND endperson
523: ,pay_payroll_actions ppa
524: ,per_periods_of_service pps
525: ,hr_soft_coding_keyflex hr
526: ,hr_organization_information hoi
527: ,per_absence_attendance_types pat
528: ,per_absence_attendances paat
529: WHERE paas.assignment_action_id = p_assactid
530: AND paas.payroll_action_id = ppa.payroll_action_id
531: AND paa.assignment_id = paas.assignment_id