The following lines contain the word 'select', 'insert', 'update' or 'delete':
g_val.delete;
g_strt_pos.delete;
g_array.delete;
g_dlmtr_val.delete;
g_just_cd.delete;
g_short_name.delete;
g_hide_flag.delete;
select xer.seq_num,
xer.strt_pos,
xer.dlmtr_val,
xer.hide_flag,
xde.just_cd ,
xef.short_name
from ben_ext_data_elmt_in_rcd xer,
ben_ext_data_elmt xde,
ben_ext_fld xef
where xer.ext_rcd_id = p_ext_rcd_id
and xer.ext_data_elmt_id = xde.ext_data_elmt_id
and xde.ext_fld_id = xef.ext_fld_id (+)
order by xer.seq_num;
select xrs.output_name,
xrs.drctry_name,
xrs.ext_stat_cd,
xrs.business_group_id,
xdf.spcl_hndl_flag,
nvl(xrs.output_type, xdf.output_type ) output_type ,
xdf.cm_display_flag ,
nvl(xrs.xdo_template_id, xdf.xdo_template_id) xdo_template_id
from ben_ext_rslt xrs,
ben_ext_dfn xdf
where xrs.ext_rslt_id = p_ext_rslt_id
and xdf.ext_dfn_id = xrs.ext_dfn_id;
select xrd.ext_rcd_id,
xrd.person_id,
xrd.val_01,
xrd.val_02,
xrd.val_03,
xrd.val_04,
xrd.val_05,
xrd.val_06,
xrd.val_07,
xrd.val_08,
xrd.val_09,
xrd.val_10,
xrd.val_11,
xrd.val_12,
xrd.val_13,
xrd.val_14,
xrd.val_15,
xrd.val_16,
xrd.val_17,
xrd.val_18,
xrd.val_19,
xrd.val_20,
xrd.val_21,
xrd.val_22,
xrd.val_23,
xrd.val_24,
xrd.val_25,
xrd.val_26,
xrd.val_27,
xrd.val_28,
xrd.val_29,
xrd.val_30,
xrd.val_31,
xrd.val_32,
xrd.val_33,
xrd.val_34,
xrd.val_35,
xrd.val_36,
xrd.val_37,
xrd.val_38,
xrd.val_39,
xrd.val_40,
xrd.val_41,
xrd.val_42,
xrd.val_43,
xrd.val_44,
xrd.val_45,
xrd.val_46,
xrd.val_47,
xrd.val_48,
xrd.val_49,
xrd.val_50,
xrd.val_51,
xrd.val_52,
xrd.val_53,
xrd.val_54,
xrd.val_55,
xrd.val_56,
xrd.val_57,
xrd.val_58,
xrd.val_59,
xrd.val_60,
xrd.val_61,
xrd.val_62,
xrd.val_63,
xrd.val_64,
xrd.val_65,
xrd.val_66,
xrd.val_67,
xrd.val_68,
xrd.val_69,
xrd.val_70,
xrd.val_71,
xrd.val_72,
xrd.val_73,
xrd.val_74,
xrd.val_75,
xrd.val_76,
xrd.val_77,
xrd.val_78,
xrd.val_79,
xrd.val_80,
xrd.val_81,
xrd.val_82,
xrd.val_83,
xrd.val_84,
xrd.val_85,
xrd.val_86,
xrd.val_87,
xrd.val_88,
xrd.val_89,
xrd.val_90,
xrd.val_91,
xrd.val_92,
xrd.val_93,
xrd.val_94,
xrd.val_95,
xrd.val_96,
xrd.val_97,
xrd.val_98,
xrd.val_99,
xrd.val_100,
xrd.val_101,
xrd.val_102,
xrd.val_103,
xrd.val_104,
xrd.val_105,
xrd.val_106,
xrd.val_107,
xrd.val_108,
xrd.val_109,
xrd.val_110,
xrd.val_111,
xrd.val_112,
xrd.val_113,
xrd.val_114,
xrd.val_115,
xrd.val_116,
xrd.val_117,
xrd.val_118,
xrd.val_119,
xrd.val_120,
xrd.val_121,
xrd.val_122,
xrd.val_123,
xrd.val_124,
xrd.val_125,
xrd.val_126,
xrd.val_127,
xrd.val_128,
xrd.val_129,
xrd.val_130,
xrd.val_131,
xrd.val_132,
xrd.val_133,
xrd.val_134,
xrd.val_135,
xrd.val_136,
xrd.val_137,
xrd.val_138,
xrd.val_139,
xrd.val_140,
xrd.val_141,
xrd.val_142,
xrd.val_143,
xrd.val_144,
xrd.val_145,
xrd.val_146,
xrd.val_147,
xrd.val_148,
xrd.val_149,
xrd.val_150,
xrd.val_151,
xrd.val_152,
xrd.val_153,
xrd.val_154,
xrd.val_155,
xrd.val_156,
xrd.val_157,
xrd.val_158,
xrd.val_159,
xrd.val_160,
xrd.val_161,
xrd.val_162,
xrd.val_163,
xrd.val_164,
xrd.val_165,
xrd.val_166,
xrd.val_167,
xrd.val_168,
xrd.val_169,
xrd.val_170,
xrd.val_171,
xrd.val_172,
xrd.val_173,
xrd.val_174,
xrd.val_175,
xrd.val_176,
xrd.val_177,
xrd.val_178,
xrd.val_179,
xrd.val_180,
xrd.val_181,
xrd.val_182,
xrd.val_183,
xrd.val_184,
xrd.val_185,
xrd.val_186,
xrd.val_187,
xrd.val_188,
xrd.val_189,
xrd.val_190,
xrd.val_191,
xrd.val_192,
xrd.val_193,
xrd.val_194,
xrd.val_195,
xrd.val_196,
xrd.val_197,
xrd.val_198,
xrd.val_199,
xrd.val_200,
xrd.val_201,
xrd.val_202,
xrd.val_203,
xrd.val_204,
xrd.val_205,
xrd.val_206,
xrd.val_207,
xrd.val_208,
xrd.val_209,
xrd.val_210,
xrd.val_211,
xrd.val_212,
xrd.val_213,
xrd.val_214,
xrd.val_215,
xrd.val_216,
xrd.val_217,
xrd.val_218,
xrd.val_219,
xrd.val_220,
xrd.val_221,
xrd.val_222,
xrd.val_223,
xrd.val_224,
xrd.val_225,
xrd.val_226,
xrd.val_227,
xrd.val_228,
xrd.val_229,
xrd.val_230,
xrd.val_231,
xrd.val_232,
xrd.val_233,
xrd.val_234,
xrd.val_235,
xrd.val_236,
xrd.val_237,
xrd.val_238,
xrd.val_239,
xrd.val_240,
xrd.val_241,
xrd.val_242,
xrd.val_243,
xrd.val_244,
xrd.val_245,
xrd.val_246,
xrd.val_247,
xrd.val_248,
xrd.val_249,
xrd.val_250,
xrd.val_251,
xrd.val_252,
xrd.val_253,
xrd.val_254,
xrd.val_255,
xrd.val_256,
xrd.val_257,
xrd.val_258,
xrd.val_259,
xrd.val_260,
xrd.val_261,
xrd.val_262,
xrd.val_263,
xrd.val_264,
xrd.val_265,
xrd.val_266,
xrd.val_267,
xrd.val_268,
xrd.val_269,
xrd.val_270,
xrd.val_271,
xrd.val_272,
xrd.val_273,
xrd.val_274,
xrd.val_275,
xrd.val_276,
xrd.val_277,
xrd.val_278,
xrd.val_279,
xrd.val_280,
xrd.val_281,
xrd.val_282,
xrd.val_283,
xrd.val_284,
xrd.val_285,
xrd.val_286,
xrd.val_287,
xrd.val_288,
xrd.val_289,
xrd.val_290,
xrd.val_291,
xrd.val_292,
xrd.val_293,
xrd.val_294,
xrd.val_295,
xrd.val_296,
xrd.val_297,
xrd.val_298,
xrd.val_299,
xrd.val_300,
xrf.seq_num
from ben_ext_rslt_dtl xrd,
ben_ext_rslt xrs,
ben_ext_dfn xdf,
ben_ext_rcd_in_file xrf
where xrd.ext_rslt_id = p_ext_rslt_id
and xrd.ext_rslt_id = xrs.ext_rslt_id
and xrs.ext_dfn_id = xdf.ext_dfn_id
and xdf.ext_file_id = xrf.ext_file_id
and xrd.ext_rcd_id = xrf.ext_rcd_id
and (xrd.ext_rcd_in_file_id is null
or xrd.ext_rcd_in_file_id = xrf.ext_rcd_in_file_id ) -- or condition taken care of previous results
and xrf.hide_flag = 'N'
order by xrd.group_val_01,
xrd.group_val_02,
xrd.prmy_sort_val,
xrd.scnd_sort_val,
xrd.thrd_sort_val,
xrf.seq_num ; -- this is addedd ther are many time header may not sorted in order
select 'x'
from ben_ext_rslt_dtl xrd
where xrd.ext_rslt_id = p_ext_rslt_id;
select 'x'
from gv$system_parameter
where name = 'utl_file_dir'
and value like ('%' || l_drctry_name || '%')
union
select 'x'
from gv$system_parameter2
where name = 'utl_file_dir'
and value like ('%' || l_drctry_name || '%');
select xel.name
from ben_ext_data_elmt xel,
ben_Ext_data_elmt_in_rcd xdr
where xdr.ext_data_elmt_id = xel.ext_data_elmt_id
and xdr.ext_rcd_id = p_ext_rcd_id
and xdr.seq_num = p_seq_num
;
select application_short_name ,
template_code ,
default_language,
default_territory
from xdo_templates_b
where template_id = c_xdo_id ;