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 478: -- before the per_all_people_f.effective_start_date where

474: --
475: IF upper(p_run_type) = hr_user_acct_utility.g_inactivate_user OR
476: upper(p_run_type) = hr_user_acct_utility.g_cr_n_inact_user
477: -- For terminated ee, we want to select ppos.actual_termination_date 1 day
478: -- before the per_all_people_f.effective_start_date where
479: -- ppf.effective_start_date >= p_date_from and ppf.effective_end_date >=
480: -- p_date_to and ppf.person_type_id in system_person_type of 'EX_EMP' or
481: -- 'EX_EMP_APL'.
482: --

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

627: ' AND to_date(''' ||
628: l_date_to_char || ''', ''' || fnd_date.canonical_mask
629: || ''')' ||
630: ' ) AND ppf.person_id not in( '||
631: ' select a.person_id from per_all_people_f a,'||
632: ' per_periods_of_service b'||
633: ' where a.effective_start_date= b.date_start'||
634: ' and a.person_id=b.person_id'||
635: ' and a.business_group_id = b.business_group_id'||