APPS.FA_CUA_ASSET_WB_APIS_PKG dependencies on FA_EMPLOYEES

Line 218: from fa_employees

214:
215: Function get_employee_name (x_id in number) return varchar2 is
216: cursor c is
217: select name
218: from fa_employees
219: where employee_id = x_id;
220:
221: v_name fa_employees.name%type;
222:

Line 221: v_name fa_employees.name%type;

217: select name
218: from fa_employees
219: where employee_id = x_id;
220:
221: v_name fa_employees.name%type;
222:
223: begin
224: open c;
225: fetch c into v_name;

Line 233: from fa_employees

229:
230: Function get_employee_number (x_id in number) return varchar2 is
231: cursor c is
232: select employee_number
233: from fa_employees
234: where employee_id = x_id;
235:
236: v_employee_number fa_employees.employee_number%type;
237:

Line 236: v_employee_number fa_employees.employee_number%type;

232: select employee_number
233: from fa_employees
234: where employee_id = x_id;
235:
236: v_employee_number fa_employees.employee_number%type;
237:
238: begin
239: open c;
240: fetch c into v_employee_number;