APPS.HR_RU_UTILITY dependencies on PER_ALL_PEOPLE_F

Line 113: l_last_name per_all_people_f.last_name%TYPE;

109: RETURN VARCHAR2
110: IS
111: --
112: l_full_name VARCHAR2 (240);
113: l_last_name per_all_people_f.last_name%TYPE;
114: --
115: BEGIN
116: --
117: IF use_genitive

Line 186: FROM per_all_people_f pp

182: INTO l_status
183: FROM SYS.dual
184: WHERE EXISTS (
185: SELECT '1'
186: FROM per_all_people_f pp
187: WHERE (p_person_id IS NULL OR p_person_id <> pp.person_id)
188: AND p_spifn = pp.per_information13
189: AND pp.business_group_id IN (
190: --Select all business groups having leg. code RU