The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT name, chart_of_accounts_id
INTO ACCESS_SET_NAME, STRUCT_NUM
FROM gl_access_sets
WHERE access_set_id = P_ACCESS_SET_ID;
SELECT currency_code, object_type_code
INTO PARAM_LEDGER_CURR, PARAM_LEDGER_TYPE
FROM gl_ledgers
WHERE ledger_id = P_LEDGER_ID;
SELECT substr(ltrim(to_char(11, '9G9')), 2, 1)
INTO THOUSANDS_SEPARATOR
FROM dual;
Function SELECT_BAL_p return varchar2 is
Begin
return SELECT_BAL;
Function SELECT_ALL_p return varchar2 is
Begin
return SELECT_ALL;
Function SELECT_ACCT_p return varchar2 is
Begin
return SELECT_ACCT;