APPS.CE_BANK_AND_ACCOUNT_VALIDATION dependencies on CE_BANK_ACCT_USES_ALL

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'

Line 1404: | in CE_BANK_ACCT_USES_ALL should be unique. |

1400: | PUBLIC PROCEDURE validate_unique_org_access |
1401: | |
1402: | DESCRIPTION |
1403: | The combination or bank_account_id and org_id/legal_entity_id in |
1404: | in CE_BANK_ACCT_USES_ALL should be unique. |
1405: | |
1406: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1407: | |
1408: | ARGUMENTS |

Line 1427: FROM ce_bank_acct_uses_all

1423: ) IS
1424: l_dummy VARCHAR2(1);
1425: CURSOR c_acct_access IS
1426: SELECT 'X'
1427: FROM ce_bank_acct_uses_all
1428: WHERE bank_account_id = p_bank_account_id
1429: AND NVL(org_id, legal_entity_id) = p_org_le_id
1430: AND bank_acct_use_id <> NVL(p_acct_use_id, -1);
1431:

Line 1539: from ce_bank_acct_uses_all

1535: IF (P_PAYMENT_DOC_CATEGORY_CODE = '-1') THEN
1536: IF ( P_BANK_ACCT_USE_ID is not null) THEN
1537: select nvl(PAYMENT_DOC_CATEGORY, '-1')
1538: into P_PAYMENT_DOC_CATEGORY_CODE
1539: from ce_bank_acct_uses_all
1540: where BANK_ACCT_USE_ID = P_BANK_ACCT_USE_ID;
1541: cep_standard.debug('ce_bank_acct_uses_all P_PAYMENT_DOC_CATEGORY_CODE='||P_PAYMENT_DOC_CATEGORY_CODE );
1542: END IF;
1543: END IF;

Line 1541: cep_standard.debug('ce_bank_acct_uses_all P_PAYMENT_DOC_CATEGORY_CODE='||P_PAYMENT_DOC_CATEGORY_CODE );

1537: select nvl(PAYMENT_DOC_CATEGORY, '-1')
1538: into P_PAYMENT_DOC_CATEGORY_CODE
1539: from ce_bank_acct_uses_all
1540: where BANK_ACCT_USE_ID = P_BANK_ACCT_USE_ID;
1541: cep_standard.debug('ce_bank_acct_uses_all P_PAYMENT_DOC_CATEGORY_CODE='||P_PAYMENT_DOC_CATEGORY_CODE );
1542: END IF;
1543: END IF;
1544:
1545: cep_standard.debug('P_PAYMENT_DOC_CATEGORY_CODE='||P_PAYMENT_DOC_CATEGORY_CODE );