[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT chart_of_accounts_id
INTO gbl_coa_id
FROM gl_ledgers_public_v
WHERE ledger_id = gbl_set_of_books_id;
SELECT flex_value_set_id
INTO gbl_acc_value_set_id
FROM fnd_id_flex_segments
WHERE application_column_name = gbl_acc_segment_name
AND id_flex_code = 'GL#'
AND id_flex_num = gbl_coa_id;
DELETE FROM fv_gtas1_report_t2
WHERE set_of_books_id = gbl_set_of_books_id;
SELECT period_num, period_year
INTO gbl_period_num_high, gbl_fiscal_year
FROM gl_period_statuses
WHERE period_name = p_period
AND application_id = 101
AND closing_status NOT IN ('F','N')
AND ledger_id = gbl_set_of_books_id;
SELECT MIN(period_num)
INTO gbl_period_num_low
FROM gl_period_statuses
WHERE period_year = gbl_fiscal_year
AND application_id = 101
AND closing_status <> 'F'
AND closing_status <> 'N'
AND adjustment_period_flag = 'N'
AND ledger_id = gbl_set_of_books_id;
INSERT INTO fv_gtas1_report_t2
( account_number,
d_c_indicator,
amount,
record_category,
ussgl_account,
set_of_books_id,
exch_non_exch,
cust_non_cust,
ccid,
account_type,
direct_or_reimb_code,
appor_cat_code,
appor_cat_b_code,
program_rept_code,
bea_cat_code ,
borr_src_code ,
new_bal_code ,
cur_subsequent_code ,
pya_code ,
credit_cohort_yr ,
program_cost_ind ,
treasury_symbol_id ,
fed_non_fed ,
authority_type_code,
budget_impact_ind,
trading_partner_agency_id,
trading_partner_main_account,
fund_value,
beginning_balance,
dr_amount,
cr_amount )
(SELECT t2.account_number,
'||''''||'N'||''''||',
0,
'||''''||'TRIAL_BAL'||''''||',
t2.ussgl_account,
:gbl_set_of_books_id,
t2.exch_non_exch,
t2.cust_non_cust,
t2.ccid,
t2.account_type,
t2.direct_or_reimb_code,
t2.appor_cat_code,
t2.appor_cat_b_code,
t2.program_rept_code,
t2.bea_cat_code,
t2.borr_src_code,
t2.new_bal_code,
t2.cur_subsequent_code,
t2.pya_code,
t2.credit_cohort_yr,
t2.program_cost_ind,
t2.treasury_symbol_id,
t2.fed_non_fed ,
t2.authority_type_code,
t2.budget_impact_ind,
t2.trading_partner_agency_id,
t2.trading_partner_main_account,
t2.fund_value,
t2.period_begin_bal,
nvl(t2.period_dr,0),
nvl(t2.period_cr,0)
--FROM fv_gtas1_period_balances_v t2, gl_code_combinations gcc
FROM FV_GTAS_PERIOD_BALANCES_TB_V t2, gl_code_combinations gcc,
fv_treasury_symbols fts
WHERE t2.set_of_books_id = :gbl_set_of_books_id
AND t2.ccid = gcc.code_combination_id
AND t2.period_num <= :gbl_period_num_high
AND t2.period_year = :gbl_fiscal_year
AND fts.treasury_symbol_id = t2.treasury_symbol_id
'||
gbl_tas_clause||
gbl_aid_clause||
gbl_main_acct_clause||
gbl_segs_where_clause||
' AND (period_begin_bal <> 0 OR
period_dr <> 0 OR
period_cr <> 0)
)';
DELETE FROM fv_gtas1_report_t2
WHERE record_category <> 'TRIAL_BAL'
AND set_of_books_id = gbl_set_of_books_id;
l_select VARCHAR2(1000);
SELECT application_column_name
FROM fnd_id_flex_segments
WHERE application_id = l_app_id
AND id_flex_code = l_id_flex_code
AND id_flex_num = l_coa_id
ORDER BY segment_num;
SELECT CHART_OF_ACCOUNTS_ID
INTO l_coa_id
FROM gl_ledgers
where ledger_id = p_sob_id;
l_select := l_select||' AND gcc.'||segments.application_column_name||' BETWEEN '||
''''||l_segs_low(i)||''''||' AND '||''''||l_segs_high(i)||'''';
p_segs_where_clause := l_select;