APPS.PERFRPHR dependencies on PER_ALL_PEOPLE_F

Line 89: per_all_people_f peo

85: SELECT COUNT(asg.assignment_id)
86: FROM per_all_assignments_f asg,
87: per_assignment_status_types ast,
88: per_person_types_v pt,
89: per_all_people_f peo
90: WHERE asg.establishment_id IN (SELECT hr2.organization_id
91: FROM hr_organization_information hr1,
92: hr_organization_information hr2
93: WHERE hr1.organization_id = p_ent_id

Line 123: per_all_people_f peo2

119: OR EXISTS (SELECT null
120: FROM per_all_assignments_f asg2,
121: per_assignment_status_types ast2,
122: per_person_types_v pt2,
123: per_all_people_f peo2
124: WHERE asg2.establishment_id IN (SELECT hr2.organization_id
125: FROM hr_organization_information hr1,
126: hr_organization_information hr2
127: WHERE hr1.organization_id = p_ent_id

Line 195: l_fullname per_all_people_f.full_name%type;

191: l_ent_total NUMBER;
192: l_est_total NUMBER;
193: l_french VARCHAR2(80);
194: l_nationality VARCHAR2(80);
195: l_fullname per_all_people_f.full_name%type;
196: l_medical VARCHAR2(80);
197: l_nationality_type VARCHAR2(80);
198: l_naf_meaning VARCHAR2(80);
199: l_coun_of_birth VARCHAR2(80);

Line 319: per_all_people_f peo

315: hr_ALL_ORGANIZATION_UNITS OU1,
316: HR_ORGANIZATION_INFORMATION OI1,
317: per_assignment_extra_info ext,
318: per_all_assignments_f ass,
319: per_all_people_f peo
320: WHERE adr.person_id(+) = peo.person_id
321: AND adr.primary_flag(+) = 'Y'
322: AND con.contract_id(+) = ass.contract_id
323: AND l_date BETWEEN con.effective_start_date(+)

Line 425: per_all_people_f peo

421: hr_ALL_ORGANIZATION_UNITS OU1,
422: HR_ORGANIZATION_INFORMATION OI1,
423: per_assignment_extra_info ext,
424: per_all_assignments_f ass,
425: per_all_people_f peo
426: WHERE adr.person_id(+) = peo.person_id
427: AND adr.primary_flag(+) = 'Y'
428: AND con.contract_id(+) = ass.contract_id
429: AND l_date BETWEEN con.effective_start_date(+)