DBA Data[Home] [Help]

APPS.JA_CN_APAB_EXPORT_PKG dependencies on JA_CN_ACCOUNT_BALANCES_GT

Line 89: lv_sql_stmt4insert_j_line VARCHAR2(30000) := 'INSERT INTO ja_cn_account_balances_gt

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,

Line 247: FROM ja_cn_account_balances_gt

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

Line 499: --Insert data to global temp table ja_cn_account_balances_gt

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;