[Home] [Help]
222: to_char(ORIGINAL_DATE_OF_HIRE,'YYYY-MM-DD'),
223: TOWN_OF_BIRTH,
224: REGION_OF_BIRTH,
225: COUNTRY_OF_BIRTH,
226: (SELECT TERRITORY_SHORT_NAME FROM FND_TERRITORIES_VL
227: WHERE TERRITORY_CODE = COUNTRY_OF_BIRTH)
228: COUNTRY_OF_BIRTH_DESC,
229: GLOBAL_PERSON_ID,
230: COORD_BEN_MED_PL_NAME,
446: from fnd_descr_flex_contexts_vl
447: where descriptive_flexfield_name ='Address Structure'
448: AND descriptive_flex_context_code = STYLE) STYLE_DESC,
449: COUNTRY,
450: (SELECT TERRITORY_SHORT_NAME FROM FND_TERRITORIES_VL WHERE TERRITORY_CODE = COUNTRY) COUNTRY_DESC,
451: ADDRESS_LINE_1,
452: ADDRESS_LINE_2,
453: ADDRESS_LINE_3,
454: TOWN_OR_CITY,
564: AND p_eff_date between nvl(start_date_active,p_eff_date)
565: and nvl(end_date_active,p_eff_Date)
566: and enabled_flag = 'Y') ADDRESS_TYPE_DESC
567: , COUNTRY
568: , (SELECT TERRITORY_SHORT_NAME FROM FND_TERRITORIES_VL WHERE TERRITORY_CODE = COUNTRY) COUNTRY_DESC
569: , to_char(DATE_TO,'YYYY-MM-DD')
570: , POSTAL_CODE
571: , REGION_1
572: , 'REGION_1' REGION_1_DESC
636: AND p_eff_date between nvl(start_date_active,p_eff_date)
637: and nvl(end_date_active,p_eff_Date)
638: and enabled_flag = 'Y') ADDRESS_TYPE_DESC
639: , COUNTRY
640: , (SELECT TERRITORY_SHORT_NAME FROM FND_TERRITORIES_VL WHERE TERRITORY_CODE = COUNTRY) COUNTRY_DESC
641: , to_char(DATE_TO,'YYYY-MM-DD')
642: , POSTAL_CODE
643: , REGION_1
644: , 'REGION_1' REGION_1_DESC
823: , PERIOD_YEARS
824: , PERIOD_DAYS
825: , EMPLOYER_NAME
826: , EMPLOYER_COUNTRY
827: , (SELECT TERRITORY_SHORT_NAME FROM FND_TERRITORIES_VL WHERE TERRITORY_CODE = EMPLOYER_COUNTRY) EMPLOYER_COUNTRY_DESC
828: , EMPLOYER_ADDRESS
829: , EMPLOYER_TYPE
830: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'PREV_EMP_TYPE' AND LOOKUP_CODE = EMPLOYER_TYPE
831: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)