[Home] [Help]
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
Name |
PERSON_ID |
ASSIGNMENT_ID |
DATE_OF_BIRTH |
NI_NUMBER |
DIRECTOR_FLAG |
P11D_STATUS |
P45_ISSUED |
P45_MARKED_FOR_REISSUE |
NI_MULTIPLE_ASSIGNMENTS |
PENSION_FLAG |
AGG_ASSIGNMENT_FLAG |