APPS.PAY_GB_WNU_EDI dependencies on PER_PEOPLE_F

Line 348: per_people_f pap

344: pap.national_identifier,
345: paa.assignment_id
346: from pay_assignment_actions pact,
347: per_assignments_f paa,
348: per_people_f pap
349: where pact.assignment_action_id = p_assactid
350: and pact.assignment_id = paa.assignment_id
351: and paa.person_id = pap.person_id
352: and p_effective_date between paa.effective_start_date and paa.effective_end_date

Line 568: 'from per_people_f ppf, '||

564: l_proc CONSTANT VARCHAR2(35):= g_package||'range_cursor';
565: BEGIN
566: hr_utility.set_location('Entering: '||l_proc,1);
567: sqlstr := 'select distinct person_id '||
568: 'from per_people_f ppf, '||
569: 'pay_payroll_actions ppa '||
570: 'where ppa.payroll_action_id = :payroll_action_id '||
571: 'and ppa.business_group_id = ppf.business_group_id '||
572: 'order by ppf.person_id';