APPS.PAY_IE_CESS_REPORT dependencies on PER_PEOPLE_F

Line 1559: FROM per_people_f ppf,

1555: hr_utility.set_location('l_employer = ' || l_employer,20);
1556: hr_utility.set_location('l_bg_id = ' || l_bg_id,20);
1557:
1558: sqlstr := 'SELECT DISTINCT person_id
1559: FROM per_people_f ppf,
1560: pay_payroll_actions ppa
1561: WHERE ppa.payroll_action_id = :payroll_action_id
1562: AND ppa.business_group_id +0= ppf.business_group_id
1563: ORDER BY ppf.person_id';

Line 1751: l_temp_person_id per_people_f.person_id%TYPE :=0;

1747: GROUP BY paei.aei_information1;
1748:
1749:
1750: l_ppsn_override_asg per_assignment_extra_info.assignment_id%type;
1751: l_temp_person_id per_people_f.person_id%TYPE :=0;
1752:
1753:
1754: l_actid NUMBER;
1755: l_canonical_end_date DATE;