eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_FETCH_POSITION_HISTORY dependencies on HR_LOOKUPS

Line 61: p_status_desc IN out NOCOPY hr_lookups.meaning%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,
65: p_rel_name IN out NOCOPY per_positions.name%type,

Line 62: p_frequency_desc IN out NOCOPY hr_lookups.meaning%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,
65: p_rel_name IN out NOCOPY per_positions.name%type,
66: p_succ_name IN out NOCOPY per_positions.name%type,

Line 63: p_prob_units_desc IN out NOCOPY hr_lookups.meaning%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,
65: p_rel_name IN out NOCOPY per_positions.name%type,
66: p_succ_name IN out NOCOPY per_positions.name%type,
67: p_result_code IN out NOCOPY varchar2

Line 64: p_rep_req_desc IN out NOCOPY hr_lookups.meaning%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,
65: p_rel_name IN out NOCOPY per_positions.name%type,
66: p_succ_name IN out NOCOPY per_positions.name%type,
67: p_result_code IN out NOCOPY varchar2
68: )

Line 92: FROM hr_lookups hrl

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
92: FROM hr_lookups hrl
93: WHERE hrl.lookup_code = p_lookup_code
94: AND hrl.lookup_type = p_lookup_type;
95:
96: BEGIN