View: PAY_JP_SS_BANK_LOV_V

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

View Text

SELECT BANK_CODE
, BANK_NAME
, BANK_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_BANKS
WHERE ENABLED_FLAG = 'Y' ORDER BY BANK_CODE

Columns