DBA Data[Home] [Help]

APPS.FV_GTAS_TBAL_TRX_PKG dependencies on FV_GTAS1_REPORT_T2

Line 135: DELETE FROM fv_gtas1_report_t2

131: BEGIN
132:
133: log(l_module, 'Begin');
134:
135: DELETE FROM fv_gtas1_report_t2
136: WHERE set_of_books_id = gbl_set_of_books_id;
137:
138: log(l_module, 'End');
139: EXCEPTION

Line 307: INSERT INTO fv_gtas1_report_t2

303: BEGIN
304: log(l_module, 'Begin');
305:
306: l_statement := '
307: INSERT INTO fv_gtas1_report_t2
308: ( account_number,
309: d_c_indicator,
310: amount,
311: record_category,

Line 394: DELETE FROM fv_gtas1_report_t2

390: EXECUTE IMMEDIATE l_statement
391: USING gbl_set_of_books_id, gbl_set_of_books_id,
392: gbl_period_num_high, gbl_fiscal_year;
393:
394: DELETE FROM fv_gtas1_report_t2
395: WHERE record_category <> 'TRIAL_BAL'
396: AND set_of_books_id = gbl_set_of_books_id;
397:
398: COMMIT;