APPS.CE_BANK_AND_ACCOUNT_VALIDATION dependencies on CE_BANK_ACCT_USES_ALL

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'

Line 1419: | in CE_BANK_ACCT_USES_ALL should be unique. |

1415: | PUBLIC PROCEDURE validate_unique_org_access |
1416: | |
1417: | DESCRIPTION |
1418: | The combination or bank_account_id and org_id/legal_entity_id in |
1419: | in CE_BANK_ACCT_USES_ALL should be unique. |
1420: | |
1421: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1422: | |
1423: | ARGUMENTS |

Line 1442: FROM ce_bank_acct_uses_all

1438: ) IS
1439: l_dummy VARCHAR2(1);
1440: CURSOR c_acct_access IS
1441: SELECT 'X'
1442: FROM ce_bank_acct_uses_all
1443: WHERE bank_account_id = p_bank_account_id
1444: AND NVL(org_id, legal_entity_id) = p_org_le_id
1445: AND bank_acct_use_id <> NVL(p_acct_use_id, -1);
1446:

Line 1554: from ce_bank_acct_uses_all

1550: IF (P_PAYMENT_DOC_CATEGORY_CODE = '-1') THEN
1551: IF ( P_BANK_ACCT_USE_ID is not null) THEN
1552: select nvl(PAYMENT_DOC_CATEGORY, '-1')
1553: into P_PAYMENT_DOC_CATEGORY_CODE
1554: from ce_bank_acct_uses_all
1555: where BANK_ACCT_USE_ID = P_BANK_ACCT_USE_ID;
1556: cep_standard.debug('ce_bank_acct_uses_all P_PAYMENT_DOC_CATEGORY_CODE='||P_PAYMENT_DOC_CATEGORY_CODE );
1557: END IF;
1558: END IF;

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

1552: select nvl(PAYMENT_DOC_CATEGORY, '-1')
1553: into P_PAYMENT_DOC_CATEGORY_CODE
1554: from ce_bank_acct_uses_all
1555: where BANK_ACCT_USE_ID = P_BANK_ACCT_USE_ID;
1556: cep_standard.debug('ce_bank_acct_uses_all P_PAYMENT_DOC_CATEGORY_CODE='||P_PAYMENT_DOC_CATEGORY_CODE );
1557: END IF;
1558: END IF;
1559:
1560: cep_standard.debug('P_PAYMENT_DOC_CATEGORY_CODE='||P_PAYMENT_DOC_CATEGORY_CODE );