APPS.PAY_US_LOC_CHANGE dependencies on HR_LOCATIONS

Line 114: FROM hr_locations

110:
111: CURSOR csr_location_code
112: IS
113: SELECT location_code
114: FROM hr_locations
115: WHERE location_id = p_location_id;
116:
117: l_proc_name varchar2(50) := 'get_insert_value';
118:

Line 239: l_location_code hr_locations.location_code%type;

235: l_ret_code number;
236: l_ret_text varchar2(1000);
237: l_assignment_id per_assignments_f.assignment_id%type;
238: l_gre_name hr_tax_units_v.name%type;
239: l_location_code hr_locations.location_code%type;
240: l_full_name per_people_f.full_name%type;
241: l_assignment_number per_assignments_f.assignment_number%type;
242: l_location_id number;
243: l_error varchar2(1000);