APPS.CE_VALIDATE_BANKINFO dependencies on CE_BANK_ACCOUNTS

Line 38: FROM ce_bank_accounts

34: cep_standard.debug('>>CE_VALIDATE_BANKINFO.ce_end_date_check');
35: cep_standard.debug('branch end_date = ' || Xi_BRANCH_END_DATE);
36: SELECT COUNT(*)
37: INTO l_count_int
38: FROM ce_bank_accounts
39: WHERE NVL(end_date,Xi_BRANCH_END_DATE+1) > Xi_BRANCH_END_DATE
40: AND bank_branch_id = Xi_BRANCH_ID;
41: cep_standard.debug( 'Number of active internal bankaccounts = '||l_count_int);
42: SELECT COUNT(*)

Line 825: FROM ce_bank_accounts ba

821: ', Xi_BRANCH_ID ' ||Xi_BRANCH_ID );
822:
823: -- unique combination -> bank_branch_id, bank account name --confirmed sql
824: SELECT COUNT(*) INTO temp_name
825: FROM ce_bank_accounts ba
826: WHERE ba.bank_account_name = Xi_ACCOUNT_NAME
827: AND ba.bank_branch_id = Xi_BRANCH_ID
828: AND ba.bank_account_id <> nvl(Xi_ACCOUNT_ID,-1);
829:

Line 1723: -- (CE_BANK_ACCOUNTS.BANK_ACCOUNT_NUM_ELECTRONIC)

1719: cep_standard.debug(' UNIQUE_VALIDATION CHECK for account end ');
1720:
1721: -- ER 3973203
1722: -- Format Electronic Bank Account Num
1723: -- (CE_BANK_ACCOUNTS.BANK_ACCOUNT_NUM_ELECTRONIC)
1724: IF l_value_out IS NOT NULL THEN
1725: NEW_ACCOUNT_NUM := l_value_out;
1726: ELSE
1727: NEW_ACCOUNT_NUM := X_ACCOUNT_NUMBER;

Line 6360: FROM ce_bank_accounts ba

6356: -- unique combination -> bank_branch_id, bank account number, currency code
6357: -- due to upgrade changes, the unique combination was changed to:
6358: -- bank_branch_id, bank account number, currency code, and account name
6359: SELECT COUNT(*) INTO temp_number
6360: FROM ce_bank_accounts ba
6361: WHERE ba.bank_account_num = Xi_ACCOUNT_NUMBER
6362: AND ba.bank_account_name = Xi_ACCOUNT_NAME
6363: AND ba.bank_branch_id = Xi_BRANCH_ID
6364: AND ba.currency_code = Xi_CURRENCY_CODE

Line 6398: FROM ce_bank_accounts ba

6394:
6395: -- unique combination -> bank_branch_id, bank account number, currency code, account type
6396: -- due to upgrade changes account name was added to the unique combination
6397: SELECT count(*) INTO temp_number
6398: FROM ce_bank_accounts ba
6399: WHERE ba.bank_account_num = Xi_ACCOUNT_NUMBER
6400: AND ba.bank_account_name = Xi_ACCOUNT_NAME
6401: AND ba.bank_account_type = Xi_ACCOUNT_TYPE
6402: AND ba.currency_code = Xi_CURRENCY_CODE

Line 6439: FROM ce_bank_accounts ba

6435:
6436: -- unique combination -> bank_branch_id, bank account number, currency code, account suffix
6437: -- due to upgrade changes account name was added to the unique combination
6438: SELECT COUNT(*) INTO temp_number
6439: FROM ce_bank_accounts ba
6440: WHERE ba.bank_account_num = Xi_ACCOUNT_NUMBER
6441: AND ba.bank_account_name = Xi_ACCOUNT_NAME
6442: AND ba.account_suffix = Xi_ACCOUNT_SUFFIX
6443: AND ba.currency_code = Xi_CURRENCY_CODE

Line 7994: -- (CE_BANK_ACCOUNTS.BANK_ACCOUNT_NUM_ELECTRONIC)

7990: END IF; /* country account check */
7991:
7992: -- ER 3973203
7993: -- Format Electronic Bank Account Num
7994: -- (CE_BANK_ACCOUNTS.BANK_ACCOUNT_NUM_ELECTRONIC)
7995: IF l_value_out IS NOT NULL THEN
7996: NEW_ACCOUNT_NUM := l_value_out;
7997: ELSE
7998: NEW_ACCOUNT_NUM := X_ACCOUNT_NUMBER;