The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
NVL(USER_JE_SOURCE_NAME
,'**********')
INTO TRANS_SOURCE
FROM
GL_JE_SOURCES_TL
WHERE JE_SOURCE_NAME = SOURCE_ID
AND LANGUAGE = 'US';
SELECT
DESCRIPTION
INTO TRANS_MEANING
FROM
GL_LOOKUPS
WHERE LOOKUP_TYPE = 'SUBLDGR_DRILLDOWN_TRANS_TYPE'
AND LOOKUP_CODE = TRANS_TYPE;
SELECT
EFFECTIVE_PERIOD_NUM
INTO EFF_PERIOD_NUM
FROM
GL_PERIOD_STATUSES
WHERE APPLICATION_ID = 101
AND SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID
AND UPPER(PERIOD_NAME) = UPPER(P_START_PERIOD);
SELECT
EFFECTIVE_PERIOD_NUM
INTO EFF_PERIOD_NUM
FROM
GL_PERIOD_STATUSES
WHERE APPLICATION_ID = 101
AND SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID
AND UPPER(PERIOD_NAME) = UPPER(P_END_PERIOD);
SELECT
SEGMENT1_LOW || L_DELIMITER || SEGMENT2_LOW || L_DELIMITER || SEGMENT3_LOW || L_DELIMITER ||
SEGMENT4_LOW || L_DELIMITER || SEGMENT5_LOW || L_DELIMITER || SEGMENT6_LOW || L_DELIMITER ||
SEGMENT7_LOW || L_DELIMITER || SEGMENT8_LOW || L_DELIMITER || SEGMENT9_LOW || L_DELIMITER ||
SEGMENT10_LOW || L_DELIMITER || SEGMENT11_LOW || L_DELIMITER || SEGMENT12_LOW || L_DELIMITER ||
SEGMENT13_LOW || L_DELIMITER || SEGMENT14_LOW || L_DELIMITER || SEGMENT15_LOW || L_DELIMITER ||
SEGMENT16_LOW || L_DELIMITER || SEGMENT17_LOW || L_DELIMITER || SEGMENT18_LOW || L_DELIMITER ||
SEGMENT19_LOW || L_DELIMITER || SEGMENT20_LOW || L_DELIMITER || SEGMENT21_LOW || L_DELIMITER ||
SEGMENT22_LOW || L_DELIMITER || SEGMENT23_LOW || L_DELIMITER || SEGMENT24_LOW || L_DELIMITER ||
SEGMENT25_LOW || L_DELIMITER || SEGMENT26_LOW || L_DELIMITER || SEGMENT27_LOW || L_DELIMITER ||
SEGMENT28_LOW || L_DELIMITER || SEGMENT29_LOW || L_DELIMITER || SEGMENT30_LOW ACCOUNT_LOW,
SEGMENT1_HIGH || L_DELIMITER || SEGMENT2_HIGH || L_DELIMITER || SEGMENT3_HIGH || L_DELIMITER ||
SEGMENT4_HIGH || L_DELIMITER || SEGMENT5_HIGH || L_DELIMITER || SEGMENT6_HIGH || L_DELIMITER ||
SEGMENT7_HIGH || L_DELIMITER || SEGMENT8_HIGH || L_DELIMITER || SEGMENT9_HIGH || L_DELIMITER ||
SEGMENT10_HIGH || L_DELIMITER || SEGMENT11_HIGH || L_DELIMITER || SEGMENT12_HIGH || L_DELIMITER ||
SEGMENT13_HIGH || L_DELIMITER || SEGMENT14_HIGH || L_DELIMITER || SEGMENT15_HIGH || L_DELIMITER ||
SEGMENT16_HIGH || L_DELIMITER || SEGMENT17_HIGH || L_DELIMITER || SEGMENT18_HIGH || L_DELIMITER ||
SEGMENT19_HIGH || L_DELIMITER || SEGMENT20_HIGH || L_DELIMITER || SEGMENT21_HIGH || L_DELIMITER ||
SEGMENT22_HIGH || L_DELIMITER || SEGMENT23_HIGH || L_DELIMITER || SEGMENT24_HIGH || L_DELIMITER ||
SEGMENT25_HIGH || L_DELIMITER || SEGMENT26_HIGH || L_DELIMITER || SEGMENT27_HIGH || L_DELIMITER ||
SEGMENT28_HIGH || L_DELIMITER || SEGMENT29_HIGH || L_DELIMITER || SEGMENT30_HIGH ACCOUNT_HIGH
FROM
JL_ZZ_GL_AXI_MODEL_RANGES AMR
WHERE AMR.MODEL_ID = P_MODEL_ID;
SELECT name comp_name,
registration_number,
activity_code,
ltrim(address_line_1 ||' '|| address_line_2),
ltrim(address_line_3 ||' '|| town_or_city)
INTO CP_COMP_NAME,
CP_COMP_TAXPAYER_ID,
CP_COMP_ESTAB_TYPE,
CP_COMP_ADDRESS1,
CP_COMP_ADDRESS2
FROM XLE_FIRSTPARTY_INFORMATION_V
WHERE Legal_entity_id = P_COMPANY_ID
AND LEGISLATIVE_CAT_CODE = 'INCOME_TAX';
SELECT concatenated_segment_delimiter
INTO delimiter
FROM fnd_id_flex_structures
WHERE application_id = 101
AND id_flex_code = 'GL#'
AND id_flex_num = P_CHART_OF_ACCTS_ID
AND ROWNUM < 2;
SELECT name
INTO CP_MODEL_NAME
FROM jl_zz_gl_axi_models
WHERE model_id = P_MODEL_ID
AND set_of_books_id = P_SET_OF_BOOKS_ID;
MODE="SELECT" DISPLAY="ALL"'); */
/* Generate the selected ORDER BY */
/*--**
if (:P_ORDER_TYPE = 'A') then
:ORDER_BY := :ORDERBY_ACCT || ', ' ||
:ORDERBY_ACCT2 || ', ' ||
:ORDERBY_BAL || ', ' ||
:ORDERBY_BAL2 || ', ' ||
:ORDERBY_ALL || ', ' ||
'src.user_je_source_name, ' ||
'cat.user_je_category_name, ' ||
'jeb.name, jeh.name, jel.je_line_num';