APPS.PAY_GB_EDI_P46_CAR dependencies on PER_PEOPLE_F

Line 501: 'from per_people_f ppf, '||

497: --
498: hr_utility.set_location(l_proc, 30);
499: --
500: sqlstr := 'select distinct person_id '||
501: 'from per_people_f ppf, '||
502: 'pay_payroll_actions ppa '||
503: 'where ppa.payroll_action_id = :payroll_action_id '||
504: 'and ppa.business_group_id = ppf.business_group_id '||
505: 'order by ppf.person_id';

Line 597: 'from per_people_f ppf, '||

593: --
594: hr_utility.set_location(l_proc, 30);
595: --
596: sqlstr := 'select distinct person_id '||
597: 'from per_people_f ppf, '||
598: 'pay_payroll_actions ppa '||
599: 'where ppa.payroll_action_id = :payroll_action_id '||
600: 'and ppa.business_group_id = ppf.business_group_id '||
601: 'order by ppf.person_id';

Line 694: 'from per_people_f ppf, '||

690: --
691: hr_utility.set_location(l_proc, 30);
692: --
693: sqlstr := 'select distinct person_id '||
694: 'from per_people_f ppf, '||
695: 'pay_payroll_actions ppa '||
696: 'where ppa.payroll_action_id = :payroll_action_id '||
697: 'and ppa.business_group_id = ppf.business_group_id '||
698: 'order by ppf.person_id';

Line 790: 'from per_people_f ppf, '||

786: --
787: hr_utility.set_location(l_proc, 30);
788: --
789: sqlstr := 'select distinct person_id '||
790: 'from per_people_f ppf, '||
791: 'pay_payroll_actions ppa '||
792: 'where ppa.payroll_action_id = :payroll_action_id '||
793: 'and ppa.business_group_id = ppf.business_group_id '||
794: 'order by ppf.person_id';

Line 2918: FROM per_people_f p, per_assignments_f a

2914: , p.person_id
2915: , p.national_identifier
2916: , p.date_of_birth --For Bug 6652235
2917: , p.sex --For Bug 6652235
2918: FROM per_people_f p, per_assignments_f a
2919: WHERE a.assignment_id = p_assignment_id
2920: AND l_eff_date between
2921: a.effective_start_date and a.effective_end_date
2922: AND a.person_id = p.person_id