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
dpm.period_name,
prd.start_date,
prd.quarter_start_date,
prd.year_start_date
INTO
PERIOD_NAME,
PERIOD_START_DATE,
QUARTER_START_DATE,
YEAR_START_DATE
FROM
gl_access_sets acc,
gl_date_period_map dpm,
gl_periods prd
WHERE
acc.access_set_id = P_ACCESS_SET_ID
AND dpm.period_set_name = acc.period_set_name
AND dpm.period_type = acc.accounted_period_type
AND dpm.accounting_date = P_REPORTING_DATE
AND prd.period_set_name = dpm.period_set_name
AND prd.period_name = dpm.period_name
AND prd.period_type = dpm.period_type;
SELECT
PRECISION,
MINIMUM_ACCOUNTABLE_UNIT
INTO
PRECISION,
MAU
FROM
FND_CURRENCIES
WHERE
CURRENCY_CODE = RESULTING_CURRENCY;
Function SELECT_BAL_p return varchar2 is
Begin
return SELECT_BAL;
Function SELECT_FLEXDATA_p return varchar2 is
Begin
return SELECT_FLEXDATA;