APPS.HR_PERSON_RECORD dependencies on HR_LOCATIONS_ALL

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

223: , PER_SYSTEM_STATUS PER_ASSIGNMENT_STATUS_TYPES.PER_SYSTEM_STATUS%TYPE
224: , PAYROLL_ID PER_ALL_ASSIGNMENTS_F.PAYROLL_ID%TYPE
225: , PAYROLL_DESC PAY_PAYROLLS_F.PAYROLL_NAME%TYPE
226: , LOCATION_ID PER_ALL_ASSIGNMENTS_F.LOCATION_ID%TYPE
227: , LOCATION_DESC HR_LOCATIONS_ALL_TL.DESCRIPTION%TYPE --(BASED ON LANG)
228: , PERSON_REFERRED_BY_ID PER_ALL_ASSIGNMENTS_F.PERSON_REFERRED_BY_ID%TYPE
229: , SUPERVISOR_ID PER_ALL_ASSIGNMENTS_F.SUPERVISOR_ID%TYPE
230: , SUPERVISOR_EMP_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE
231: , SUPERVISOR_CWK_NUMBER PER_ALL_PEOPLE_F.NPW_NUMBER%TYPE

Line 345: ( LOCATION_ID HR_LOCATIONS_ALL.LOCATION_ID%TYPE

341:
342: /*Record Type definition for Location Address*/
343:
344: TYPE ASSGN_LOCN_ADDRESS IS RECORD
345: ( LOCATION_ID HR_LOCATIONS_ALL.LOCATION_ID%TYPE
346: , STYLE HR_LOCATIONS_ALL.STYLE%TYPE
347: , STYLE_DESC VARCHAR2(100)
348: , COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
349: , COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE

Line 346: , STYLE HR_LOCATIONS_ALL.STYLE%TYPE

342: /*Record Type definition for Location Address*/
343:
344: TYPE ASSGN_LOCN_ADDRESS IS RECORD
345: ( LOCATION_ID HR_LOCATIONS_ALL.LOCATION_ID%TYPE
346: , STYLE HR_LOCATIONS_ALL.STYLE%TYPE
347: , STYLE_DESC VARCHAR2(100)
348: , COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
349: , COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE
350: , ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE

Line 348: , COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE

344: TYPE ASSGN_LOCN_ADDRESS IS RECORD
345: ( LOCATION_ID HR_LOCATIONS_ALL.LOCATION_ID%TYPE
346: , STYLE HR_LOCATIONS_ALL.STYLE%TYPE
347: , STYLE_DESC VARCHAR2(100)
348: , COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
349: , COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE
350: , ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE
351: , ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE
352: , ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE

Line 350: , ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE

346: , STYLE HR_LOCATIONS_ALL.STYLE%TYPE
347: , STYLE_DESC VARCHAR2(100)
348: , COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
349: , COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE
350: , ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE
351: , ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE
352: , ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE
353: , TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE
354: , REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE

Line 351: , ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE

347: , STYLE_DESC VARCHAR2(100)
348: , COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
349: , COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE
350: , ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE
351: , ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE
352: , ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE
353: , TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE
354: , REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE
355: , REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE

Line 352: , ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE

348: , COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
349: , COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE
350: , ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE
351: , ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE
352: , ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE
353: , TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE
354: , REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE
355: , REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE
356: , REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE

Line 353: , TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE

349: , COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE
350: , ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE
351: , ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE
352: , ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE
353: , TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE
354: , REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE
355: , REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE
356: , REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE
357: , POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE

Line 354: , REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE

350: , ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE
351: , ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE
352: , ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE
353: , TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE
354: , REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE
355: , REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE
356: , REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE
357: , POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE
358: , TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE

Line 355: , REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE

351: , ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE
352: , ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE
353: , TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE
354: , REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE
355: , REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE
356: , REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE
357: , POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE
358: , TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE
359: , TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE

Line 356: , REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE

352: , ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE
353: , TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE
354: , REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE
355: , REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE
356: , REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE
357: , POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE
358: , TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE
359: , TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE
360: , TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE

Line 357: , POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE

353: , TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE
354: , REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE
355: , REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE
356: , REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE
357: , POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE
358: , TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE
359: , TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE
360: , TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE
361: , LOC_INFORMATION13 HR_LOCATIONS_ALL.LOC_INFORMATION13%TYPE

Line 358: , TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE

354: , REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE
355: , REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE
356: , REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE
357: , POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE
358: , TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE
359: , TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE
360: , TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE
361: , LOC_INFORMATION13 HR_LOCATIONS_ALL.LOC_INFORMATION13%TYPE
362: , LOC_INFORMATION14 HR_LOCATIONS_ALL.LOC_INFORMATION14%TYPE

Line 359: , TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE

355: , REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE
356: , REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE
357: , POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE
358: , TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE
359: , TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE
360: , TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE
361: , LOC_INFORMATION13 HR_LOCATIONS_ALL.LOC_INFORMATION13%TYPE
362: , LOC_INFORMATION14 HR_LOCATIONS_ALL.LOC_INFORMATION14%TYPE
363: , LOC_INFORMATION15 HR_LOCATIONS_ALL.LOC_INFORMATION15%TYPE

Line 360: , TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE

356: , REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE
357: , POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE
358: , TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE
359: , TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE
360: , TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE
361: , LOC_INFORMATION13 HR_LOCATIONS_ALL.LOC_INFORMATION13%TYPE
362: , LOC_INFORMATION14 HR_LOCATIONS_ALL.LOC_INFORMATION14%TYPE
363: , LOC_INFORMATION15 HR_LOCATIONS_ALL.LOC_INFORMATION15%TYPE
364: , LOC_INFORMATION16 HR_LOCATIONS_ALL.LOC_INFORMATION16%TYPE

Line 361: , LOC_INFORMATION13 HR_LOCATIONS_ALL.LOC_INFORMATION13%TYPE

357: , POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE
358: , TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE
359: , TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE
360: , TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE
361: , LOC_INFORMATION13 HR_LOCATIONS_ALL.LOC_INFORMATION13%TYPE
362: , LOC_INFORMATION14 HR_LOCATIONS_ALL.LOC_INFORMATION14%TYPE
363: , LOC_INFORMATION15 HR_LOCATIONS_ALL.LOC_INFORMATION15%TYPE
364: , LOC_INFORMATION16 HR_LOCATIONS_ALL.LOC_INFORMATION16%TYPE
365: , LOC_INFORMATION17 HR_LOCATIONS_ALL.LOC_INFORMATION17%TYPE

Line 362: , LOC_INFORMATION14 HR_LOCATIONS_ALL.LOC_INFORMATION14%TYPE

358: , TELEPHONE_NUMBER_1 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_1%TYPE
359: , TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE
360: , TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE
361: , LOC_INFORMATION13 HR_LOCATIONS_ALL.LOC_INFORMATION13%TYPE
362: , LOC_INFORMATION14 HR_LOCATIONS_ALL.LOC_INFORMATION14%TYPE
363: , LOC_INFORMATION15 HR_LOCATIONS_ALL.LOC_INFORMATION15%TYPE
364: , LOC_INFORMATION16 HR_LOCATIONS_ALL.LOC_INFORMATION16%TYPE
365: , LOC_INFORMATION17 HR_LOCATIONS_ALL.LOC_INFORMATION17%TYPE
366: , LOC_INFORMATION18 HR_LOCATIONS_ALL.LOC_INFORMATION18%TYPE

Line 363: , LOC_INFORMATION15 HR_LOCATIONS_ALL.LOC_INFORMATION15%TYPE

359: , TELEPHONE_NUMBER_2 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_2%TYPE
360: , TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE
361: , LOC_INFORMATION13 HR_LOCATIONS_ALL.LOC_INFORMATION13%TYPE
362: , LOC_INFORMATION14 HR_LOCATIONS_ALL.LOC_INFORMATION14%TYPE
363: , LOC_INFORMATION15 HR_LOCATIONS_ALL.LOC_INFORMATION15%TYPE
364: , LOC_INFORMATION16 HR_LOCATIONS_ALL.LOC_INFORMATION16%TYPE
365: , LOC_INFORMATION17 HR_LOCATIONS_ALL.LOC_INFORMATION17%TYPE
366: , LOC_INFORMATION18 HR_LOCATIONS_ALL.LOC_INFORMATION18%TYPE
367: , LOC_INFORMATION19 HR_LOCATIONS_ALL.LOC_INFORMATION19%TYPE

Line 364: , LOC_INFORMATION16 HR_LOCATIONS_ALL.LOC_INFORMATION16%TYPE

360: , TELEPHONE_NUMBER_3 HR_LOCATIONS_ALL.TELEPHONE_NUMBER_3%TYPE
361: , LOC_INFORMATION13 HR_LOCATIONS_ALL.LOC_INFORMATION13%TYPE
362: , LOC_INFORMATION14 HR_LOCATIONS_ALL.LOC_INFORMATION14%TYPE
363: , LOC_INFORMATION15 HR_LOCATIONS_ALL.LOC_INFORMATION15%TYPE
364: , LOC_INFORMATION16 HR_LOCATIONS_ALL.LOC_INFORMATION16%TYPE
365: , LOC_INFORMATION17 HR_LOCATIONS_ALL.LOC_INFORMATION17%TYPE
366: , LOC_INFORMATION18 HR_LOCATIONS_ALL.LOC_INFORMATION18%TYPE
367: , LOC_INFORMATION19 HR_LOCATIONS_ALL.LOC_INFORMATION19%TYPE
368: , LOC_INFORMATION20 HR_LOCATIONS_ALL.LOC_INFORMATION20%TYPE

Line 365: , LOC_INFORMATION17 HR_LOCATIONS_ALL.LOC_INFORMATION17%TYPE

361: , LOC_INFORMATION13 HR_LOCATIONS_ALL.LOC_INFORMATION13%TYPE
362: , LOC_INFORMATION14 HR_LOCATIONS_ALL.LOC_INFORMATION14%TYPE
363: , LOC_INFORMATION15 HR_LOCATIONS_ALL.LOC_INFORMATION15%TYPE
364: , LOC_INFORMATION16 HR_LOCATIONS_ALL.LOC_INFORMATION16%TYPE
365: , LOC_INFORMATION17 HR_LOCATIONS_ALL.LOC_INFORMATION17%TYPE
366: , LOC_INFORMATION18 HR_LOCATIONS_ALL.LOC_INFORMATION18%TYPE
367: , LOC_INFORMATION19 HR_LOCATIONS_ALL.LOC_INFORMATION19%TYPE
368: , LOC_INFORMATION20 HR_LOCATIONS_ALL.LOC_INFORMATION20%TYPE
369: );

Line 366: , LOC_INFORMATION18 HR_LOCATIONS_ALL.LOC_INFORMATION18%TYPE

362: , LOC_INFORMATION14 HR_LOCATIONS_ALL.LOC_INFORMATION14%TYPE
363: , LOC_INFORMATION15 HR_LOCATIONS_ALL.LOC_INFORMATION15%TYPE
364: , LOC_INFORMATION16 HR_LOCATIONS_ALL.LOC_INFORMATION16%TYPE
365: , LOC_INFORMATION17 HR_LOCATIONS_ALL.LOC_INFORMATION17%TYPE
366: , LOC_INFORMATION18 HR_LOCATIONS_ALL.LOC_INFORMATION18%TYPE
367: , LOC_INFORMATION19 HR_LOCATIONS_ALL.LOC_INFORMATION19%TYPE
368: , LOC_INFORMATION20 HR_LOCATIONS_ALL.LOC_INFORMATION20%TYPE
369: );
370:

Line 367: , LOC_INFORMATION19 HR_LOCATIONS_ALL.LOC_INFORMATION19%TYPE

363: , LOC_INFORMATION15 HR_LOCATIONS_ALL.LOC_INFORMATION15%TYPE
364: , LOC_INFORMATION16 HR_LOCATIONS_ALL.LOC_INFORMATION16%TYPE
365: , LOC_INFORMATION17 HR_LOCATIONS_ALL.LOC_INFORMATION17%TYPE
366: , LOC_INFORMATION18 HR_LOCATIONS_ALL.LOC_INFORMATION18%TYPE
367: , LOC_INFORMATION19 HR_LOCATIONS_ALL.LOC_INFORMATION19%TYPE
368: , LOC_INFORMATION20 HR_LOCATIONS_ALL.LOC_INFORMATION20%TYPE
369: );
370:
371: /*Record type for assignment details with location address*/

Line 368: , LOC_INFORMATION20 HR_LOCATIONS_ALL.LOC_INFORMATION20%TYPE

364: , LOC_INFORMATION16 HR_LOCATIONS_ALL.LOC_INFORMATION16%TYPE
365: , LOC_INFORMATION17 HR_LOCATIONS_ALL.LOC_INFORMATION17%TYPE
366: , LOC_INFORMATION18 HR_LOCATIONS_ALL.LOC_INFORMATION18%TYPE
367: , LOC_INFORMATION19 HR_LOCATIONS_ALL.LOC_INFORMATION19%TYPE
368: , LOC_INFORMATION20 HR_LOCATIONS_ALL.LOC_INFORMATION20%TYPE
369: );
370:
371: /*Record type for assignment details with location address*/
372: