[Home] [Help]
229: NULL AS LEAVING_REASON,
230: TOWN_OF_BIRTH,
231: REGION_OF_BIRTH,
232: COUNTRY_OF_BIRTH,
233: (SELECT TERRITORY_SHORT_NAME FROM FND_TERRITORIES_VL
234: WHERE TERRITORY_CODE = COUNTRY_OF_BIRTH)
235: COUNTRY_OF_BIRTH_DESC,
236: GLOBAL_PERSON_ID,
237: COORD_BEN_MED_PL_NAME,
465: from fnd_descr_flex_contexts_vl
466: where descriptive_flexfield_name ='Address Structure'
467: AND descriptive_flex_context_code = STYLE) STYLE_DESC,
468: COUNTRY,
469: (SELECT TERRITORY_SHORT_NAME FROM FND_TERRITORIES_VL WHERE TERRITORY_CODE = COUNTRY) COUNTRY_DESC,
470: ADDRESS_LINE_1,
471: ADDRESS_LINE_2,
472: ADDRESS_LINE_3,
473: TOWN_OR_CITY,
583: AND p_eff_date between nvl(start_date_active,p_eff_date)
584: and nvl(end_date_active,p_eff_Date)
585: and enabled_flag = 'Y') ADDRESS_TYPE_DESC
586: , COUNTRY
587: , (SELECT TERRITORY_SHORT_NAME FROM FND_TERRITORIES_VL WHERE TERRITORY_CODE = COUNTRY) COUNTRY_DESC
588: , to_char(DATE_TO,'YYYY-MM-DD')
589: , POSTAL_CODE
590: , REGION_1
591: , 'REGION_1' REGION_1_DESC
655: AND p_eff_date between nvl(start_date_active,p_eff_date)
656: and nvl(end_date_active,p_eff_Date)
657: and enabled_flag = 'Y') ADDRESS_TYPE_DESC
658: , COUNTRY
659: , (SELECT TERRITORY_SHORT_NAME FROM FND_TERRITORIES_VL WHERE TERRITORY_CODE = COUNTRY) COUNTRY_DESC
660: , to_char(DATE_TO,'YYYY-MM-DD')
661: , POSTAL_CODE
662: , REGION_1
663: , 'REGION_1' REGION_1_DESC
842: , PERIOD_YEARS
843: , PERIOD_DAYS
844: , EMPLOYER_NAME
845: , EMPLOYER_COUNTRY
846: , (SELECT TERRITORY_SHORT_NAME FROM FND_TERRITORIES_VL WHERE TERRITORY_CODE = EMPLOYER_COUNTRY) EMPLOYER_COUNTRY_DESC
847: , EMPLOYER_ADDRESS
848: , EMPLOYER_TYPE
849: , (SELECT MEANING FROM HR_LEG_LOOKUPS WHERE LOOKUP_TYPE = 'PREV_EMP_TYPE' AND LOOKUP_CODE = EMPLOYER_TYPE
850: AND P_EFF_DATE BETWEEN NVL(START_DATE_ACTIVE,P_EFF_DATE) AND NVL(END_DATE_ACTIVE,P_EFF_DATE)