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