DBA Data[Home] [Help]

APPS.PAY_IE_EOY_INCOMELEVY_REPORT dependencies on PER_PERIODS_OF_SERVICE

Line 279: ,per_periods_of_service pps

275: ,pay_action_information pact_ade /*Address Details - for Employer Name -IE Employer Tax Address*/
276: ,pay_payroll_actions ppa35
277: ,pay_assignment_actions paa
278: ,per_assignments_f paf
279: ,per_periods_of_service pps
280: ,pay_ie_paye_details_f payef -- 10277535
281: ,pay_ie_prsi_details_f prsif
282: ,pay_all_payrolls_f PAPF
283: WHERE

Line 489: FROM per_periods_of_service pps

485: v_assignment_id NUMBER,
486: v_paye_ref NUMBER) IS
487:
488: SELECT max(pps.period_of_service_id)
489: FROM per_periods_of_service pps
490: ,per_assignments_f asg
491: ,pay_all_payrolls_f pay
492: ,hr_soft_coding_keyflex flex
493: WHERE pps.person_id = v_person_id