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

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

Line 4281: ce_bank_acct_uses ba

4277: p_receipt_method_id
4278: FROM ar_cash_receipts cr,
4279: ar_cash_receipt_history crh,
4280: ar_payment_schedules ps,
4281: ce_bank_acct_uses ba
4282: WHERE cr.remit_bank_acct_use_id = ba.bank_acct_use_id and
4283: cr.cash_receipt_id = crh.cash_receipt_id and
4284: crh.first_posted_record_flag = 'Y' and /* bug 3333680 */
4285: cr.cash_receipt_id = p_cash_receipt_id and

Line 4316: ce_bank_acct_uses ba

4312: p_receipt_method_id
4313: FROM ar_cash_receipts cr,
4314: ar_cash_receipt_history crh,
4315: ar_payment_schedules ps,
4316: ce_bank_acct_uses ba
4317: WHERE cr.remit_bank_acct_use_id = ba.bank_acct_use_id and
4318: cr.cash_receipt_id = crh.cash_receipt_id and
4319: crh.first_posted_record_flag = 'N' and
4320: cr.cash_receipt_id = p_cash_receipt_id and