APPS.GHR_FETCH_POSITION_HISTORY dependencies on PER_JOBS

Line 59: p_job_name IN OUT per_jobs.name%type,

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

Line 82: FROM per_jobs job

78: WHERE org.organization_id = p_org_id;
79:
80: CURSOR c_job_name (p_job_id IN NUMBER) IS
81: SELECT job.name
82: FROM per_jobs job
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