550: FROM
551: per_all_people_f papf
552: ,per_all_assignments_f paaf
553: ,pay_payrolls_f ppf
554: ,hr_soft_coding_keyflex scl
555: --,pay_assignment_actions paa
556: --,pay_payroll_actions ppa
557: WHERE paaf.person_id BETWEEN p_start_person AND p_end_person
558: AND papf.PERSON_ID = paaf.PERSON_ID
591: paaf.effective_start_date ASG_START_DATE
592: ,paaf.effective_end_date ASG_END_DATE
593: FROM
594: per_all_assignments_f paaf
595: ,hr_soft_coding_keyflex scl
596: where
597: paaf.assignment_id = p_assignment_id1
598: AND paaf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
599: AND scl.enabled_flag = 'Y'