The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
ext_rslt_dtl_id,
prmy_sort_val,
scnd_sort_val,
thrd_sort_val,
trans_seq_num,
rcrd_seq_num,
ext_rslt_id,
ext_rcd_id,
person_id,
business_group_id,
ext_per_bg_id,
val_01,
val_02,
val_03,
val_04,
val_05,
val_06,
val_07,
val_08,
val_09,
val_10,
val_11,
val_12,
val_13,
val_14,
val_15,
val_16,
val_17,
val_19,
val_18,
val_20,
val_21,
val_22,
val_23,
val_24,
val_25,
val_26,
val_27,
val_28,
val_29,
val_30,
val_31,
val_32,
val_33,
val_34,
val_35,
val_36,
val_37,
val_38,
val_39,
val_40,
val_41,
val_42,
val_43,
val_44,
val_45,
val_46,
val_47,
val_48,
val_49,
val_50,
val_51,
val_52,
val_53,
val_54,
val_55,
val_56,
val_57,
val_58,
val_59,
val_60,
val_61,
val_62,
val_63,
val_64,
val_65,
val_66,
val_67,
val_68,
val_69,
val_70,
val_71,
val_72,
val_73,
val_74,
val_75,
val_76,
val_77,
val_78,
val_79,
val_80,
val_81,
val_82,
val_83,
val_84,
val_85,
val_86,
val_87,
val_88,
val_89,
val_90,
val_91,
val_92,
val_93,
val_94,
val_95,
val_96,
val_97,
val_98,
val_99,
val_100,
val_101,
val_102,
val_103,
val_104,
val_105,
val_106,
val_107,
val_108,
val_109,
val_110,
val_111,
val_112,
val_113,
val_114,
val_115,
val_116,
val_117,
val_119,
val_118,
val_120,
val_121,
val_122,
val_123,
val_124,
val_125,
val_126,
val_127,
val_128,
val_129,
val_130,
val_131,
val_132,
val_133,
val_134,
val_135,
val_136,
val_137,
val_138,
val_139,
val_140,
val_141,
val_142,
val_143,
val_144,
val_145,
val_146,
val_147,
val_148,
val_149,
val_150,
val_151,
val_152,
val_153,
val_154,
val_155,
val_156,
val_157,
val_158,
val_159,
val_160,
val_161,
val_162,
val_163,
val_164,
val_165,
val_166,
val_167,
val_168,
val_169,
val_170,
val_171,
val_172,
val_173,
val_174,
val_175,
val_176,
val_177,
val_178,
val_179,
val_180,
val_181,
val_182,
val_183,
val_184,
val_185,
val_186,
val_187,
val_188,
val_189,
val_190,
val_191,
val_192,
val_193,
val_194,
val_195,
val_196,
val_197,
val_198,
val_199,
val_200,
val_201,
val_202,
val_203,
val_204,
val_205,
val_206,
val_207,
val_208,
val_209,
val_210,
val_211,
val_212,
val_213,
val_214,
val_215,
val_216,
val_217,
val_219,
val_218,
val_220,
val_221,
val_222,
val_223,
val_224,
val_225,
val_226,
val_227,
val_228,
val_229,
val_230,
val_231,
val_232,
val_233,
val_234,
val_235,
val_236,
val_237,
val_238,
val_239,
val_240,
val_241,
val_242,
val_243,
val_244,
val_245,
val_246,
val_247,
val_248,
val_249,
val_250,
val_251,
val_252,
val_253,
val_254,
val_255,
val_256,
val_257,
val_258,
val_259,
val_260,
val_261,
val_262,
val_263,
val_264,
val_265,
val_266,
val_267,
val_268,
val_269,
val_270,
val_271,
val_272,
val_273,
val_274,
val_275,
val_276,
val_277,
val_278,
val_279,
val_280,
val_281,
val_282,
val_283,
val_284,
val_285,
val_286,
val_287,
val_288,
val_289,
val_290,
val_291,
val_292,
val_293,
val_294,
val_295,
val_296,
val_297,
val_298,
val_299,
val_300,
group_val_01 ,
group_val_02 ,
program_application_id,
program_id,
program_update_date,
request_id,
object_version_number,
ext_rcd_in_file_id
from ben_ext_rslt_dtl
where ext_rslt_dtl_id = p_ext_rslt_dtl_id;
select ext_rslt_dtl_id,
prmy_sort_val,
scnd_sort_val,
thrd_sort_val,
trans_seq_num,
rcrd_seq_num,
ext_rslt_id,
ext_rcd_id,
person_id,
business_group_id,
ext_per_bg_id,
val_01,
val_02,
val_03,
val_04,
val_05,
val_06,
val_07,
val_08,
val_09,
val_10,
val_11,
val_12,
val_13,
val_14,
val_15,
val_16,
val_17,
val_19,
val_18,
val_20,
val_21,
val_22,
val_23,
val_24,
val_25,
val_26,
val_27,
val_28,
val_29,
val_30,
val_31,
val_32,
val_33,
val_34,
val_35,
val_36,
val_37,
val_38,
val_39,
val_40,
val_41,
val_42,
val_43,
val_44,
val_45,
val_46,
val_47,
val_48,
val_49,
val_50,
val_51,
val_52,
val_53,
val_54,
val_55,
val_56,
val_57,
val_58,
val_59,
val_60,
val_61,
val_62,
val_63,
val_64,
val_65,
val_66,
val_67,
val_68,
val_69,
val_70,
val_71,
val_72,
val_73,
val_74,
val_75,
val_76,
val_77,
val_78,
val_79,
val_80,
val_81,
val_82,
val_83,
val_84,
val_85,
val_86,
val_87,
val_88,
val_89,
val_90,
val_91,
val_92,
val_93,
val_94,
val_95,
val_96,
val_97,
val_98,
val_99,
val_100,
val_101,
val_102,
val_103,
val_104,
val_105,
val_106,
val_107,
val_108,
val_109,
val_110,
val_111,
val_112,
val_113,
val_114,
val_115,
val_116,
val_117,
val_119,
val_118,
val_120,
val_121,
val_122,
val_123,
val_124,
val_125,
val_126,
val_127,
val_128,
val_129,
val_130,
val_131,
val_132,
val_133,
val_134,
val_135,
val_136,
val_137,
val_138,
val_139,
val_140,
val_141,
val_142,
val_143,
val_144,
val_145,
val_146,
val_147,
val_148,
val_149,
val_150,
val_151,
val_152,
val_153,
val_154,
val_155,
val_156,
val_157,
val_158,
val_159,
val_160,
val_161,
val_162,
val_163,
val_164,
val_165,
val_166,
val_167,
val_168,
val_169,
val_170,
val_171,
val_172,
val_173,
val_174,
val_175,
val_176,
val_177,
val_178,
val_179,
val_180,
val_181,
val_182,
val_183,
val_184,
val_185,
val_186,
val_187,
val_188,
val_189,
val_190,
val_191,
val_192,
val_193,
val_194,
val_195,
val_196,
val_197,
val_198,
val_199,
val_200,
val_201,
val_202,
val_203,
val_204,
val_205,
val_206,
val_207,
val_208,
val_209,
val_210,
val_211,
val_212,
val_213,
val_214,
val_215,
val_216,
val_217,
val_219,
val_218,
val_220,
val_221,
val_222,
val_223,
val_224,
val_225,
val_226,
val_227,
val_228,
val_229,
val_230,
val_231,
val_232,
val_233,
val_234,
val_235,
val_236,
val_237,
val_238,
val_239,
val_240,
val_241,
val_242,
val_243,
val_244,
val_245,
val_246,
val_247,
val_248,
val_249,
val_250,
val_251,
val_252,
val_253,
val_254,
val_255,
val_256,
val_257,
val_258,
val_259,
val_260,
val_261,
val_262,
val_263,
val_264,
val_265,
val_266,
val_267,
val_268,
val_269,
val_270,
val_271,
val_272,
val_273,
val_274,
val_275,
val_276,
val_277,
val_278,
val_279,
val_280,
val_281,
val_282,
val_283,
val_284,
val_285,
val_286,
val_287,
val_288,
val_289,
val_290,
val_291,
val_292,
val_293,
val_294,
val_295,
val_296,
val_297,
val_298,
val_299,
val_300,
group_val_01 ,
group_val_02 ,
program_application_id,
program_id,
program_update_date,
request_id,
object_version_number,
ext_rcd_in_file_id
from ben_ext_rslt_dtl
where ext_rslt_dtl_id = p_ext_rslt_dtl_id
for update nowait;
p_program_update_date in date,
p_request_id in number,
p_object_version_number in number,
p_ext_rcd_in_file_id in number
)
Return g_rec_type is
--
l_rec g_rec_type;
l_rec.program_update_date := p_program_update_date;