APPS.AR_RECEIPT_LIB_PVT dependencies on CE_BANK_ACCOUNTS

Line 574: FROM ce_bank_accounts

570: ELSIF (p_entity = 'REMIT_BANK_ACCOUNT_NUMBER')
571: THEN
572: SELECT bank_account_id
573: INTO l_selected_id
574: FROM ce_bank_accounts
575: WHERE bank_account_num = p_value;
576:
577: ELSIF (p_entity = 'REMIT_BANK_ACCOUNT_NAME')
578: THEN

Line 581: FROM ce_bank_accounts

577: ELSIF (p_entity = 'REMIT_BANK_ACCOUNT_NAME')
578: THEN
579: SELECT bank_account_id
580: INTO l_selected_id
581: FROM ce_bank_accounts
582: WHERE bank_account_name = p_value;
583:
584: ELSIF (p_entity = 'CURRENCY_NAME')
585: THEN

Line 649: FROM ce_bank_accounts ba, ce_bank_acct_uses bau

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

Line 1237: ce_bank_accounts cba,

1233: rm.start_date rm_start_date,
1234: rm.end_date rm_end_date,
1235: ba.end_Date bau_end_date
1236: FROM ar_receipt_methods rm,
1237: ce_bank_accounts cba,
1238: ce_bank_acct_uses ba,
1239: ar_receipt_method_accounts rma ,
1240: ar_receipt_classes rc
1241: WHERE rm.receipt_method_id = p_receipt_method_id

Line 1760: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE,

1756: p_receipt_method_name IN OUT NOCOPY ar_receipt_methods.name%TYPE,
1757: /* 6612301 */
1758: p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE,
1759: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
1760: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE,
1761: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE,
1762: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
1763: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
1764: p_customer_id IN OUT NOCOPY ar_cash_receipts.pay_from_customer%TYPE,

Line 1761: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE,

1757: /* 6612301 */
1758: p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE,
1759: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
1760: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE,
1761: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE,
1762: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
1763: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,
1764: p_customer_id IN OUT NOCOPY ar_cash_receipts.pay_from_customer%TYPE,
1765: p_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,