The following lines contain the word 'select', 'insert', 'update' or 'delete':
select book_type_code,
to_gl_ccid,
segment1,
segment2,
segment3,
segment4,
segment5,
segment6,
segment7,
segment8,
segment9,
segment10,
segment11,
segment12,
segment13,
segment14,
segment15,
segment16,
segment17,
segment18,
segment19,
segment20,
segment21,
segment22,
segment23,
segment24,
segment25,
segment26,
segment27,
segment28,
segment29,
segment30
from fa_mass_transfers
where mass_transfer_id = x_mass_transfer_id;
select nvl(glcc.code_combination_id, -99)
from gl_code_combinations glcc,
( select * from gl_code_combinations
where code_combination_id = x_from_glccid ) from_glcc
where glcc.segment1 = nvl(mtfr_rec.segment1, from_glcc.segment1)
and glcc.segment2 = nvl(mtfr_rec.segment2, from_glcc.segment2)
and glcc.segment3 = nvl(mtfr_rec.segment3, from_glcc.segment3)
and glcc.segment4 = nvl(mtfr_rec.segment4, from_glcc.segment4)
and glcc.segment5 = nvl(mtfr_rec.segment5, from_glcc.segment5)
and glcc.segment6 = nvl(mtfr_rec.segment6, from_glcc.segment6)
and glcc.segment7 = nvl(mtfr_rec.segment7, from_glcc.segment7)
and glcc.segment8 = nvl(mtfr_rec.segment8, from_glcc.segment8)
and glcc.segment9 = nvl(mtfr_rec.segment9, from_glcc.segment9)
and glcc.segment10 = nvl(mtfr_rec.segment10, from_glcc.segment10)
and glcc.segment11 = nvl(mtfr_rec.segment11, from_glcc.segment11)
and glcc.segment12 = nvl(mtfr_rec.segment12, from_glcc.segment12)
and glcc.segment13 = nvl(mtfr_rec.segment13, from_glcc.segment13)
and glcc.segment14 = nvl(mtfr_rec.segment14, from_glcc.segment14)
and glcc.segment15 = nvl(mtfr_rec.segment15, from_glcc.segment15)
and glcc.segment16 = nvl(mtfr_rec.segment16, from_glcc.segment16)
and glcc.segment17 = nvl(mtfr_rec.segment17, from_glcc.segment17)
and glcc.segment18 = nvl(mtfr_rec.segment18, from_glcc.segment18)
and glcc.segment19 = nvl(mtfr_rec.segment19, from_glcc.segment19)
and glcc.segment20 = nvl(mtfr_rec.segment20, from_glcc.segment20)
and glcc.segment21 = nvl(mtfr_rec.segment21, from_glcc.segment21)
and glcc.segment22 = nvl(mtfr_rec.segment22, from_glcc.segment22)
and glcc.segment23 = nvl(mtfr_rec.segment23, from_glcc.segment23)
and glcc.segment24 = nvl(mtfr_rec.segment24, from_glcc.segment24)
and glcc.segment25 = nvl(mtfr_rec.segment25, from_glcc.segment25)
and glcc.segment26 = nvl(mtfr_rec.segment26, from_glcc.segment26)
and glcc.segment27 = nvl(mtfr_rec.segment27, from_glcc.segment27)
and glcc.segment28 = nvl(mtfr_rec.segment28, from_glcc.segment28)
and glcc.segment29 = nvl(mtfr_rec.segment29, from_glcc.segment29)
and glcc.segment30 = nvl(mtfr_rec.segment30, from_glcc.segment30)
and glcc.chart_of_accounts_id = v_chart_of_accounts_id ;
Select sob.chart_of_accounts_id
Into v_chart_of_accounts_id
From fa_book_controls bc,
gl_sets_of_books sob
Where sob.set_of_books_id = bc.set_of_books_id
And bc.book_type_code = mtfr_rec.book_type_code;
v_from_segarray.delete;
select segment1, segment2, segment3, segment4, segment5,
segment6, segment7, segment8, segment9, segment10,
segment11, segment12, segment13, segment14, segment15,
segment16, segment17, segment18, segment19, segment20,
segment21, segment22, segment23, segment24, segment25,
segment26, segment27, segment28, segment29, segment30
from fa_mass_transfers
where mass_transfer_id = x_mass_transfer_id;