APPS.CE_VALIDATE_BANKINFO dependencies on IBY_EXT_BANK_ACCOUNTS

Line 44: FROM iby_ext_bank_accounts

40: AND bank_branch_id = Xi_BRANCH_ID;
41: cep_standard.debug( 'Number of active internal bankaccounts = '||l_count_int);
42: SELECT COUNT(*)
43: INTO l_count_ext
44: FROM iby_ext_bank_accounts
45: WHERE NVL(end_date,Xi_BRANCH_END_DATE+1) > Xi_BRANCH_END_DATE
46: AND branch_id = Xi_BRANCH_ID;
47: cep_standard.debug( 'Number of active external bankaccounts = '||l_count_ext);
48: IF (l_count_int > 0 OR l_count_ext > 0) THEN