[Home] [Help]
447:
448: statement := 'REI ACCOUNT';
449: SELECT code_combination_id
450: INTO p_REI_ccid
451: FROM jl_zz_gl_axi
452: WHERE set_of_books_id = p_set_of_books_id;
453:
454: statement := 'DELETE';
455: DELETE FROM jl_zz_gl_axi_tmp
451: FROM jl_zz_gl_axi
452: WHERE set_of_books_id = p_set_of_books_id;
453:
454: statement := 'DELETE';
455: DELETE FROM jl_zz_gl_axi_tmp
456: WHERE axi_run_id = p_axi_run_id;
457:
458: statement := 'SOURCE';
459: SELECT user_je_source_name
716: || ', gb.period_year'
717: || ', gb.period_num'
718: || ' FROM gl_code_combinations gcc'
719: || ' , gl_balances gb'
720: || ' , jl_zz_gl_axi_accounts jagaa'
721: || ' WHERE gcc.code_combination_id = gb.code_combination_id'
722: || ' AND gb.ledger_id = ' || p_set_of_books_id
723: || ' AND gb.currency_code = ''' || set_of_books_currency_code||''''
724: || ' AND gb.actual_flag = ''A'''
741: || ', gb.period_year'
742: || ', gb.period_num'
743: || ' FROM gl_code_combinations gcc'
744: || ' , gl_balances gb'
745: || ' , jl_zz_gl_axi_accounts jagaa'
746: || ' WHERE gcc.code_combination_id = gb.code_combination_id'
747: || ' AND gb.ledger_id = :1'
748: --|| ' AND gb.currency_code = ''' || ':2' ||'''' --Bug 3183432
749: || ' AND gb.currency_code = :2'
1154:
1155: END get_FV_adjustment;
1156:
1157: ------------------------------------------------------------
1158: -- Inserts into JL_ZZ_GL_AXI_TMP data that the infl. adj. --
1159: -- report will read later. --
1160: -- --
1161: ------------------------------------------------------------
1162: FUNCTION insert_axi_tmp (p_code_combination_id IN NUMBER
1170: , p_fv_flag IN VARCHAR2)
1171: RETURN BOOLEAN IS
1172:
1173: BEGIN
1174: INSERT INTO jl_zz_gl_axi_tmp (code_combination_id
1175: , axi_run_id
1176: , group_id
1177: , period_from
1178: , period_to