APPS.QA_LOCATION dependencies on HR_LOCATIONS_ALL

Line 14: loc_code hr_locations_all.location_code%TYPE; -- Incoming Location Code

10: -- or so.
11: --
12: final dbms_sql.varchar2s;
13: l_most_common varchar2(30);
14: loc_code hr_locations_all.location_code%TYPE; -- Incoming Location Code
15: c integer; -- Cursor
16: n integer; -- No. of rows returned
17: l_status integer;
18:

Line 51: from hr_locations_all

47: --
48: -- Find the location code for the given location_id
49: --
50: select location_code into loc_code
51: from hr_locations_all
52: where location_id = p_location_id;
53:
54: --
55: -- Bug 3930666. Use bind variable to prevent error