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

Line 179: FROM hr_lookups

175: IS
176: l_result VARCHAR2(80);
177: CURSOR csr_lookup IS
178: SELECT meaning
179: FROM hr_lookups
180: WHERE lookup_type = p_lookup_type
181: AND lookup_code = p_lookup_code
182: AND enabled_flag = 'Y'
183: AND TRUNC(l_effective_date)

Line 373: FROM hr_lookups LKP

369: l_result := 'No Handicap';
370: END IF;
371: SELECT NVL(LKP.description, l_result)
372: INTO l_result
373: FROM hr_lookups LKP
374: WHERE LKP.lookup_type = 'GHR_US_HANDICAP_CODE'
375: AND LKP.lookup_code = l_rescpy
376: AND LKP.enabled_flag = 'Y'
377: AND TRUNC(l_effective_date)

Line 391: FROM hr_lookups LKP

387: ghr_history_fetch.fetch_positionei(p_ASG.position_id, 'GHR_US_POS_GRP1',
388: l_effective_date, l_posei_data);
389: SELECT NVL(LKP.description, LKP.meaning)
390: INTO l_result
391: FROM hr_lookups LKP
392: WHERE LKP.lookup_type = 'GHR_US_OCC_CATEGORY_CODE'
393: AND LKP.lookup_code = l_posei_data.poei_information6
394: AND LKP.enabled_flag = 'Y'
395: AND TRUNC(l_effective_date)