APPS.CSP_RECEIVE_PVT dependencies on HR_LOCATIONS_ALL

Line 118: X_location_code hr_locations_all.location_code%TYPE :='';

114: X_emp_id NUMBER := 0 ; /* stores the employee_id */
115: X_location_id NUMBER := 0 ; /* stores the location_id */
116: X_emp_name VARCHAR2(240) := '' ; /* stores the employee_name */
117:
118: X_location_code hr_locations_all.location_code%TYPE :='';
119: X_buyer_code VARCHAR2(1) := 'Y' ; /* dummy, stores buyer status */
120: mesg_buffer VARCHAR2(2000) := '' ; /* for handling error messages */
121: X_progress varchar2(3) := '';
122: l_api_name Varchar2(25) := 'get_employee';