DBA Data[Home] [Help]

APPS.PAY_IE_EOY_INCOMELEVY_REPORT dependencies on PAY_IE_PAYE_DETAILS_F

Line 280: ,pay_ie_paye_details_f payef -- 10277535

276: ,pay_payroll_actions ppa35
277: ,pay_assignment_actions paa
278: ,per_assignments_f paf
279: ,per_periods_of_service pps
280: ,pay_ie_paye_details_f payef -- 10277535
281: ,pay_ie_prsi_details_f prsif
282: ,pay_all_payrolls_f PAPF
283: WHERE
284: NVl('N','N') = 'N'

Line 315: from pay_ie_paye_details_f paye

311: --
312: and payef.effective_start_date(+) <= cp_end_date -- 10277535
313: and payef.effective_end_date(+) >= cp_start_date -- 10277535
314: and (payef.effective_end_date = (select max(paye.effective_end_date)
315: from pay_ie_paye_details_f paye
316: where paye.assignment_id = paa.assignment_id
317: and paye.effective_start_date <= cp_end_date -- Bug#9503612 10277535
318: and paye.effective_end_date >= cp_start_date -- Bug#9503612 10277535
319: /* --6774415 Changed eff dates to cert dates, nvl for 8229764