The following lines contain the word 'select', 'insert', 'update' or 'delete':
select name, from_currency_code
into cons_name, curr_code
from gl_consolidation
where consolidation_id = cons_id;
select jeb.name, jeb.default_period_name
into batch_name, to_period
from gl_je_batches jeb,
gl_je_headers jeh,
gl_je_lines jel
where jeb.je_batch_id = batch_id
and jeh.je_batch_id = jeb.je_batch_id
and (jeh.display_alc_journal_flag is null or jeh.display_alc_journal_flag = 'Y')
and jel.je_header_id = jeh.je_header_id
and rownum < 2;
select jir.reference_3, jir.reference_1, jir.reference_4
into s_header_id, s_consolidation_id, s_ccid
from gl_import_references jir, gl_je_headers jeh
where jeh.je_batch_id = batch_id
and jir.je_header_id = jeh.je_header_id
and rownum < 2;
select jeh.ledger_id
into from_ledid
from gl_je_headers jeh
where jeh.je_header_id = header_id;
select gca.to_ledger_id
into to_ledid
from gl_consolidation gca
where gca.consolidation_id = cons_id ;
SELECT name
INTO DAS_NAME
FROM gl_access_sets
WHERE access_set_id = P_ACCESS_SET_ID;
SELECT glr.target_ledger_name
INTO FROM_LEDGER_NAME
FROM gl_ledger_relationships glr, gl_consolidation gcs
WHERE glr.target_currency_code = gcs.from_currency_code
AND glr.source_ledger_id = gcs.from_ledger_id
AND glr.target_ledger_id = gcs.from_ledger_id
AND gcs.consolidation_id = cons_id;
Function SELECT_TO_FLEX_p return varchar2 is
Begin
return SELECT_TO_FLEX;
Function SELECT_FROM_FLEX_p return varchar2 is
Begin
return SELECT_FROM_FLEX;