APPS.POR_HISTORY_FEED_PKG dependencies on HR_EMPLOYEES

Line 295: l_requester_name HR_EMPLOYEES.FULL_NAME%TYPE := NULL;

291: PROCEDURE Write_Header_Record IS
292:
293: l_po_number por_feed_records.po_number%TYPE := NULL;
294: l_card_member_name por_feed_records.card_member_name%TYPE := NULL;
295: l_requester_name HR_EMPLOYEES.FULL_NAME%TYPE := NULL;
296: l_requester_id por_feed_records.requester_id%TYPE := NULL;
297: l_payment_type_indicator VARCHAR2(1) := NULL;
298: l_order_status VARCHAR2(2):= NULL;
299: l_cr_dr_indicator VARCHAR2(1) := NULL;

Line 426: FROM HR_EMPLOYEES

422:
423: SELECT first_name || ' ' || middle_name ||
424: decode(middle_name, null, '', ' ') || last_name
425: INTO l_requester_name
426: FROM HR_EMPLOYEES
427: WHERE EMPLOYEE_ID = l_requester_id;
428:
429: END IF;
430: