DBA Data[Home] [Help]

APPS.PAY_GB_PAYE_SYNC dependencies on PER_PERIODS_OF_SERVICE

Line 90: ,per_periods_of_service ppos

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

Line 728: per_periods_of_service ppos, -- Added for considering Terminated Employees till FPD

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