DBA Data[Home] [Help]

APPS.PAY_IE_PAYFILE_SEPA dependencies on PER_ALL_PEOPLE_F

Line 99: per_all_people_f pap

95: pay_payroll_actions pa1,
96: pay_pre_payments ppp,
97: pay_org_payment_methods_f OPM,
98: pay_payment_types PPT,
99: per_all_people_f pap
100: WHERE pa1.payroll_action_id = p_payroll_action_id
101: AND pa2.consolidation_set_id = p_consolidation_id
102: AND pa2.payroll_id = NVL(p_payroll_id,pa2.payroll_id)
103: AND pa2.effective_date <= pa1.effective_date

Line 489: ,per_all_people_f pef

485: SUM(record_count) er_count
486: FROM (SELECT SUM(ppp.value*100) employer_sum,
487: 1 record_count
488: FROM per_all_assignments_f paf
489: ,per_all_people_f pef
490: ,pay_all_payrolls_f ppf
491: ,pay_pre_payments ppp
492: ,pay_assignment_actions paa
493: ,pay_payroll_actions ppa