[Home] [Help]
189: LEAVING_REASON PER_PERIODS_OF_SERVICE.LEAVING_REASON%TYPE,
190: TOWN_OF_BIRTH PER_ALL_PEOPLE_F.TOWN_OF_BIRTH%TYPE,
191: REGION_OF_BIRTH PER_ALL_PEOPLE_F.REGION_OF_BIRTH%TYPE,
192: COUNTRY_OF_BIRTH PER_ALL_PEOPLE_F.COUNTRY_OF_BIRTH%TYPE,
193: COUNTRY_OF_BIRTH_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
194: GLOBAL_PERSON_ID PER_ALL_PEOPLE_F.GLOBAL_PERSON_ID%TYPE,
195: COORD_BEN_MED_PL_NAME PER_ALL_PEOPLE_F.COORD_BEN_MED_PL_NAME%TYPE,
196: COORD_BEN_MED_INSR_CRR_NAME PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_NAME%TYPE,
197: COORD_BEN_MED_INSR_CRR_IDENT PER_ALL_PEOPLE_F.COORD_BEN_MED_INSR_CRR_IDENT%TYPE,
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
353: , TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE
454: ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%TYPE,
455: ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%TYPE,
456: ADDRESS_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, --(BASED ON LANG /'ADDRESS_TYPE')
457: COUNTRY PER_ADDRESSES.COUNTRY%TYPE,
458: COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
459: DATE_TO varchar2(10),
460: POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%TYPE,
461: REGION_1 PER_ADDRESSES.REGION_1%TYPE,
462: REGION_1_DESC VARCHAR2(240),
519: ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%TYPE,
520: ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%TYPE,
521: ADDRESS_TYPE_DESC FND_LOOKUP_VALUES.MEANING%TYPE, --(BASED ON LANG /'ADDRESS_TYPE')
522: COUNTRY PER_ADDRESSES.COUNTRY%TYPE,
523: COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
524: DATE_TO varchar2(10),
525: POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%TYPE,
526: REGION_1 PER_ADDRESSES.REGION_1%TYPE,
527: REGION_1_DESC VARCHAR2(240),
832: PERIOD_YEARS PER_PREVIOUS_EMPLOYERS.PERIOD_YEARS%TYPE,
833: PERIOD_DAYS PER_PREVIOUS_EMPLOYERS.PERIOD_DAYS%TYPE,
834: EMPLOYER_NAME PER_PREVIOUS_EMPLOYERS.EMPLOYER_NAME%TYPE,
835: EMPLOYER_COUNTRY PER_PREVIOUS_EMPLOYERS.EMPLOYER_COUNTRY%TYPE,
836: EMPLOYER_COUNTRY_DESC FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE,
837: EMPLOYER_ADDRESS PER_PREVIOUS_EMPLOYERS.EMPLOYER_ADDRESS%TYPE,
838: EMPLOYER_TYPE PER_PREVIOUS_EMPLOYERS.EMPLOYER_TYPE%TYPE,
839: EMPLOYER_TYPE_DESC HR_LEG_LOOKUPS.MEANING%TYPE,
840: EMPLOYER_SUBTYPE PER_PREVIOUS_EMPLOYERS.EMPLOYER_SUBTYPE%TYPE,