VIEW: APPS.PER_ES_TAX_SS_EMP_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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