DBA Data[Home] [Help]

APPS.PAY_IE_P60XML dependencies on PAY_ASSIGNMENT_ACTIONS

Line 365: ,pay_assignment_actions paa

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
369: ,pay_ie_prsi_details_f prsif

Line 430: /* and not exists (select 1 from pay_assignment_actions paax

426: or
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