VIEW: APPS.PAY_EMP_3RDPARTY_ACTION_INFO_V

Source

View Text - Preformatted

SELECT PAI.ACTION_CONTEXT_ID ACTION_CONTEXT_ID, PAI.ACTION_INFORMATION1 ORG_PAYMENT_METHOD_ID, PAI.ACTION_INFORMATION2 PERSONAL_PAYMENT_METHOD_ID, PAI.ACTION_INFORMATION18 ORG_PAYMENT_METHOD_NAME, PAY_US_EMPLOYEE_PAYSLIP_WEB.GET_CHECK_NUMBER(PAI.ACTION_INFORMATION17, PAI.ACTION_INFORMATION15) CHECK_DEPOSIT_NUMBER, PAI.ACTION_INFORMATION5 SEGMENT1, PAI.ACTION_INFORMATION6 SEGMENT2, PAI.ACTION_INFORMATION7 SEGMENT3, PAI.ACTION_INFORMATION8 SEGMENT4, PAI.ACTION_INFORMATION9 SEGMENT5, PAI.ACTION_INFORMATION10 SEGMENT6, PAI.ACTION_INFORMATION11 SEGMENT7, PAI.ACTION_INFORMATION12 SEGMENT8, PAI.ACTION_INFORMATION13 SEGMENT9, PAI.ACTION_INFORMATION14 SEGMENT10, SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION16)) VALUE FROM PAY_ACTION_INFORMATION PAI ,PER_ASSIGNMENTS_F PAF WHERE PAI.ACTION_INFORMATION_CATEGORY = 'EMPLOYEE THIRD PARTY PAYMENTS' AND PAI.ACTION_CONTEXT_TYPE = 'AAP' AND PAF.ASSIGNMENT_ID = PAI.ASSIGNMENT_ID AND PAI.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE AND PAF.EFFECTIVE_END_DATE GROUP BY PAF.BUSINESS_GROUP_ID, PAI.ACTION_CONTEXT_ID, PAI.ACTION_INFORMATION1, PAI.ACTION_INFORMATION2, PAI.ACTION_INFORMATION15, PAI.ACTION_INFORMATION17, 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_INFORMATION18

View Text - HTML Formatted

SELECT PAI.ACTION_CONTEXT_ID ACTION_CONTEXT_ID
, PAI.ACTION_INFORMATION1 ORG_PAYMENT_METHOD_ID
, PAI.ACTION_INFORMATION2 PERSONAL_PAYMENT_METHOD_ID
, PAI.ACTION_INFORMATION18 ORG_PAYMENT_METHOD_NAME
, PAY_US_EMPLOYEE_PAYSLIP_WEB.GET_CHECK_NUMBER(PAI.ACTION_INFORMATION17
, PAI.ACTION_INFORMATION15) CHECK_DEPOSIT_NUMBER
, PAI.ACTION_INFORMATION5 SEGMENT1
, PAI.ACTION_INFORMATION6 SEGMENT2
, PAI.ACTION_INFORMATION7 SEGMENT3
, PAI.ACTION_INFORMATION8 SEGMENT4
, PAI.ACTION_INFORMATION9 SEGMENT5
, PAI.ACTION_INFORMATION10 SEGMENT6
, PAI.ACTION_INFORMATION11 SEGMENT7
, PAI.ACTION_INFORMATION12 SEGMENT8
, PAI.ACTION_INFORMATION13 SEGMENT9
, PAI.ACTION_INFORMATION14 SEGMENT10
, SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION16)) VALUE
FROM PAY_ACTION_INFORMATION PAI
, PER_ASSIGNMENTS_F PAF
WHERE PAI.ACTION_INFORMATION_CATEGORY = 'EMPLOYEE THIRD PARTY PAYMENTS'
AND PAI.ACTION_CONTEXT_TYPE = 'AAP'
AND PAF.ASSIGNMENT_ID = PAI.ASSIGNMENT_ID
AND PAI.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE GROUP BY PAF.BUSINESS_GROUP_ID
, PAI.ACTION_CONTEXT_ID
, PAI.ACTION_INFORMATION1
, PAI.ACTION_INFORMATION2
, PAI.ACTION_INFORMATION15
, PAI.ACTION_INFORMATION17
, 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_INFORMATION18