[Home] [Help]
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
Name |
BANK_CODE |
BANK_NAME |
BANK_NAME_KANA |
START_DATE_ACTIVE |
END_DATE_ACTIVE |