[Home] [Help]
182: ORIGINAL_DATE_OF_HIRE varchar2(10),
183: TOWN_OF_BIRTH PER_ALL_PEOPLE_F.TOWN_OF_BIRTH%TYPE,
184: REGION_OF_BIRTH PER_ALL_PEOPLE_F.REGION_OF_BIRTH%TYPE,
185: COUNTRY_OF_BIRTH PER_ALL_PEOPLE_F.COUNTRY_OF_BIRTH%TYPE,
186: COUNTRY_OF_BIRTH_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
187: GLOBAL_PERSON_ID PER_ALL_PEOPLE_F.GLOBAL_PERSON_ID%TYPE,
188: COORD_BEN_MED_PL_NAME PER_ALL_PEOPLE_F.COORD_BEN_MED_PL_NAME%TYPE,
189: COORD_BEN_MED_INSR_CRR_NAME PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_NAME%TYPE,
190: COORD_BEN_MED_INSR_CRR_IDENT PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_IDENT%TYPE,
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
346: , TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE
447: ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%TYPE,
448: ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%TYPE,
449: ADDRESS_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, --(BASED ON LANG /'ADDRESS_TYPE')
450: COUNTRY PER_ADDRESSES.COUNTRY%TYPE,
451: COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
452: DATE_TO varchar2(10),
453: POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%TYPE,
454: REGION_1 PER_ADDRESSES.REGION_1%TYPE,
455: REGION_1_DESC VARCHAR2(240),
512: ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%TYPE,
513: ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%TYPE,
514: ADDRESS_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, --(BASED ON LANG /'ADDRESS_TYPE')
515: COUNTRY PER_ADDRESSES.COUNTRY%TYPE,
516: COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
517: DATE_TO varchar2(10),
518: POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%TYPE,
519: REGION_1 PER_ADDRESSES.REGION_1%TYPE,
520: REGION_1_DESC VARCHAR2(240),
823: PERIOD_YEARS PER_PREVIOUS_EMPLOYERS.PERIOD_YEARS%TYPE,
824: PERIOD_DAYS PER_PREVIOUS_EMPLOYERS.PERIOD_DAYS%TYPE,
825: EMPLOYER_NAME PER_PREVIOUS_EMPLOYERS.EMPLOYER_NAME%TYPE,
826: EMPLOYER_COUNTRY PER_PREVIOUS_EMPLOYERS.EMPLOYER_COUNTRY%TYPE,
827: EMPLOYER_COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
828: EMPLOYER_ADDRESS PER_PREVIOUS_EMPLOYERS.EMPLOYER_ADDRESS%TYPE,
829: EMPLOYER_TYPE PER_PREVIOUS_EMPLOYERS.EMPLOYER_TYPE%TYPE,
830: EMPLOYER_TYPE_DESC HR_LEG_LOOKUPS.MEANING%TYPE,
831: EMPLOYER_SUBTYPE PER_PREVIOUS_EMPLOYERS.EMPLOYER_SUBTYPE%TYPE,