Product: | PAY - Payroll |
---|---|
Description: | This view is used for Japanese Tax Entry form.This view is used for Japanese localization only. |
Implementation/DBA Data: | APPS.PAY_JP_EMP_V |
SELECT PA.ROWID
, PA.ASSIGNMENT_ID
, PA.ASSIGNMENT_TYPE
, PA.PAYROLL_ID
, PP.PERSON_ID
, PPT.SYSTEM_PERSON_TYPE
, PP.CURRENT_APPLICANT_FLAG
, PP.CURRENT_EMPLOYEE_FLAG
, PP.CURRENT_EMP_OR_APL_FLAG
, PA.BUSINESS_GROUP_ID
, PP.EMPLOYEE_NUMBER
, PP.APPLICANT_NUMBER
, PP.FULL_NAME
, PP.GLOBAL_NAME
, PP.LOCAL_NAME
, PA.ASSIGNMENT_NUMBER
, PP.DATE_OF_BIRTH
, TRUNC(MONTHS_BETWEEN(FND.EFFECTIVE_DATE
, PP.DATE_OF_BIRTH)/12)
, PA.PRIMARY_FLAG
FROM PER_PERSON_TYPES PPT
, PER_ALL_PEOPLE_F PP
, PER_ASSIGNMENTS_F2 PA
, FND_SESSIONS FND
WHERE FND.SESSION_ID=USERENV('SESSIONID')
AND FND.EFFECTIVE_DATE BETWEEN PA.EFFECTIVE_START_DATE
AND PA.EFFECTIVE_END_DATE
AND PA.ASSIGNMENT_TYPE='E'
AND PP.PERSON_ID=PA.PERSON_ID
AND FND.EFFECTIVE_DATE BETWEEN PP.EFFECTIVE_START_DATE
AND PP.EFFECTIVE_END_DATE
AND PPT.PERSON_TYPE_ID=PP.PERSON_TYPE_ID