APPS.FV_1219_TRANSACTIONS dependencies on CE_BANK_ACCT_USES_ALL

Line 2865: ce_bank_acct_uses_all cbau

2861: SELECT cba.agency_location_code
2862: INTO l_temp_alc_code
2863: FROM ce_bank_accounts cba,
2864: ar_cash_receipts_all acr,
2865: ce_bank_acct_uses_all cbau
2866: WHERE acr.cash_receipt_id = l_cash_receipt_id --l_reference_2
2867: AND acr.remit_bank_acct_use_id = cbau.bank_acct_use_id
2868: AND cba.bank_account_id = cbau.bank_account_id
2869: AND cbau.org_id = p_def_org_id

Line 2921: ce_bank_acct_uses_all cbau

2917: INTO l_temp_alc_code
2918: FROM Fv_Treasury_Confirmations_all ftc,
2919: Ap_Inv_Selection_Criteria_all aisc,
2920: ce_bank_accounts cba,
2921: ce_bank_acct_uses_all cbau
2922: WHERE ftc.treasury_confirmation_id = to_number(l_reference_1)
2923: AND aisc.checkrun_name = ftc.checkrun_name
2924: AND cba.bank_account_id = aisc.bank_account_id
2925: AND cba.bank_account_id = cbau.bank_account_id

Line 2945: ce_bank_acct_uses_all cbau

2941: SELECT cba.agency_location_code
2942: INTO l_temp_alc_code
2943: FROM ap_checks apa,
2944: ce_bank_accounts cba,
2945: ce_bank_acct_uses_all cbau
2946: WHERE TO_CHAR(apa.check_id) = l_reference_3
2947: AND apa.bank_account_id = cba.bank_account_id
2948: AND apa.ce_bank_acct_use_id = cbau.bank_acct_use_id
2949: AND apa.bank_Account_id = cbau.bank_account_id

Line 3108: ce_bank_acct_uses_all cbau

3104: INTO l_temp_alc_code
3105: FROM ap_invoice_payments_all aip,
3106: ap_checks_all aca,
3107: ce_bank_accounts cba,
3108: ce_bank_acct_uses_all cbau
3109: WHERE TO_CHAR(aip.invoice_id) = l_reference_2
3110: AND aca.check_id = l_reference_3
3111: AND aip.set_of_books_id = p_set_bks_id
3112: AND aip.check_id = aca.check_id