DBA Data[Home] [Help]

APPS.PAY_IE_P60XML dependencies on PAY_IE_PAYE_DETAILS_F

Line 277: ,pay_ie_paye_details_f payef

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
279: ,pay_all_payrolls_f PAPF
280: WHERE
281: NVl('N','N') = 'N'

Line 308: from pay_ie_paye_details_f paye

304: and payef.certificate_start_date(+) <= cp_end_date
305: and (payef.certificate_end_date IS NULL OR payef.certificate_end_date >= cp_start_date)
306: --
307: and (payef.effective_end_date = (select max(paye.effective_end_date)
308: from pay_ie_paye_details_f paye
309: where paye.assignment_id = paa.assignment_id
310: --6774415 Changed eff dates to cert dates
311: and paye.certificate_start_date <= cp_end_date
312: and nvl(paye.certificate_end_date,to_date('31/12/4712','DD/MM/YYYY')) >= cp_start_date