DBA Data[Home] [Help]

APPS.HR_AE_VALIDATE_PKG dependencies on PER_ALL_PEOPLE_F

Line 304: FROM per_all_people_f

300: ,p_per_information20 in varchar2 default null
301: ) IS
302: CURSOR csr_person_type_id IS
303: SELECT person_type_id
304: FROM per_all_people_f
305: WHERE person_id = p_person_id
306: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
307: l_person_type_id NUMBER;
308: l_person_type VARCHAR2(20);

Line 1011: FROM per_all_people_f paf,

1007: ,p_region_1 IN VARCHAR2) IS
1008:
1009: CURSOR csr_fetch_bus_id IS
1010: SELECT distinct paf.business_group_id
1011: FROM per_all_people_f paf,
1012: hr_organization_information hoi
1013: WHERE paf.person_id = p_person_id
1014: AND paf.business_group_id = hoi.organization_id;
1015: