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.HR_PERSON_RECORD dependencies on HR_LOCATIONS_ALL_TL

Line 274: , (SELECT DESCRIPTION FROM HR_LOCATIONS_ALL_TL HLAT WHERE HLAT.LOCATION_ID = PAAF.LOCATION_ID

270: , (SELECT PAYROLL_NAME FROM PAY_PAYROLLS_F PPF WHERE PPF.PAYROLL_ID = PAAF.PAYROLL_ID
271: and p_eff_date between ppf.effective_start_date and
272: nvl(ppf.effective_end_date,to_date('31/12/4712','DD/MM/YYYY'))) PAYROLL_DESC
273: , LOCATION_ID
274: , (SELECT DESCRIPTION FROM HR_LOCATIONS_ALL_TL HLAT WHERE HLAT.LOCATION_ID = PAAF.LOCATION_ID
275: AND LANGUAGE = USERENV('LANG')) LOCATION_DESC
276: , PERSON_REFERRED_BY_ID
277: , SUPERVISOR_ID
278: , (SELECT EMPLOYEE_NUMBER FROM PER_ALL_PEOPLE_F PAPF WHERE PAPF.PERSON_ID = PAAF.SUPERVISOR_ID

Line 1430: (SELECT DESCRIPTION FROM HR_LOCATIONS_ALL_TL HLAT WHERE HLAT.LOCATION_ID = PAPF.LOCATION_ID

1426: employee_number ,
1427: ppf.npw_number,
1428: ppf.applicant_number,
1429: papf.location_id,
1430: (SELECT DESCRIPTION FROM HR_LOCATIONS_ALL_TL HLAT WHERE HLAT.LOCATION_ID = PAPF.LOCATION_ID
1431: AND LANGUAGE = USERENV('LANG')) REPORTEE_LOCATION_DESC,
1432: papf.assignment_status_type_id,
1433: (SELECT USER_STATUS FROM PER_ASSIGNMENT_STATUS_TYPES_TL
1434: WHERE ASSIGNMENT_STATUS_TYPE_ID = papf.assignment_status_type_id