DBA Data[Home] [Help]

APPS.PAY_IE_P60XML dependencies on PAY_ASSIGNMENT_ACTIONS

Line 274: ,pay_assignment_actions paa

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

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

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