DBA Data[Home] [Help]

APPS.CE_VALIDATE_BANKINFO_UPG dependencies on DUAL

Line 5321: from dual;

5317: select
5318: decode(substr(Xi_ACCOUNT_NUMBER ,1,1), '1','Y','2','Y','3','Y','4','N',
5319: '5','N','6','Y','7','N','8','Y','9','Y','ERR')
5320: into BRANCH_NUMBER
5321: from dual;
5322:
5323: if BRANCH_NUMBER='Y' then
5324: ACCOUNT_VALUE:= substr(Xi_ACCOUNT_NUMBER ,1,6)||
5325: lpad(substr(Xi_ACCOUNT_NUMBER ,8),8,'0');