[Home] [Help]
View: PAY_IN_ARCH_PF_V
View Text
SELECT DISTINCT PAI_PA.ACTION_INFORMATION1 CONTRIBUTION_PERIOD
, PAI_PA.ACTION_INFORMATION2 PF_ORG_ID
, PAI_PA.ACTION_INFORMATION7 PF_ORG_CLASS
, PAI_AAP.ACTION_INFORMATION15 PENSION_NUMBER
, PAI_AAP.ACTION_INFORMATION3 PF_NUMBER
, PAI_PA.ACTION_INFORMATION8 ORG_NAME
FROM PAY_ACTION_INFORMATION PAI_PA
, PAY_ACTION_INFORMATION PAI_AAP
, PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
WHERE PAI_PA.ACTION_INFORMATION_CATEGORY = 'IN_PF_PAY'
AND PAI_AAP.ACTION_INFORMATION_CATEGORY = 'IN_PF_ASG'
AND PAI_PA.ACTION_CONTEXT_ID = PPA.PAYROLL_ACTION_ID
AND PAI_AAP.ACTION_CONTEXT_ID = PAA.ASSIGNMENT_ACTION_ID
AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PAI_PA.ACTION_INFORMATION1 = PAI_AAP.ACTION_INFORMATION1
AND PAI_PA.ACTION_INFORMATION2 = PAI_AAP.ACTION_INFORMATION2
AND PAI_PA.ACTION_CONTEXT_TYPE = 'PA'
AND PAI_AAP.ACTION_CONTEXT_TYPE = 'AAP'
AND PPA.BUSINESS_GROUP_ID=FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
Columns
Name |
CONTRIBUTION_PERIOD |
PF_ORG_ID |
PF_ORG_CLASS |
PENSION_NUMBER |
PF_NUMBER |
ORG_NAME |