DBA Data[Home] [Help]

APPS.PAY_IE_P60XML dependencies on PAY_IE_PAYE_DETAILS_F

Line 368: ,pay_ie_paye_details_f payef

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
370: ,pay_all_payrolls_f PAPF
371: WHERE
372: NVl('N','N') = 'N'

Line 403: from pay_ie_paye_details_f paye

399: and payef.effective_end_date(+) >= cp_start_date
400:
401: --
402: and (payef.effective_end_date = (select max(paye.effective_end_date)
403: from pay_ie_paye_details_f paye
404: where paye.assignment_id = paa.assignment_id
405: and paye.effective_start_date <= cp_end_date
406: and paye.effective_end_date >= cp_start_date
407: /* --6774415 Changed eff dates to cert dates, nvl for 8229764