DBA Data[Home] [Help]

APPS.PAY_IE_P60XML dependencies on PAY_PAYROLL_ACTIONS

Line 273: ,pay_payroll_actions ppa35

269: ,paf.assignment_id assignment_id /*6876894*/
270: FROM pay_action_information pai /*Employee Details Info*/
271: ,pay_action_information pai_prsi /* prsi Details 5657992 */
272: ,pay_action_information pact_ade /*Address Details - for Employer Name -IE Employer Tax Address*/
273: ,pay_payroll_actions ppa35
274: ,pay_assignment_actions paa
275: ,per_assignments_f paf
276: ,per_periods_of_service pps
277: ,pay_ie_paye_details_f payef

Line 334: ,pay_payroll_actions ppax

330: prsif.effective_end_date IS NULL
331: )
332: -- Bug 3446744 Removed the check of a P45 existence
333: /* and not exists (select 1 from pay_assignment_actions paax
334: ,pay_payroll_actions ppax
335: WHERE
336: paax.assignment_id = paa.assignment_id
337: and ppax.payroll_action_id = paax.payroll_action_id
338: and ppax.report_type = 'P45'