View: PAY_CN_ARCH_PAYMENT_METHODS_V2

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_CN_ARCH_PAYMENT_METHODS_V2

View Text

SELECT PAI.ACTION_CONTEXT_ID ASSIGNMENT_ACTION_ID
, PAI.ACTION_INFORMATION1 ORG_PAYMETH_ID
, POP.ORG_PAYMENT_METHOD_ID ORG_PAYMENT_METHOD_ID
, PAI.ACTION_INFORMATION18 ORG_PAYMENT_METHOD_NAME
, PPT.CATEGORY ORG_PAYMENT_CATEGORY
, PAI.ACTION_INFORMATION5 ORG_BANK_NAME
, PAI.ACTION_INFORMATION6 ORG_BANK_BRANCH
, PAI.ACTION_INFORMATION7 ORG_BANK_ACCOUNT_NUMBER
, PAI.ACTION_INFORMATION1 PERSONAL_PAYMENT_METHOD_ID
, PAI.ACTION_INFORMATION18 PERSONAL_PAYMENT_METHOD_NAME
, PPT.CATEGORY PERSONAL_PAYMENT_CATEGORY
, PAI.ACTION_INFORMATION5 PERSONAL_BANK_NAME
, PAI.ACTION_INFORMATION6 PERSONAL_BANK_BRANCH
, PAI.ACTION_INFORMATION7 PERSONAL_BANK_ACCOUNT_NUMBER
, PAI.ACTION_INFORMATION13 CURRENCY_CODE
, PAI.ACTION_INFORMATION16 PAYMENT_AMOUNT
FROM PAY_ACTION_INFORMATION PAI
, PAY_ORG_PAYMENT_METHODS_F POP
, PAY_PAYMENT_TYPES PPT
WHERE PAI.ACTION_INFORMATION_CATEGORY = 'EMPLOYEE NET PAY DISTRIBUTION'
AND PAI.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI.ACTION_INFORMATION2 IS NULL
AND PAI.ACTION_INFORMATION1 = POP.ORG_PAYMENT_METHOD_ID
AND POP.PAYMENT_TYPE_ID = PPT.PAYMENT_TYPE_ID
AND PAI.EFFECTIVE_DATE BETWEEN POP.EFFECTIVE_START_DATE
AND POP.EFFECTIVE_END_DATE

Columns