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_RIF_PKG dependencies on HR_LOOKUPS

Line 169: ,p_lookup_type IN hr_lookups.lookup_type%TYPE

165: end;
166:
167: procedure get_lookup_meaning_desc (
168: p_application_id IN number
169: ,p_lookup_type IN hr_lookups.lookup_type%TYPE
170: ,p_lookup_code IN hr_lookups.lookup_code%TYPE
171: ,p_lookup_meaning OUT NOCOPY hr_lookups.meaning%TYPE
172: ,p_lookup_desc OUT NOCOPY hr_lookups.description%TYPE
173: ) IS

Line 170: ,p_lookup_code IN hr_lookups.lookup_code%TYPE

166:
167: procedure get_lookup_meaning_desc (
168: p_application_id IN number
169: ,p_lookup_type IN hr_lookups.lookup_type%TYPE
170: ,p_lookup_code IN hr_lookups.lookup_code%TYPE
171: ,p_lookup_meaning OUT NOCOPY hr_lookups.meaning%TYPE
172: ,p_lookup_desc OUT NOCOPY hr_lookups.description%TYPE
173: ) IS
174: CURSOR cur_loc IS

Line 171: ,p_lookup_meaning OUT NOCOPY hr_lookups.meaning%TYPE

167: procedure get_lookup_meaning_desc (
168: p_application_id IN number
169: ,p_lookup_type IN hr_lookups.lookup_type%TYPE
170: ,p_lookup_code IN hr_lookups.lookup_code%TYPE
171: ,p_lookup_meaning OUT NOCOPY hr_lookups.meaning%TYPE
172: ,p_lookup_desc OUT NOCOPY hr_lookups.description%TYPE
173: ) IS
174: CURSOR cur_loc IS
175: --bug 760715 even though application id is passed in no longer need to use when

Line 172: ,p_lookup_desc OUT NOCOPY hr_lookups.description%TYPE

168: p_application_id IN number
169: ,p_lookup_type IN hr_lookups.lookup_type%TYPE
170: ,p_lookup_code IN hr_lookups.lookup_code%TYPE
171: ,p_lookup_meaning OUT NOCOPY hr_lookups.meaning%TYPE
172: ,p_lookup_desc OUT NOCOPY hr_lookups.description%TYPE
173: ) IS
174: CURSOR cur_loc IS
175: --bug 760715 even though application id is passed in no longer need to use when
176: -- using hr_lookups view

Line 176: -- using hr_lookups view

172: ,p_lookup_desc OUT NOCOPY hr_lookups.description%TYPE
173: ) IS
174: CURSOR cur_loc IS
175: --bug 760715 even though application id is passed in no longer need to use when
176: -- using hr_lookups view
177: SELECT loc.meaning,
178: loc.description
179: FROM hr_lookups loc
180: WHERE loc.lookup_type = p_lookup_type

Line 179: FROM hr_lookups loc

175: --bug 760715 even though application id is passed in no longer need to use when
176: -- using hr_lookups view
177: SELECT loc.meaning,
178: loc.description
179: FROM hr_lookups loc
180: WHERE loc.lookup_type = p_lookup_type
181: AND loc.lookup_code = p_lookup_code;
182:
183: BEGIN