View: PER_ES_TAX_SS_EMP_V

Product:	PER - Human Resources
Description:	Used in the Social Security and Tax Forms
Implementation/DBA Data:	APPS.PER_ES_TAX_SS_EMP_V

View Text

SELECT FULL_NAME AS FULL_NAME
, FLOOR(MONTHS_BETWEEN(F.EFFECTIVE_DATE
, DATE_OF_BIRTH)/12) AS AGE
, SEX AS SEX
, HR_GENERAL.DECODE_LOOKUP('SEX'
, SEX) AS SEX_MEANING
, NATIONAL_IDENTIFIER AS NATIONAL_IDENTIFIER
, A.ASSIGNMENT_ID AS ASSIGNMENT_ID
, A.ASSIGNMENT_NUMBER AS ASSIGNMENT_NUMBER
, HR_ES_UTILITY.GET_DISABILITY_DEGREE(P.PERSON_ID
, F.EFFECTIVE_DATE) AS DISABILITY_DEGREE
FROM PER_ALL_PEOPLE_F P
, PER_ALL_ASSIGNMENTS_F A
, FND_SESSIONS F
WHERE A.PERSON_ID=P.PERSON_ID
AND F.SESSION_ID = USERENV('SESSIONID')
AND F.EFFECTIVE_DATE BETWEEN P.EFFECTIVE_START_DATE
AND P.EFFECTIVE_END_DATE
AND F.EFFECTIVE_DATE BETWEEN A.EFFECTIVE_START_DATE
AND A.EFFECTIVE_END_DATE

Columns