View: PAY_JP_SOE_ASSIGNMENTS_V

Product:	PAY - Payroll
Description:	This view is used for Japanese localization only.
Implementation/DBA Data:	APPS.PAY_JP_SOE_ASSIGNMENTS_V

View Text

SELECT /* THIS VIEW RETURNS SAME RECORDS IF SESSION_DATE IS IN THE SAME YEAR. */ V.ASSIGNMENT_ID
, V.BUSINESS_GROUP_ID
, V.EFFECTIVE_DATE
, PA3.ASSIGNMENT_TYPE
, PA3.ASSIGNMENT_NUMBER
, PA3.PAYROLL_ID
, PA3.PERSON_ID
, PPT.SYSTEM_PERSON_TYPE
, PP.CURRENT_EMPLOYEE_FLAG
, PP.CURRENT_APPLICANT_FLAG
, PP.CURRENT_EMP_OR_APL_FLAG
, PP.EMPLOYEE_NUMBER
, PP.APPLICANT_NUMBER
, PP.DATE_OF_BIRTH
, PP.FULL_NAME
, PP.GLOBAL_NAME
, PP.LOCAL_NAME
, PA3.JOB_ID
, PJT.NAME FROM PER_PERSON_TYPES PPT
, PER_ALL_PEOPLE_F PP
, PER_JOBS_TL PJT
, PER_ALL_ASSIGNMENTS_F PA3
, ( SELECT PA.ASSIGNMENT_ID
, PA.BUSINESS_GROUP_ID
, /* WHEN A ASSIGNMENT EXISTS IN THE YEAR BUT DOES NOT EXIST ON SESSION_DATE
, NEAREST DATE ESD OR EED IS APPLIED TO EFFECTIVE_DATE. */ PAY_JP_SOE_PKG.GET_EFFECTIVE_DATE(FND.EFFECTIVE_DATE
, PA.ASSIGNMENT_ID) EFFECTIVE_DATE FROM PER_ASSIGNMENTS_F2 PA
, FND_SESSIONS FND WHERE FND.SESSION_ID = USERENV('SESSIONID') /* RECORD MUST EXIST WITH PAYROLL_ID IS NOT NULL IN THE SAME YEAR. THE FOLLOWING "EXISTS" STATEMENT IS CALLED ONCE FOR EACH ASSIGNMENT. */ AND EXISTS( SELECT NULL FROM PER_ALL_ASSIGNMENTS_F PA2 WHERE PA2.ASSIGNMENT_ID = PA.ASSIGNMENT_ID AND TO_NUMBER(TO_CHAR(FND.EFFECTIVE_DATE
, 'YYYY')) BETWEEN TO_NUMBER(TO_CHAR(PA2.EFFECTIVE_START_DATE
, 'YYYY'))
AND TO_NUMBER(TO_CHAR(PA2.EFFECTIVE_END_DATE
, 'YYYY')) AND PA2.PAYROLL_ID IS NOT NULL) GROUP BY PA.ASSIGNMENT_ID
, PA.BUSINESS_GROUP_ID
, FND.EFFECTIVE_DATE ) V
WHERE PA3.ASSIGNMENT_ID = V.ASSIGNMENT_ID
AND V.EFFECTIVE_DATE BETWEEN PA3.EFFECTIVE_START_DATE
AND PA3.EFFECTIVE_END_DATE
AND PJT.JOB_ID(+) = PA3.JOB_ID
AND PJT.LANGUAGE (+) = USERENV('LANG')
AND PP.PERSON_ID = PA3.PERSON_ID
AND V.EFFECTIVE_DATE BETWEEN PP.EFFECTIVE_START_DATE
AND PP.EFFECTIVE_END_DATE
AND PPT.PERSON_TYPE_ID = PP.PERSON_TYPE_ID

Columns