APPS.PAY_IE_P45_ARCHIVE dependencies on PER_PEOPLE_F

Line 3608: FROM per_people_f ppf,

3604: sqlstr := 'SELECT 1 FROM dual WHERE to_char(:payroll_action_id) = dummy';
3605: else
3606: */
3607: sqlstr := 'SELECT DISTINCT person_id
3608: FROM per_people_f ppf,
3609: pay_payroll_actions ppa
3610: WHERE ppa.payroll_action_id = :payroll_action_id
3611: AND ppa.business_group_id +0= ppf.business_group_id
3612: ORDER BY ppf.person_id';

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

3777: and paaf.person_id = p_person_id)
3778: GROUP BY paei.aei_information1;
3779:
3780: l_ppsn_override_asg per_assignment_extra_info.assignment_id%type;
3781: l_temp_person_id per_people_f.person_id%TYPE :=0;
3782:
3783:
3784: l_actid NUMBER;
3785: l_canonical_end_date DATE;