APPS.GHR_FETCH_POSITION_HISTORY dependencies on HR_LOCATIONS

Line 60: p_location_code IN out NOCOPY hr_locations.location_code%type,

56: p_created_by IN out NOCOPY per_positions.created_by%type,
57: p_creation_date IN out NOCOPY per_positions.creation_date%type,
58: p_org_name IN out NOCOPY hr_all_organization_units.name%type,
59: p_job_name IN out NOCOPY per_jobs.name%type,
60: p_location_code IN out NOCOPY hr_locations.location_code%type,
61: p_status_desc IN out NOCOPY hr_lookups.meaning%type,
62: p_frequency_desc IN out NOCOPY hr_lookups.meaning%type,
63: p_prob_units_desc IN out NOCOPY hr_lookups.meaning%type,
64: p_rep_req_desc IN out NOCOPY hr_lookups.meaning%type,

Line 87: FROM hr_locations loc

83: WHERE job.job_id = p_job_id;
84:
85: CURSOR c_loc_code (p_loc_id IN NUMBER) IS
86: SELECT loc.location_code
87: FROM hr_locations loc
88: WHERE loc.location_id = p_loc_id;
89:
90: CURSOR c_lookup_meaning (p_lookup_type VARCHAR2, p_lookup_code VARCHAR2) IS
91: SELECT hrl.meaning