eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_VALIDATE_BANKINFO dependencies on CE_BANK_ACCOUNTS

Line 928: from ce_bank_accounts ba

924:
925: -- unique combination -> bank_branch_id, bank account name --confirmed sql
926:
927: select count(*) into temp_name
928: from ce_bank_accounts ba
929: where ba.bank_account_name = Xi_ACCOUNT_NAME
930: and ba.bank_branch_id = Xi_BRANCH_ID
931: and ba.bank_account_id <> nvl(Xi_ACCOUNT_ID,-1);
932:

Line 935: from ce_bank_accounts ba

931: and ba.bank_account_id <> nvl(Xi_ACCOUNT_ID,-1);
932:
933: /*IF (Xi_ACCOUNT_ID is not null) then
934: select count(*) into temp_name
935: from ce_bank_accounts ba
936: where ba.bank_account_name = Xi_ACCOUNT_NAME
937: and ba.bank_branch_id = Xi_BRANCH_ID
938: and ba.bank_account_id <> Xi_ACCOUNT_ID;
939: ELSE

Line 941: from ce_bank_accounts ba

937: and ba.bank_branch_id = Xi_BRANCH_ID
938: and ba.bank_account_id <> Xi_ACCOUNT_ID;
939: ELSE
940: select count(*) into temp_name
941: from ce_bank_accounts ba
942: where ba.bank_account_name = Xi_ACCOUNT_NAME
943: and ba.bank_branch_id = Xi_BRANCH_ID;
944:
945: END IF;*/

Line 2345: -- Format Electronic Bank Account Num (CE_BANK_ACCOUNTS.BANK_ACCOUNT_NUM_ELECTRONIC)

2341: cep_standard.debug(' UNIQUE_VALIDATION CHECK for account end ');
2342: END IF;
2343:
2344: -- ER 3973203
2345: -- Format Electronic Bank Account Num (CE_BANK_ACCOUNTS.BANK_ACCOUNT_NUM_ELECTRONIC)
2346:
2347: IF X_VALUE_OUT IS NOT NULL THEN
2348: NEW_ACCOUNT_NUM := X_VALUE_OUT;
2349: ELSE

Line 2756: -- Format Electronic Bank Account Num (CE_BANK_ACCOUNTS.BANK_ACCOUNT_NUM_ELECTRONIC)

2752:
2753:
2754:
2755: -- ER 3973203
2756: -- Format Electronic Bank Account Num (CE_BANK_ACCOUNTS.BANK_ACCOUNT_NUM_ELECTRONIC)
2757:
2758: IF X_VALUE_OUT IS NOT NULL THEN
2759: NEW_ACCOUNT_NUM := X_VALUE_OUT;
2760: ELSE

Line 7277: from ce_bank_accounts ba

7273: -- due to upgrade changes, the unique combination was changed to:
7274: -- bank_branch_id, bank account number, currency code, and account name
7275:
7276: select count(*) into temp_number
7277: from ce_bank_accounts ba
7278: where ba.bank_account_num = Xi_ACCOUNT_NUMBER
7279: and ba.bank_account_name = Xi_ACCOUNT_NAME
7280: and ba.bank_branch_id = Xi_BRANCH_ID
7281: and ba.currency_code = Xi_CURRENCY_CODE

Line 7286: from ce_bank_accounts ba

7282: and ba.bank_account_id <> nvl(Xi_ACCOUNT_ID,-1);
7283:
7284: /*IF (Xi_ACCOUNT_ID is not null) then
7285: select count(*) into temp_number
7286: from ce_bank_accounts ba
7287: where ba.bank_account_num = Xi_ACCOUNT_NUMBER
7288: and ba.bank_branch_id = Xi_BRANCH_ID
7289: and ba.currency_code = Xi_CURRENCY_CODE
7290: and ba.bank_account_id <> Xi_ACCOUNT_ID;

Line 7293: from ce_bank_accounts ba

7289: and ba.currency_code = Xi_CURRENCY_CODE
7290: and ba.bank_account_id <> Xi_ACCOUNT_ID;
7291: ELSE
7292: select count(*) into temp_number
7293: from ce_bank_accounts ba
7294: where ba.bank_account_num = Xi_ACCOUNT_NUMBER
7295: and ba.bank_branch_id = Xi_BRANCH_ID
7296: and ba.currency_code = Xi_CURRENCY_CODE;
7297:

Line 7342: from ce_bank_accounts ba

7338:
7339: -- unique combination -> bank_branch_id, bank account number, currency code, account type --confirmed sql
7340:
7341: select count(*) into temp_number
7342: from ce_bank_accounts ba
7343: where ba.bank_account_num = Xi_ACCOUNT_NUMBER
7344: and ba.bank_account_name = Xi_ACCOUNT_NAME
7345: and ba.bank_account_type = Xi_ACCOUNT_TYPE
7346: and ba.currency_code = Xi_CURRENCY_CODE

Line 7352: from ce_bank_accounts ba

7348: and ba.bank_account_id <> nvl(Xi_ACCOUNT_ID,-1);
7349:
7350: /*IF (Xi_ACCOUNT_ID is not null) then
7351: select count(*) into temp_number
7352: from ce_bank_accounts ba
7353: where ba.bank_account_num = Xi_ACCOUNT_NUMBER
7354: and ba.bank_account_type = Xi_ACCOUNT_TYPE
7355: and ba.currency_code = Xi_CURRENCY_CODE
7356: and ba.bank_branch_id = Xi_BRANCH_ID

Line 7360: from ce_bank_accounts ba

7356: and ba.bank_branch_id = Xi_BRANCH_ID
7357: and ba.bank_account_id <> Xi_ACCOUNT_ID;
7358: ELSE
7359: select count(*) into temp_number
7360: from ce_bank_accounts ba
7361: where ba.bank_account_num = Xi_ACCOUNT_NUMBER
7362: and ba.bank_account_type = Xi_ACCOUNT_TYPE
7363: and ba.currency_code = Xi_CURRENCY_CODE
7364: and ba.bank_branch_id = Xi_BRANCH_ID;

Line 7410: from ce_bank_accounts ba

7406:
7407: -- unique combination -> bank_branch_id, bank account number, currency code, account suffix --confirmed sql
7408:
7409: select count(*) into temp_number
7410: from ce_bank_accounts ba
7411: where ba.bank_account_num = Xi_ACCOUNT_NUMBER
7412: and ba.bank_account_name = Xi_ACCOUNT_NAME
7413: and ba.account_suffix = Xi_ACCOUNT_SUFFIX
7414: and ba.currency_code = Xi_CURRENCY_CODE