APPS.PAY_IE_P60XML dependencies on PAY_IE_PRSI_DETAILS_F

Line 369: ,pay_ie_prsi_details_f prsif

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'
373: 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 421: from pay_ie_prsi_details_f prsi

417: and prsif.effective_start_date(+) <= cp_end_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD')*/
418: and prsif.effective_end_date(+) >= cp_start_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'START_DATE'),'YYYY/MM/DD')*/
419: --
420: and (prsif.effective_end_date = (select max(prsi.effective_end_date)
421: from pay_ie_prsi_details_f prsi
422: where prsi.assignment_id = paa.assignment_id
423: and prsi.effective_start_date <= cp_end_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD')*/
424: and prsi.effective_end_date >= cp_start_date /*to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'START_DATE'),'YYYY/MM/DD')*/
425: )