APPS.FV_1219_TRANSACTIONS dependencies on CE_BANK_ACCOUNTS

Line 12: p_alc_code ce_bank_accounts.agency_location_code%TYPE;

8: gl_seg_name varchar2(40);
9: transaction_count number := 0;
10: p_set_bks_id number;
11: p_gl_period varchar2(25);
12: p_alc_code ce_bank_accounts.agency_location_code%TYPE;
13: p_delete_corrections varchar2(1);
14: p_error_code number;
15: p_error_msg varchar2(150);
16:

Line 2863: FROM ce_bank_accounts cba,

2859: -- Get agency location code
2860: BEGIN
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

Line 2920: ce_bank_accounts cba,

2916: SELECT cba.agency_location_code
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

Line 2944: ce_bank_accounts cba,

2940: BEGIN
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

Line 3107: ce_bank_accounts cba,

3103: SELECT cba.agency_location_code
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

Line 4396: v_alc_code ce_bank_accounts.agency_location_code%TYPE;

4392: PROCEDURE GROUP_REPORT_LINES IS
4393: l_module_name VARCHAR2(200) := g_module_name || 'GROUP_REPORT_LINES';
4394: last_reported_gl_period varchar2(6) ;
4395: v_legal_entity_id number(15) ;
4396: v_alc_code ce_bank_accounts.agency_location_code%TYPE;
4397: BEGIN
4398: -- Before inserting new records, delete any previous records from
4399: -- FV_SF1219_ORG_TEMP table
4400: DELETE FROM FV_SF1219_ORG_TEMP;