View: PAY_EMP_UK_STAT_INFO_V1

Product:	PAY - Payroll
Description:	View based on PER_PEOPLE_F used in the PAYGBTAX form to display data as reference information.
Implementation/DBA Data:	APPS.PAY_EMP_UK_STAT_INFO_V1

View Text

SELECT PP.PERSON_ID
, ASG.ASSIGNMENT_ID
, PP.DATE_OF_BIRTH
, PP.NATIONAL_IDENTIFIER NI_NUMBER
, PP.PER_INFORMATION2 DIRECTOR_FLAG
, PP.PER_INFORMATION6 P11D_STATUS
, AEI.AEI_INFORMATION1 P45_ISSUED
, AEI.AEI_INFORMATION2 P45_MARKED_FOR_REISSUE
, PP.PER_INFORMATION9 NI_MULTIPLE_ASSIGNMENTS
, PP.PER_INFORMATION4 PENSION_FLAG
, PP.PER_INFORMATION10 AGG_ASSIGNMENT_FLAG
FROM PER_ASSIGNMENT_EXTRA_INFO AEI
, PER_ALL_PEOPLE_F PP
, PER_ALL_ASSIGNMENTS_F ASG
WHERE AEI.INFORMATION_TYPE(+) = 'GB_P45'
AND PP.PERSON_ID = ASG.PERSON_ID
AND ASG.ASSIGNMENT_ID = AEI.ASSIGNMENT_ID (+)
AND PP.BUSINESS_GROUP_ID + 0 = ASG.BUSINESS_GROUP_ID + 0
AND (PP.EFFECTIVE_START_DATE <= (SELECT FS.EFFECTIVE_DATE
FROM FND_SESSIONS FS
WHERE FS.SESSION_ID = USERENV('SESSIONID'))
AND PP.EFFECTIVE_END_DATE >= (SELECT FS.EFFECTIVE_DATE
FROM FND_SESSIONS FS
WHERE FS.SESSION_ID = USERENV('SESSIONID')))
AND (ASG.EFFECTIVE_START_DATE <= (SELECT FS.EFFECTIVE_DATE
FROM FND_SESSIONS FS
WHERE FS.SESSION_ID = USERENV('SESSIONID'))
AND ASG.EFFECTIVE_END_DATE >= (SELECT FS.EFFECTIVE_DATE
FROM FND_SESSIONS FS
WHERE FS.SESSION_ID = USERENV('SESSIONID')))

Columns