View: PAY_ZA_BANK_ADDRESS_V

Product:	PAY - Payroll
Description:	PAY_ZA_BANK_ADDRESS_V is a view based on Bank / Branch details and CDV weighting factors.
Implementation/DBA Data:	APPS.PAY_ZA_BANK_ADDRESS_V

View Text

SELECT BD.BANK_NAME
, BD.BRANCH_CODE
, CP.ACCOUNT_TYPE
, BD.STREAM_CODE
, BD.BRANCH_NAME
, BD.STREET_ADDRESS_LINE_1
, BD.STREET_ADDRESS_LINE_2
, BD.PO_BOX_NUMBER
, BD.PO_BOX_POST_OFFICE
, BD.POSTAL_CODE
, CP.MODULUS
, CP.FUDGE_FACTOR
, CP.CDV_WEIGHTING1
, CP.CDV_WEIGHTING2
, CP.CDV_WEIGHTING3
, CP.CDV_WEIGHTING4
, CP.CDV_WEIGHTING5
, CP.CDV_WEIGHTING6
, CP.CDV_WEIGHTING7
, CP.CDV_WEIGHTING8
, CP.CDV_WEIGHTING9
, CP.CDV_WEIGHTING10
, CP.CDV_WEIGHTING11
, CP.EXCEPTION_CODE
, CP.ACCOUNT_INDICATOR
, BD.TELEPHONE_NUMBER
, BD.DIALING_CODE
, BD.TELEX1
, BD.TELEX2
FROM PAY_ZA_BRANCH_CDV_DETAILS BD
, PAY_ZA_CDV_PARAMETERS CP
WHERE BD.BRANCH_CODE = CP.BRANCH_CODE

Columns