APPS.PAY_IE_EOY_INCOMELEVY_REPORT dependencies on PAY_IE_PRSI_DETAILS_F

Line 281: ,pay_ie_prsi_details_f prsif

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'
285: and to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD') between cp_start_date and cp_end_date

Line 333: from pay_ie_prsi_details_f prsi

329: and prsif.effective_start_date(+) <= cp_end_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD')*/
330: and prsif.effective_end_date(+) >= cp_start_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'START_DATE'),'YYYY/MM/DD')*/
331: --
332: and (prsif.effective_end_date = (select max(prsi.effective_end_date)
333: from pay_ie_prsi_details_f prsi
334: where prsi.assignment_id = paa.assignment_id
335: and prsi.effective_start_date <= cp_end_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD')*/
336: and prsi.effective_end_date >= cp_start_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'START_DATE'),'YYYY/MM/DD')*/
337: )