APPS.CE_BANK_AND_ACCOUNT_VALIDATION dependencies on CE_BANK_ACCOUNTS

Line 355: FROM ce_bank_accounts

351: l_dummy VARCHAR2(1);
352: /*
353: CURSOR c_rowid IS
354: SELECT rowid
355: FROM ce_bank_accounts
356: WHERE bank_account_name = p_account_name
357: AND bank_branch_id = p_branch_id;
358: */
359: CURSOR c_acct_name IS

Line 361: FROM ce_bank_accounts

357: AND bank_branch_id = p_branch_id;
358: */
359: CURSOR c_acct_name IS
360: SELECT 'X'
361: FROM ce_bank_accounts
362: WHERE bank_branch_id = p_branch_id
363: AND bank_account_name = p_account_name
364: AND bank_account_id <> NVL(p_account_id, -1);
365: --AND (rowid <> l_rowid OR l_rowid IS NULL);

Line 1283: from ce_bank_accounts

1279: END IF;
1280:
1281: IF (p_bank_account_id is not null) then
1282: select currency_code into p_cur
1283: from ce_bank_accounts
1284: where bank_account_id = p_bank_account_id;
1285: IF (P_CUR IS not NULL) THEN
1286: --IF (p_bank_acct_use_id is null) then
1287: -- FND_MESSAGE.set_name('CE','CE_BANK_ACCT_USE_ID_REQUIRED');

Line 1293: from ce_bank_accounts ba, ce_bank_acct_uses_all bau

1289: --ELSE
1290:
1291: IF (p_ap_def_settlement = 'Y') THEN
1292: select count(*) into p_ap_def
1293: from ce_bank_accounts ba, ce_bank_acct_uses_all bau
1294: where ba.bank_account_id = bau.bank_account_id
1295: and ba.currency_code = p_cur
1296: and nvl(bau.org_id, bau.LEGAL_ENTITY_ID) = p_org_id
1297: and nvl(bau.AP_DEFAULT_SETTLEMENT_FLAG,'N') = 'Y'

Line 1302: from ce_bank_accounts ba, ce_bank_acct_uses_all bau

1298: and bau.bank_acct_use_id <> nvl(p_bank_acct_use_id, bau.bank_acct_use_id);
1299: END IF;
1300: IF (p_xtr_def_settlement = 'Y') THEN
1301: select count(*) into p_xtr_def
1302: from ce_bank_accounts ba, ce_bank_acct_uses_all bau
1303: where ba.bank_account_id = bau.bank_account_id
1304: and ba.currency_code = p_cur
1305: and nvl(bau.org_id, bau.LEGAL_ENTITY_ID) = p_org_id
1306: and nvl(bau.XTR_DEFAULT_SETTLEMENT_FLAG,'N') = 'Y'