APPS.GHR_FETCH_POSITION_HISTORY dependencies on HR_ALL_ORGANIZATION_UNITS

Line 58: p_org_name IN OUT hr_all_organization_units.name%type,

54: p_last_updated_by IN OUT per_positions.last_updated_by%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,

Line 77: FROM hr_all_organization_units org

73: l_result_code varchar2(30);
74:
75: CURSOR c_org_name (p_org_id IN NUMBER) IS
76: SELECT org.name
77: FROM hr_all_organization_units org
78: WHERE org.organization_id = p_org_id;
79:
80: CURSOR c_job_name (p_job_id IN NUMBER) IS
81: SELECT job.name