APPS.CE_VALIDATE_BANKINFO dependencies on DUAL

Line 1866: from dual;

1862: lpad(substr(X_ACCOUNT_NUMBER,9),7,'0'),
1863: substr(X_ACCOUNT_NUMBER,1,6)||lpad(substr(X_ACCOUNT_NUMBER,8),8,'0')
1864: ),14,' ')
1865: into account_value
1866: from dual;
1867:
1868: X_ELECTRONIC_ACCT_NUM := account_value;
1869:
1870: IF l_DEBUG in ('Y', 'C') THEN

Line 1899: from dual;

1895: lpad(X_ACCOUNT_NUMBER, 10, '0')
1896: )
1897: ,35,' ')
1898: into account_value
1899: from dual;
1900:
1901: X_ELECTRONIC_ACCT_NUM := account_value;
1902:
1903: IF l_DEBUG in ('Y', 'C') THEN

Line 5582: FROM DUAL;

5578: '2','Y', '3','Y', '4','N',
5579: '5','N', '6','Y', '7','N',
5580: '8','Y', '9','Y', 'ERR')
5581: INTO BRANCH_NUMBER
5582: FROM DUAL;
5583:
5584: IF BRANCH_NUMBER = 'Y'
5585: THEN
5586: ACCOUNT_VALUE := substr(Xi_ACCOUNT_NUMBER ,1,6)||