VIEW: APPS.PAY_EMP_UK_STAT_INFO_V1

Source

View Text - Preformatted

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')))

View Text - HTML Formatted

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')))