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 = 'EMP'
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 639: ' FROM per_person_types'||

635: ' and a.business_group_id = b.business_group_id'||
636: ' and b.actual_termination_date IS NULL '||
637: ' and a.person_type_id in('||
638: ' SELECT person_type_id'||
639: ' FROM per_person_types'||
640: ' WHERE business_group_id = ' || to_char(p_business_group_id) ||
641: ' AND system_person_type = ''EMP'' ' ||
642: ' AND active_flag = ''Y'' ))' ;
643: --