137: SELECT
138: PPX.FULL_NAME
139: INTO V_FULLNAME
140: FROM
141: PER_PEOPLE_X PPX,
142: FND_USER FU
143: WHERE FU.USER_ID = P_APPROVED_BY
144: AND PPX.PERSON_ID = FU.EMPLOYEE_ID;
145: RETURN (V_FULLNAME);
158: SELECT
159: PPX.FULL_NAME
160: INTO V_FULLNAME
161: FROM
162: PER_PEOPLE_X PPX,
163: FND_USER FU
164: WHERE FU.USER_ID = P_SUBMITTED_BY
165: AND PPX.PERSON_ID = FU.EMPLOYEE_ID;
166: RETURN (V_FULLNAME);