APPS.HR_PERSON_RECORD dependencies on HR_LOCATIONS_ALL

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 470: FROM HR_LOCATIONS_ALL

466: LOC_INFORMATION17,
467: LOC_INFORMATION18,
468: LOC_INFORMATION19,
469: LOC_INFORMATION20
470: FROM HR_LOCATIONS_ALL
471: WHERE LOCATION_ID = P_LOCATION_ID;
472:
473:
474: -- cursor to fetch the contact information

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

Line 1987: from hr_locations_all

1983:
1984: cursor csr_state_det(p_location_id number) is
1985: select region_2,location_code,
1986: (select state_name from pay_us_states where state_abbrev = region_2)
1987: from hr_locations_all
1988: where location_id = p_location_id;
1989:
1990: p_location_name varchar2(100);
1991: