APPS.HR_USER_ACCT_EMP_EXTRACT dependencies on PER_PERSON_TYPES

Line 100: FROM per_person_types

96:
97: CURSOR lc_get_ex_emp_per_type_id
98: IS
99: SELECT person_type_id
100: FROM per_person_types
101: WHERE business_group_id = p_business_group_id
102: AND SYSTEM_PERSON_TYPE IN ( 'EMP','EMP_APL')
103: AND active_flag = 'Y';
104:

Line 109: FROM per_person_types

105: --
106: CURSOR lc_get_emp_per_type_id
107: IS
108: SELECT person_type_id
109: FROM per_person_types
110: WHERE business_group_id = p_business_group_id
111: AND (SYSTEM_PERSON_TYPE = 'EMP'
112: OR
113: SYSTEM_PERSON_TYPE = 'EMP_APL')

Line 647: ' FROM per_person_types'||

643: ' and a.business_group_id = b.business_group_id'||
644: ' and b.actual_termination_date IS NULL '||
645: ' and a.person_type_id in('||
646: ' SELECT person_type_id'||
647: ' FROM per_person_types'||
648: ' WHERE business_group_id = ' || to_char(p_business_group_id) ||
649: ' AND system_person_type IN (''EMP'',''EMP_APL'' )' ||
650: ' AND active_flag = ''Y'' ))' ;
651: --