APPS.CE_BANK_AND_ACCOUNT_VALIDATION dependencies on CE_BANK_ACCOUNTS

Line 499: FROM ce_bank_accounts

495: l_dummy VARCHAR2(1);
496: /*
497: CURSOR c_rowid IS
498: SELECT rowid
499: FROM ce_bank_accounts
500: WHERE bank_account_name = p_account_name
501: AND bank_branch_id = p_branch_id;
502: */
503: CURSOR c_acct_name IS

Line 505: FROM ce_bank_accounts

501: AND bank_branch_id = p_branch_id;
502: */
503: CURSOR c_acct_name IS
504: SELECT 'X'
505: FROM ce_bank_accounts
506: WHERE bank_branch_id = p_branch_id
507: AND bank_account_name = p_account_name
508: AND bank_account_id <> NVL(p_account_id, -1);
509: --AND (rowid <> l_rowid OR l_rowid IS NULL);

Line 1268: from ce_bank_accounts

1264: END IF;
1265:
1266: IF (p_bank_account_id is not null) then
1267: select currency_code into p_cur
1268: from ce_bank_accounts
1269: where bank_account_id = p_bank_account_id;
1270: IF (P_CUR IS not NULL) THEN
1271: --IF (p_bank_acct_use_id is null) then
1272: -- FND_MESSAGE.set_name('CE','CE_BANK_ACCT_USE_ID_REQUIRED');

Line 1278: from ce_bank_accounts ba, ce_bank_acct_uses_all bau

1274: --ELSE
1275:
1276: IF (p_ap_def_settlement = 'Y') THEN
1277: select count(*) into p_ap_def
1278: from ce_bank_accounts ba, ce_bank_acct_uses_all bau
1279: where ba.bank_account_id = bau.bank_account_id
1280: and ba.currency_code = p_cur
1281: and nvl(bau.org_id, bau.LEGAL_ENTITY_ID) = p_org_id
1282: and nvl(bau.AP_DEFAULT_SETTLEMENT_FLAG,'N') = 'Y'

Line 1287: from ce_bank_accounts ba, ce_bank_acct_uses_all bau

1283: and bau.bank_acct_use_id <> nvl(p_bank_acct_use_id, bau.bank_acct_use_id);
1284: END IF;
1285: IF (p_xtr_def_settlement = 'Y') THEN
1286: select count(*) into p_xtr_def
1287: from ce_bank_accounts ba, ce_bank_acct_uses_all bau
1288: where ba.bank_account_id = bau.bank_account_id
1289: and ba.currency_code = p_cur
1290: and nvl(bau.org_id, bau.LEGAL_ENTITY_ID) = p_org_id
1291: and nvl(bau.XTR_DEFAULT_SETTLEMENT_FLAG,'N') = 'Y'