Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAYBV_AU_PAYSLIP_ARCHIVE_V |
SELECT PAI.ACTION_INFORMATION_ID
, PAI.ACTION_CONTEXT_ID
, PPA.BUSINESS_GROUP_ID
, PPA.PAYROLL_ACTION_ID
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, PPA.EFFECTIVE_DATE
, PPA.DATE_EARNED
, PAI.ACTION_INFORMATION_CATEGORY
, PAI.ACTION_INFORMATION1
, PAI.ACTION_INFORMATION2
, PAI.ACTION_INFORMATION3
, PAI.ACTION_INFORMATION4
, PAI.ACTION_INFORMATION5
, PAI.ACTION_INFORMATION6
, PAI.ACTION_INFORMATION7
, PAI.ACTION_INFORMATION8
, PAI.ACTION_INFORMATION9
, PAI.ACTION_INFORMATION10
, PAI.ACTION_INFORMATION11
, PAI.ACTION_INFORMATION12
, PAI.ACTION_INFORMATION13
, PAI.ACTION_INFORMATION14
, PAI.ACTION_INFORMATION15
, PAI.ACTION_INFORMATION16
, PAI.ACTION_INFORMATION17
, PAI.ACTION_INFORMATION18
, PAI.ACTION_INFORMATION19
, PAI.ACTION_INFORMATION20
, PAI.ACTION_INFORMATION21
, PAI.ACTION_INFORMATION22
, PAI.ACTION_INFORMATION23
, PAI.ACTION_INFORMATION24
, PAI.ACTION_INFORMATION25
, PAI.ACTION_INFORMATION26
, PAI.ACTION_INFORMATION27
, PAI.ACTION_INFORMATION28
, PAI.ACTION_INFORMATION29
, PAI.ACTION_INFORMATION30
, CASE WHEN (PPA.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PPA.BUSINESS_GROUP_ID)) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
, PAY_ACTION_INFORMATION PAI
WHERE PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
AND PAA.ACTION_STATUS = 'C'
AND PPA.ACTION_TYPE = 'X'
AND PAI.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI.ACTION_CONTEXT_ID = PAA.ASSIGNMENT_ACTION_ID
AND PPA.REPORT_TYPE = 'AU_PAYSLIP_ARCHIVE'
AND PPA.REPORT_CATEGORY = 'ARCHIVE' WITH READ ONLY