View: PAY_JP_SS_BANK_BRANCH_LOV_V

Product:	PAY - Payroll
Description:	This view is only used for the Japanese localisation.
Implementation/DBA Data:	APPS.PAY_JP_SS_BANK_BRANCH_LOV_V

View Text

SELECT BANK_CODE
, BRANCH_CODE
, BRANCH_NAME
, BRANCH_NAME_KANA
, NVL(START_DATE_ACTIVE
, TO_DATE('01010001'
, 'DDMMYYYY')) START_DATE_ACTIVE
, NVL(END_DATE_ACTIVE
, TO_DATE('31124712'
, 'DDMMYYYY')) END_DATE_ACTIVE
FROM PAY_JP_BANK_BRANCHES
WHERE ENABLED_FLAG = 'Y' ORDER BY BANK_CODE
, BRANCH_CODE

Columns