APPS.PAY_IE_P60XML dependencies on PAY_ALL_PAYROLLS_F

Line 279: ,pay_all_payrolls_f PAPF

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

Line 354: from pay_all_payrolls_f PAPF1

350: and PAPF.business_group_id + 0 = p_business_group_id /*4483028*/
351: and PAPF.payroll_id = nvl(p_payroll_id,papf.payroll_id)
352: and papf.consolidation_set_id =nvl(p_consolidation_set_id,PAPF.consolidation_set_id)
353: and PAPF.effective_end_date = (select max(PAPF1.effective_end_date)
354: from pay_all_payrolls_f PAPF1
355: where PAPF1.payroll_id = PAPF.payroll_id
356: and PAPF1.effective_start_date <= cp_end_date --to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'END_DATE'),'YYYY/MM/DD')
357: and PAPF1.effective_end_date >= cp_start_date --to_date(pay_ie_p35.get_parameter(ppa35.payroll_action_id,'START_DATE'),'YYYY/MM/DD')
358: )