DBA Data[Home] [Help]

APPS.PAY_IE_P60XML dependencies on PAY_PAYROLL_ACTIONS

Line 364: ,pay_payroll_actions ppa35

360: --14659262
361: FROM pay_action_information pai /*Employee Details Info*/
362: ,pay_action_information pai_prsi /* prsi Details 5657992 */
363: ,pay_action_information pact_ade /*Address Details - for Employer Name -IE Employer Tax Address*/
364: ,pay_payroll_actions ppa35
365: ,pay_assignment_actions paa
366: ,per_assignments_f paf
367: ,per_periods_of_service pps
368: ,pay_ie_paye_details_f payef

Line 431: ,pay_payroll_actions ppax

427: prsif.effective_end_date IS NULL
428: )
429: -- Bug 3446744 Removed the check of a P45 existence
430: /* and not exists (select 1 from pay_assignment_actions paax
431: ,pay_payroll_actions ppax
432: WHERE
433: paax.assignment_id = paa.assignment_id
434: and ppax.payroll_action_id = paax.payroll_action_id
435: and ppax.report_type = 'P45'