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

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

289: , (SELECT PAYROLL_NAME FROM PAY_PAYROLLS_F PPF WHERE PPF.PAYROLL_ID = PAAF.PAYROLL_ID
290: and p_eff_date between ppf.effective_start_date and
291: nvl(ppf.effective_end_date,to_date('31/12/4712','DD/MM/YYYY'))) PAYROLL_DESC
292: , LOCATION_ID
293: , (SELECT DESCRIPTION FROM HR_LOCATIONS_ALL_TL HLAT WHERE HLAT.LOCATION_ID = PAAF.LOCATION_ID
294: AND LANGUAGE = USERENV('LANG')) LOCATION_DESC
295: , PERSON_REFERRED_BY_ID
296: , SUPERVISOR_ID
297: , (SELECT EMPLOYEE_NUMBER FROM PER_ALL_PEOPLE_F PAPF WHERE PAPF.PERSON_ID = PAAF.SUPERVISOR_ID

Line 489: FROM HR_LOCATIONS_ALL

485: LOC_INFORMATION17,
486: LOC_INFORMATION18,
487: LOC_INFORMATION19,
488: LOC_INFORMATION20
489: FROM HR_LOCATIONS_ALL
490: WHERE LOCATION_ID = P_LOCATION_ID;
491:
492:
493: -- cursor to fetch the contact information

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

1447: employee_number ,
1448: ppf.npw_number,
1449: ppf.applicant_number,
1450: papf.location_id,
1451: (SELECT DESCRIPTION FROM HR_LOCATIONS_ALL_TL HLAT WHERE HLAT.LOCATION_ID = PAPF.LOCATION_ID
1452: AND LANGUAGE = USERENV('LANG')) REPORTEE_LOCATION_DESC,
1453: papf.assignment_status_type_id,
1454: (SELECT USER_STATUS FROM PER_ASSIGNMENT_STATUS_TYPES_TL
1455: WHERE ASSIGNMENT_STATUS_TYPE_ID = papf.assignment_status_type_id