APPS.AR_RECEIPT_LIB_PVT dependencies on CE_BANK_ACCOUNTS

Line 575: FROM ce_bank_accounts cba, ce_bank_acct_uses cbau

571: ELSIF (p_entity = 'REMIT_BANK_ACCOUNT_NUMBER')
572: THEN
573: SELECT cbau.bank_acct_use_id
574: INTO l_selected_id
575: FROM ce_bank_accounts cba, ce_bank_acct_uses cbau
576: WHERE bank_account_num = p_value
577: and cba.bank_account_id = cbau.bank_account_id;
578:
579: ELSIF (p_entity = 'REMIT_BANK_ACCOUNT_NAME')

Line 583: FROM ce_bank_accounts cba, ce_bank_acct_uses cbau

579: ELSIF (p_entity = 'REMIT_BANK_ACCOUNT_NAME')
580: THEN
581: SELECT cbau.bank_acct_use_id
582: INTO l_selected_id
583: FROM ce_bank_accounts cba, ce_bank_acct_uses cbau
584: WHERE bank_account_name = p_value
585: and cba.bank_account_id = cbau.bank_account_id;
586:
587: ELSIF (p_entity = 'CURRENCY_NAME')

Line 652: FROM ce_bank_accounts ba, ce_bank_acct_uses bau

648: ELSIF (p_entity = 'LEGAL_ENTITY' ) THEN
649: --
650: SELECT ba.account_owner_org_id
651: INTO l_selected_id
652: FROM ce_bank_accounts ba, ce_bank_acct_uses bau
653: WHERE ba.bank_account_id = bau.bank_account_id
654: AND bau.bank_acct_use_id = p_value;
655: END IF;
656:

Line 1242: ce_bank_accounts cba,

1238: rm.end_date rm_end_date,
1239: ba.end_Date bau_end_date,
1240: rma.org_id rma_org_id
1241: FROM ar_receipt_methods rm,
1242: ce_bank_accounts cba,
1243: ce_bank_acct_uses ba,
1244: ar_receipt_method_accounts rma ,
1245: ar_receipt_classes rc
1246: WHERE rm.receipt_method_id = p_receipt_method_id

Line 1767: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE,

1763: p_receipt_method_name IN OUT NOCOPY ar_receipt_methods.name%TYPE,
1764: /* 6612301 */
1765: p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE,
1766: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
1767: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE,
1768: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE,
1769: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
1770: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
1771: p_customer_id IN OUT NOCOPY ar_cash_receipts.pay_from_customer%TYPE,

Line 1768: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE,

1764: /* 6612301 */
1765: p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE,
1766: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
1767: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE,
1768: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE,
1769: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
1770: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
1771: p_customer_id IN OUT NOCOPY ar_cash_receipts.pay_from_customer%TYPE,
1772: p_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,