View: PAY_ZA_EXTERNAL_ACCOUNTS_V

Product:	PAY - Payroll
Description:	List of payments with their associated bank details.
Implementation/DBA Data:	APPS.PAY_ZA_EXTERNAL_ACCOUNTS_V

View Text

SELECT PAA.ROWID ROW_ID
, PAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, SUBSTR(POPMF.ORG_PAYMENT_METHOD_NAME
, 1
, 30) PAYMENT_METHOD
, CDV.BANK_NAME BANK
, PEA.SEGMENT1 BRANCH_CODE
, PEA.SEGMENT3 ACCOUNT_NO
, PPP.VALUE PAYMENT_AMOUNT
, PPA.DATE_EARNED PAYMENT_DATE
FROM PAY_PRE_PAYMENTS PPP
, PAY_PERSONAL_PAYMENT_METHODS_F PPPMF
, PAY_ORG_PAYMENT_METHODS_F POPMF
, PAY_EXTERNAL_ACCOUNTS PEA
, PAY_ZA_BRANCH_CDV_DETAILS CDV
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
WHERE PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
AND PPA.ACTION_TYPE IN ('P'
, 'U')
AND PPP.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
AND PPPMF.PERSONAL_PAYMENT_METHOD_ID (+) = PPP.PERSONAL_PAYMENT_METHOD_ID
AND PPA.EFFECTIVE_DATE BETWEEN NVL(PPPMF.EFFECTIVE_START_DATE
, TO_DATE('01-01-0001'
, 'DD-MM-YYYY'))
AND NVL(PPPMF.EFFECTIVE_END_DATE
, TO_DATE('31-12-4712'
, 'DD-MM-YYYY'))
AND PPA.EFFECTIVE_DATE BETWEEN POPMF.EFFECTIVE_START_DATE
AND POPMF.EFFECTIVE_END_DATE
AND POPMF.ORG_PAYMENT_METHOD_ID = PPP.ORG_PAYMENT_METHOD_ID
AND PEA.EXTERNAL_ACCOUNT_ID (+) = PPPMF.EXTERNAL_ACCOUNT_ID
AND CDV.BRANCH_CODE (+) = PEA.SEGMENT1

Columns