The following lines contain the word 'select', 'insert', 'update' or 'delete':
select enable_average_balances_flag
into AVERAGE_BALANCES_FLAG
from gl_ledgers
where ledger_id = P_LEDGER_ID;
SELECT effective_period_num
INTO FROM_EFF_PERIOD_NUM
FROM gl_period_statuses
WHERE application_id = 101
AND ledger_id = P_LEDGER_ID
AND period_name = P_FROM_PERIOD;
SELECT effective_period_num
INTO TO_EFF_PERIOD_NUM
FROM gl_period_statuses
WHERE application_id = 101
AND ledger_id = P_LEDGER_ID
AND period_name = P_TO_PERIOD;
Function FLEX_SELECT_ALL_p return varchar2 is
Begin
return FLEX_SELECT_ALL;
Function FLEX_SELECT_BAL_p return varchar2 is
Begin
return FLEX_SELECT_BAL;
Function FLEX_SELECT_ACCT_p return varchar2 is
Begin
return FLEX_SELECT_ACCT;