APPS.PYUDET dependencies on PER_ALL_PEOPLE_F

Line 188: from per_all_people_f peo,

184: pps.last_standard_process_date,
185: g_effective_date,
186: peo.effective_start_date,
187: peo.effective_end_date
188: from per_all_people_f peo,
189: per_all_assignments_f asg,
190: per_periods_of_service pps,
191: per_person_type_usages_f ptu,
192: per_person_types ppt

Line 1822: from per_all_people_f peo,

1818: 'EMP', --ppt.system_person_type,
1819: pps.actual_termination_date,
1820: pps.last_standard_process_date,
1821: p_m34_rec.effective_date
1822: from per_all_people_f peo,
1823: per_all_assignments_f asg,
1824: per_periods_of_service pps
1825: where asg.business_group_id = g_business_group_id
1826: and peo.business_group_id = g_business_group_id

Line 1874: from per_all_people_f peo,

1870: cursor csr_check_future_asg(p_tax_district varchar2,
1871: p_person_id number,
1872: p_date date) is
1873: select count(*)
1874: from per_all_people_f peo,
1875: per_all_assignments_f asg,
1876: pay_all_payrolls_f pay,
1877: hr_soft_coding_keyflex sck
1878: where peo.person_id = p_person_id

Line 2353: l_person_id per_all_people_f.person_id%type;

2349: p_validate_only in VARCHAR2 DEFAULT 'GB_VALIDATE_COMMIT')
2350: IS
2351: l_m34_rec g_tax_code_interface;
2352: l_m12_rec g_typ_per_record;
2353: l_person_id per_all_people_f.person_id%type;
2354: l_process boolean;
2355: BEGIN
2356: hr_utility.trace('Start of PYUDET');
2357: --------------------------------