[Home] [Help]
462:
463: statement := 'REI ACCOUNT';
464: SELECT code_combination_id
465: INTO p_REI_ccid
466: FROM jl_zz_gl_axi
467: WHERE set_of_books_id = p_set_of_books_id;
468:
469: statement := 'DELETE';
470: DELETE FROM jl_zz_gl_axi_tmp
466: FROM jl_zz_gl_axi
467: WHERE set_of_books_id = p_set_of_books_id;
468:
469: statement := 'DELETE';
470: DELETE FROM jl_zz_gl_axi_tmp
471: WHERE axi_run_id = p_axi_run_id;
472:
473: statement := 'SOURCE';
474: SELECT user_je_source_name
731: || ', gb.period_year'
732: || ', gb.period_num'
733: || ' FROM gl_code_combinations gcc'
734: || ' , gl_balances gb'
735: || ' , jl_zz_gl_axi_accounts jagaa'
736: || ' WHERE gcc.code_combination_id = gb.code_combination_id'
737: || ' AND gb.ledger_id = ' || p_set_of_books_id
738: || ' AND gb.currency_code = ''' || set_of_books_currency_code||''''
739: || ' AND gb.actual_flag = ''A'''
756: || ', gb.period_year'
757: || ', gb.period_num'
758: || ' FROM gl_code_combinations gcc'
759: || ' , gl_balances gb'
760: || ' , jl_zz_gl_axi_accounts jagaa'
761: || ' WHERE gcc.code_combination_id = gb.code_combination_id'
762: || ' AND gb.ledger_id = :1'
763: --|| ' AND gb.currency_code = ''' || ':2' ||'''' --Bug 3183432
764: || ' AND gb.currency_code = :2'
1169:
1170: END get_FV_adjustment;
1171:
1172: ------------------------------------------------------------
1173: -- Inserts into JL_ZZ_GL_AXI_TMP data that the infl. adj. --
1174: -- report will read later. --
1175: -- --
1176: ------------------------------------------------------------
1177: FUNCTION insert_axi_tmp (p_code_combination_id IN NUMBER
1185: , p_fv_flag IN VARCHAR2)
1186: RETURN BOOLEAN IS
1187:
1188: BEGIN
1189: INSERT INTO jl_zz_gl_axi_tmp (code_combination_id
1190: , axi_run_id
1191: , group_id
1192: , period_from
1193: , period_to