86: )
87: IS
88: SELECT DISTINCT papf.person_id
89: FROM per_all_people_f papf
90: ,per_periods_of_service ppos
91: WHERE ppos.person_id = papf.person_id
92: AND (papf.current_employee_flag = 'Y'
93: OR
94: ppos.final_process_date >= c_effective_date
724: pay_element_entries_f peef,
725: pay_element_entry_values_f eev,
726: pay_input_values_f inv,
727: pay_all_payrolls_f pap,
728: per_periods_of_service ppos, -- Added for considering Terminated Employees till FPD
729: hr_soft_coding_keyflex flex
730: where paaf.assignment_id = P_IN_ASSIGNMENT_ID
731: and paaf.assignment_type = 'E'
732: and paaf.person_id = papf.person_id