View: PAY_CN_ARCH_PAYMENT_METHODS_V

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

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
, POP.ORG_PAYMENT_METHOD_NAME ORG_PAYMENT_METHOD_NAME
, PPTO.CATEGORY ORG_PAYMENT_CATEGORY
, PEA.SEGMENT1 ORG_BANK_NAME
, PEA.SEGMENT2 ORG_BANK_BRANCH
, PEA.SEGMENT3 ORG_BANK_ACCOUNT_NUMBER
, PAI.ACTION_INFORMATION2 PERSONAL_PAYMENT_METHOD_ID
, PAI.ACTION_INFORMATION18 PERSONAL_PAYMENT_METHOD_NAME
, PPTP.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_PERSONAL_PAYMENT_METHODS_F PPP
, PAY_ORG_PAYMENT_METHODS_F POPP
, PAY_PAYMENT_TYPES PPTP
, PAY_ORG_PAYMENT_METHODS_F POP
, PAY_PAYMENT_TYPES PPTO
, PAY_EXTERNAL_ACCOUNTS PEA
WHERE PAI.ACTION_INFORMATION_CATEGORY = 'EMPLOYEE NET PAY DISTRIBUTION'
AND PAI.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI.ACTION_INFORMATION2 = PPP.PERSONAL_PAYMENT_METHOD_ID
AND PAI.EFFECTIVE_DATE BETWEEN PPP.EFFECTIVE_START_DATE
AND PPP.EFFECTIVE_END_DATE
AND PPP.ORG_PAYMENT_METHOD_ID = POPP.ORG_PAYMENT_METHOD_ID
AND PAI.EFFECTIVE_DATE BETWEEN POPP.EFFECTIVE_START_DATE
AND POPP.EFFECTIVE_END_DATE
AND POPP.PAYMENT_TYPE_ID = PPTP.PAYMENT_TYPE_ID
AND PAI.ACTION_INFORMATION1 = POP.ORG_PAYMENT_METHOD_ID
AND PAI.EFFECTIVE_DATE BETWEEN POP.EFFECTIVE_START_DATE
AND POP.EFFECTIVE_END_DATE
AND POP.PAYMENT_TYPE_ID = PPTO.PAYMENT_TYPE_ID
AND POP.EXTERNAL_ACCOUNT_ID = PEA.EXTERNAL_ACCOUNT_ID UNION ALL 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