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 |
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