APPS.PAY_IE_P60XML dependencies on PAY_IE_PRSI_DETAILS_F

Line 278: ,pay_ie_prsi_details_f prsif

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'
282: 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 324: from pay_ie_prsi_details_f prsi

320: and prsif.effective_start_date(+) <= cp_end_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD')*/
321: and prsif.effective_end_date(+) >= cp_start_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'START_DATE'),'YYYY/MM/DD')*/
322: --
323: and (prsif.effective_end_date = (select max(prsi.effective_end_date)
324: from pay_ie_prsi_details_f prsi
325: where prsi.assignment_id = paa.assignment_id
326: and prsi.effective_start_date <= cp_end_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD')*/
327: and prsi.effective_end_date >= cp_start_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'START_DATE'),'YYYY/MM/DD')*/
328: )