85: l_ja_cn_subsidiary_gbl_tmp_row ja_cn_subsidiary_gt%ROWTYPE;
86: ln_row_count NUMBER := 0;
87:
88: lv_sql_stmt VARCHAR2(30000) := '';
89: lv_sql_stmt4insert_j_line VARCHAR2(30000) := 'INSERT INTO ja_cn_account_balances_gt
90: (account_segment,
91: currency_code,
92: func_begin_balance,
93: orig_begin_balance,
243:
244: CURSOR amount_balance_gt_cur
245: IS
246: SELECT *
247: FROM ja_cn_account_balances_gt
248: ORDER BY start_date,ACCOUNT_SEGMENT;
249:
250: BEGIN
251: --logging for debug
495: ld_current_start_date);
496:
497: END IF;
498:
499: --Insert data to global temp table ja_cn_account_balances_gt
500: OPEN c_in_ja_cn_subsidiary_gbl_tmp;
501: LOOP
502: FETCH c_in_ja_cn_subsidiary_gbl_tmp
503: INTO l_ja_cn_subsidiary_gbl_tmp_row;