APPS.HR_PERSON_RECORD dependencies on HR_LOCATIONS_ALL

Line 220: , LOCATION_DESC HR_LOCATIONS_ALL_TL.DESCRIPTION%TYPE --(BASED ON LANG)

216: , PER_SYSTEM_STATUS PER_ASSIGNMENT_STATUS_TYPES.PER_SYSTEM_STATUS%TYPE
217: , PAYROLL_ID PER_ALL_ASSIGNMENTS_F.PAYROLL_ID%TYPE
218: , PAYROLL_DESC PAY_PAYROLLS_F.PAYROLL_NAME%TYPE
219: , LOCATION_ID PER_ALL_ASSIGNMENTS_F.LOCATION_ID%TYPE
220: , LOCATION_DESC HR_LOCATIONS_ALL_TL.DESCRIPTION%TYPE --(BASED ON LANG)
221: , PERSON_REFERRED_BY_ID PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID%TYPE
222: , SUPERVISOR_ID PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID%TYPE
223: , SUPERVISOR_EMP_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE
224: , SUPERVISOR_CWK_NUMBER PER_ALL_PEOPLE_F.NPW_NUMBER%TYPE

Line 338: ( LOCATION_ID HR_LOCATIONS_ALL.LOCATION_ID%TYPE

334:
335: /*Record Type definition for Location Address*/
336:
337: TYPE ASSGN_LOCN_ADDRESS IS RECORD
338: ( LOCATION_ID HR_LOCATIONS_ALL.LOCATION_ID%TYPE
339: , STYLE HR_LOCATIONS_ALL.STYLE%TYPE
340: , STYLE_DESC VARCHAR2(100)
341: , COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
342: , COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE

Line 339: , STYLE HR_LOCATIONS_ALL.STYLE%TYPE

335: /*Record Type definition for Location Address*/
336:
337: TYPE ASSGN_LOCN_ADDRESS IS RECORD
338: ( LOCATION_ID HR_LOCATIONS_ALL.LOCATION_ID%TYPE
339: , STYLE HR_LOCATIONS_ALL.STYLE%TYPE
340: , STYLE_DESC VARCHAR2(100)
341: , COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
342: , COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE
343: , ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE

Line 341: , COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE

337: TYPE ASSGN_LOCN_ADDRESS IS RECORD
338: ( LOCATION_ID HR_LOCATIONS_ALL.LOCATION_ID%TYPE
339: , STYLE HR_LOCATIONS_ALL.STYLE%TYPE
340: , STYLE_DESC VARCHAR2(100)
341: , COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
342: , COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE
343: , ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE
344: , ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE
345: , ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE

Line 343: , ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE

339: , STYLE HR_LOCATIONS_ALL.STYLE%TYPE
340: , STYLE_DESC VARCHAR2(100)
341: , COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
342: , COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE
343: , ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE
344: , ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE
345: , ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE
346: , TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE
347: , REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE

Line 344: , ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE

340: , STYLE_DESC VARCHAR2(100)
341: , COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
342: , COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE
343: , ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE
344: , ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE
345: , ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE
346: , TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE
347: , REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE
348: , REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE

Line 345: , ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE

341: , COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
342: , COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE
343: , ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE
344: , ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE
345: , ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE
346: , TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE
347: , REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE
348: , REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE
349: , REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE

Line 346: , TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE

342: , COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE
343: , ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE
344: , ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE
345: , ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE
346: , TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE
347: , REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE
348: , REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE
349: , REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE
350: , POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE

Line 347: , REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE

343: , ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE
344: , ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE
345: , ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE
346: , TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE
347: , REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE
348: , REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE
349: , REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE
350: , POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE
351: , TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE

Line 348: , REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE

344: , ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE
345: , ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE
346: , TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE
347: , REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE
348: , REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE
349: , REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE
350: , POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE
351: , TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE
352: , TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE

Line 349: , REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE

345: , ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE
346: , TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE
347: , REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE
348: , REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE
349: , REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE
350: , POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE
351: , TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE
352: , TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE
353: , TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE

Line 350: , POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE

346: , TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE
347: , REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE
348: , REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE
349: , REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE
350: , POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE
351: , TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE
352: , TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE
353: , TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE
354: , LOC_INFORMATION13 HR_LOCATIONS_ALL.LOC_INFORMATION13%TYPE

Line 351: , TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE

347: , REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE
348: , REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE
349: , REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE
350: , POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE
351: , TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE
352: , TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE
353: , TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE
354: , LOC_INFORMATION13 HR_LOCATIONS_ALL.LOC_INFORMATION13%TYPE
355: , LOC_INFORMATION14 HR_LOCATIONS_ALL.LOC_INFORMATION14%TYPE

Line 352: , TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE

348: , REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE
349: , REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE
350: , POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE
351: , TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE
352: , TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE
353: , TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE
354: , LOC_INFORMATION13 HR_LOCATIONS_ALL.LOC_INFORMATION13%TYPE
355: , LOC_INFORMATION14 HR_LOCATIONS_ALL.LOC_INFORMATION14%TYPE
356: , LOC_INFORMATION15 HR_LOCATIONS_ALL.LOC_INFORMATION15%TYPE

Line 353: , TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE

349: , REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE
350: , POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE
351: , TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE
352: , TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE
353: , TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE
354: , LOC_INFORMATION13 HR_LOCATIONS_ALL.LOC_INFORMATION13%TYPE
355: , LOC_INFORMATION14 HR_LOCATIONS_ALL.LOC_INFORMATION14%TYPE
356: , LOC_INFORMATION15 HR_LOCATIONS_ALL.LOC_INFORMATION15%TYPE
357: , LOC_INFORMATION16 HR_LOCATIONS_ALL.LOC_INFORMATION16%TYPE

Line 354: , LOC_INFORMATION13 HR_LOCATIONS_ALL.LOC_INFORMATION13%TYPE

350: , POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE
351: , TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE
352: , TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE
353: , TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE
354: , LOC_INFORMATION13 HR_LOCATIONS_ALL.LOC_INFORMATION13%TYPE
355: , LOC_INFORMATION14 HR_LOCATIONS_ALL.LOC_INFORMATION14%TYPE
356: , LOC_INFORMATION15 HR_LOCATIONS_ALL.LOC_INFORMATION15%TYPE
357: , LOC_INFORMATION16 HR_LOCATIONS_ALL.LOC_INFORMATION16%TYPE
358: , LOC_INFORMATION17 HR_LOCATIONS_ALL.LOC_INFORMATION17%TYPE

Line 355: , LOC_INFORMATION14 HR_LOCATIONS_ALL.LOC_INFORMATION14%TYPE

351: , TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE
352: , TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE
353: , TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE
354: , LOC_INFORMATION13 HR_LOCATIONS_ALL.LOC_INFORMATION13%TYPE
355: , LOC_INFORMATION14 HR_LOCATIONS_ALL.LOC_INFORMATION14%TYPE
356: , LOC_INFORMATION15 HR_LOCATIONS_ALL.LOC_INFORMATION15%TYPE
357: , LOC_INFORMATION16 HR_LOCATIONS_ALL.LOC_INFORMATION16%TYPE
358: , LOC_INFORMATION17 HR_LOCATIONS_ALL.LOC_INFORMATION17%TYPE
359: , LOC_INFORMATION18 HR_LOCATIONS_ALL.LOC_INFORMATION18%TYPE

Line 356: , LOC_INFORMATION15 HR_LOCATIONS_ALL.LOC_INFORMATION15%TYPE

352: , TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE
353: , TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE
354: , LOC_INFORMATION13 HR_LOCATIONS_ALL.LOC_INFORMATION13%TYPE
355: , LOC_INFORMATION14 HR_LOCATIONS_ALL.LOC_INFORMATION14%TYPE
356: , LOC_INFORMATION15 HR_LOCATIONS_ALL.LOC_INFORMATION15%TYPE
357: , LOC_INFORMATION16 HR_LOCATIONS_ALL.LOC_INFORMATION16%TYPE
358: , LOC_INFORMATION17 HR_LOCATIONS_ALL.LOC_INFORMATION17%TYPE
359: , LOC_INFORMATION18 HR_LOCATIONS_ALL.LOC_INFORMATION18%TYPE
360: , LOC_INFORMATION19 HR_LOCATIONS_ALL.LOC_INFORMATION19%TYPE

Line 357: , LOC_INFORMATION16 HR_LOCATIONS_ALL.LOC_INFORMATION16%TYPE

353: , TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE
354: , LOC_INFORMATION13 HR_LOCATIONS_ALL.LOC_INFORMATION13%TYPE
355: , LOC_INFORMATION14 HR_LOCATIONS_ALL.LOC_INFORMATION14%TYPE
356: , LOC_INFORMATION15 HR_LOCATIONS_ALL.LOC_INFORMATION15%TYPE
357: , LOC_INFORMATION16 HR_LOCATIONS_ALL.LOC_INFORMATION16%TYPE
358: , LOC_INFORMATION17 HR_LOCATIONS_ALL.LOC_INFORMATION17%TYPE
359: , LOC_INFORMATION18 HR_LOCATIONS_ALL.LOC_INFORMATION18%TYPE
360: , LOC_INFORMATION19 HR_LOCATIONS_ALL.LOC_INFORMATION19%TYPE
361: , LOC_INFORMATION20 HR_LOCATIONS_ALL.LOC_INFORMATION20%TYPE

Line 358: , LOC_INFORMATION17 HR_LOCATIONS_ALL.LOC_INFORMATION17%TYPE

354: , LOC_INFORMATION13 HR_LOCATIONS_ALL.LOC_INFORMATION13%TYPE
355: , LOC_INFORMATION14 HR_LOCATIONS_ALL.LOC_INFORMATION14%TYPE
356: , LOC_INFORMATION15 HR_LOCATIONS_ALL.LOC_INFORMATION15%TYPE
357: , LOC_INFORMATION16 HR_LOCATIONS_ALL.LOC_INFORMATION16%TYPE
358: , LOC_INFORMATION17 HR_LOCATIONS_ALL.LOC_INFORMATION17%TYPE
359: , LOC_INFORMATION18 HR_LOCATIONS_ALL.LOC_INFORMATION18%TYPE
360: , LOC_INFORMATION19 HR_LOCATIONS_ALL.LOC_INFORMATION19%TYPE
361: , LOC_INFORMATION20 HR_LOCATIONS_ALL.LOC_INFORMATION20%TYPE
362: );

Line 359: , LOC_INFORMATION18 HR_LOCATIONS_ALL.LOC_INFORMATION18%TYPE

355: , LOC_INFORMATION14 HR_LOCATIONS_ALL.LOC_INFORMATION14%TYPE
356: , LOC_INFORMATION15 HR_LOCATIONS_ALL.LOC_INFORMATION15%TYPE
357: , LOC_INFORMATION16 HR_LOCATIONS_ALL.LOC_INFORMATION16%TYPE
358: , LOC_INFORMATION17 HR_LOCATIONS_ALL.LOC_INFORMATION17%TYPE
359: , LOC_INFORMATION18 HR_LOCATIONS_ALL.LOC_INFORMATION18%TYPE
360: , LOC_INFORMATION19 HR_LOCATIONS_ALL.LOC_INFORMATION19%TYPE
361: , LOC_INFORMATION20 HR_LOCATIONS_ALL.LOC_INFORMATION20%TYPE
362: );
363:

Line 360: , LOC_INFORMATION19 HR_LOCATIONS_ALL.LOC_INFORMATION19%TYPE

356: , LOC_INFORMATION15 HR_LOCATIONS_ALL.LOC_INFORMATION15%TYPE
357: , LOC_INFORMATION16 HR_LOCATIONS_ALL.LOC_INFORMATION16%TYPE
358: , LOC_INFORMATION17 HR_LOCATIONS_ALL.LOC_INFORMATION17%TYPE
359: , LOC_INFORMATION18 HR_LOCATIONS_ALL.LOC_INFORMATION18%TYPE
360: , LOC_INFORMATION19 HR_LOCATIONS_ALL.LOC_INFORMATION19%TYPE
361: , LOC_INFORMATION20 HR_LOCATIONS_ALL.LOC_INFORMATION20%TYPE
362: );
363:
364: /*Record type for assignment details with location address*/

Line 361: , LOC_INFORMATION20 HR_LOCATIONS_ALL.LOC_INFORMATION20%TYPE

357: , LOC_INFORMATION16 HR_LOCATIONS_ALL.LOC_INFORMATION16%TYPE
358: , LOC_INFORMATION17 HR_LOCATIONS_ALL.LOC_INFORMATION17%TYPE
359: , LOC_INFORMATION18 HR_LOCATIONS_ALL.LOC_INFORMATION18%TYPE
360: , LOC_INFORMATION19 HR_LOCATIONS_ALL.LOC_INFORMATION19%TYPE
361: , LOC_INFORMATION20 HR_LOCATIONS_ALL.LOC_INFORMATION20%TYPE
362: );
363:
364: /*Record type for assignment details with location address*/
365: