APPS.AR_RECEIPT_LIB_PVT dependencies on CE_BANK_ACCT_USES

Line 56: bau_end_date ce_bank_acct_uses.end_date%TYPE,

52: currency_code ar_cash_receipts.currency_code%TYPE,
53: called_from VARCHAR2(200),
54: state ar_receipt_classes.creation_status%TYPE,
55: creation_method_code ar_receipt_classes.creation_method_code%TYPE,
56: bau_end_date ce_bank_acct_uses.end_date%TYPE,
57: rm_start_date ar_receipt_methods.start_date%TYPE,
58: rm_end_date ar_receipt_methods.end_date%TYPE,
59: rma_start_date ar_receipt_method_accounts.start_date%TYPE,
60: rma_end_date ar_receipt_method_accounts.end_date%TYPE

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 1238: ce_bank_acct_uses ba,

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
1242: and (p_receipt_date

Line 4052: ce_bank_acct_uses ba

4048: p_receipt_method_id
4049: FROM ar_cash_receipts cr,
4050: ar_cash_receipt_history crh,
4051: ar_payment_schedules ps,
4052: ce_bank_acct_uses ba
4053: WHERE cr.remit_bank_acct_use_id = ba.bank_acct_use_id and
4054: cr.cash_receipt_id = crh.cash_receipt_id and
4055: crh.first_posted_record_flag = 'Y' and /* bug 3333680 */
4056: cr.cash_receipt_id = p_cash_receipt_id and

Line 4087: ce_bank_acct_uses ba

4083: p_receipt_method_id
4084: FROM ar_cash_receipts cr,
4085: ar_cash_receipt_history crh,
4086: ar_payment_schedules ps,
4087: ce_bank_acct_uses ba
4088: WHERE cr.remit_bank_acct_use_id = ba.bank_acct_use_id and
4089: cr.cash_receipt_id = crh.cash_receipt_id and
4090: crh.first_posted_record_flag = 'N' and
4091: cr.cash_receipt_id = p_cash_receipt_id and