APPS.HR_USER_ACCT_EMP_EXTRACT dependencies on PER_ALL_PEOPLE_F

Line 54: ,p_business_group_id in per_all_people_f.business_group_id%type

50: ,retcode out nocopy number
51: ,p_batch_name in hr_pump_batch_headers.batch_name%TYPE
52: ,p_date_from in varchar2 default null
53: ,p_date_to in varchar2 default null
54: ,p_business_group_id in per_all_people_f.business_group_id%type
55: ,p_single_org_id in per_organization_units.organization_id%type
56: default null
57: ,p_organization_structure_id in
58: per_organization_structures.organization_structure_id%type

Line 486: -- before the per_all_people_f.effective_start_date where

482: --
483: IF upper(p_run_type) = hr_user_acct_utility.g_inactivate_user OR
484: upper(p_run_type) = hr_user_acct_utility.g_cr_n_inact_user
485: -- For terminated ee, we want to select ppos.actual_termination_date 1 day
486: -- before the per_all_people_f.effective_start_date where
487: -- ppf.effective_start_date >= p_date_from and ppf.effective_end_date >=
488: -- p_date_to and ppf.person_type_id in system_person_type of 'EX_EMP' or
489: -- 'EX_EMP_APL'.
490: --

Line 639: ' select a.person_id from per_all_people_f a,'||

635: ' AND to_date(''' ||
636: l_date_to_char || ''', ''' || fnd_date.canonical_mask
637: || ''')' ||
638: ' ) AND ppf.person_id not in( '||
639: ' select a.person_id from per_all_people_f a,'||
640: ' per_periods_of_service b'||
641: ' where a.effective_start_date= b.date_start'||
642: ' and a.person_id=b.person_id'||
643: ' and a.business_group_id = b.business_group_id'||