DBA Data[Home] [Help]

APPS.PAY_SIMULATOR_SS_PKG dependencies on PER_ALL_PEOPLE_F

Line 166: l_name per_all_people_f.full_name%TYPE;

162: END insert_row;
163:
164: FUNCTION get_employee_name
165: (p_person_id IN number) RETURN varchar2 IS
166: l_name per_all_people_f.full_name%TYPE;
167: BEGIN
168: SELECT full_name
169: INTO l_name
170: FROM per_all_people_f

Line 170: FROM per_all_people_f

166: l_name per_all_people_f.full_name%TYPE;
167: BEGIN
168: SELECT full_name
169: INTO l_name
170: FROM per_all_people_f
171: WHERE person_id = p_person_id
172: AND sysdate
173: BETWEEN effective_start_date
174: AND effective_end_date