APPS.CSP_RECEIVE_PVT dependencies on HR_LOCATIONS

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';

Line 177: from hr_locations hr,

173:
174: */
175: select hr.location_code
176: into x_location_code
177: from hr_locations hr,
178: financials_system_parameters fsp,
179: hr_organization_information hoi
180: where hr.location_id = x_location_id
181: and hr.inventory_organization_id = hoi.organization_id