APPS.PAY_IE_P60XML dependencies on PAY_ALL_PAYROLLS_F

Line 370: ,pay_all_payrolls_f PAPF

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
374: -- and cp_start_date <= to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD') /*4641756*/

Line 451: from pay_all_payrolls_f PAPF1

447: and PAPF.business_group_id + 0 = p_business_group_id /*4483028*/
448: and PAPF.payroll_id = nvl(p_payroll_id,papf.payroll_id)
449: and papf.consolidation_set_id =nvl(p_consolidation_set_id,PAPF.consolidation_set_id)
450: and PAPF.effective_end_date = (select max(PAPF1.effective_end_date)
451: from pay_all_payrolls_f PAPF1
452: where PAPF1.payroll_id = PAPF.payroll_id
453: and PAPF1.effective_start_date <= cp_end_date --to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD')
454: and PAPF1.effective_end_date >= cp_start_date --to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'START_DATE'),'YYYY/MM/DD')
455: )