VIEW: APPS.PAY_IN_ARCH_PF_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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