DBA Data[Home] [Help]

APPS.PA_RBS_UTILS dependencies on PER_PERSON_TYPES

Line 127: from hr_lookups lk, per_person_types per

123: IF p_resource_type_code = 'PERSON_TYPE' THEN
124: BEGIN
125: SELECT lk.meaning
126: INTO l_element_name
127: from hr_lookups lk, per_person_types per
128: where lk.lookup_type = 'PERSON_TYPE'
129: and per.system_person_type in ('EMP', 'CWK')
130: and per.system_person_type = lk.lookup_code
131: and per.business_group_id = 0