The following lines contain the word 'select', 'insert', 'update' or 'delete':
select meaning
from hr_lookups
where lookup_type = 'BEN_EXT_LVL'
and lookup_code = p_lvl ;
procedure add_delete_sub_level(p_action varchar2 ,
p_low_lvl_cd varchar2) is
l_proc varchar2(72) := g_package||' add_delete_sub_level';
if p_action = 'DELETE' then
for j in REVERSE 1 .. l_last Loop
if g_low_lvl_tbl(j) = p_low_lvl_cd then
hr_Utility.set_location('delete '||j, 5);
g_low_lvl_tbl.delete(j) ;
end add_delete_sub_level ;
l_var := '
Date : Start Date :
End Date :
' ;
Line: 263
' ;
Line: 270
l_var := '
';
Line: 276
';
Line: 285
';
Line: 291
' ;
Line: 499
select template_code ,
application_id,
APPLICATION_SHORT_NAME
from xdo_templates_b xdo
where template_id = p_template_id ;
Line: 1192
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,
xrd.group_val_01
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
Line: 1516
select xdf.ext_file_id,
xdf.name,
xdf.xml_tag_name,
xdf.data_typ_cd ,
xdf.cm_display_flag,
xrs.eff_dt,
xrs.run_strt_dt,
xrs.run_end_dt,
xfi.xml_tag_name file_xml_tag_name ,
nvl( xrs.xdo_template_id, xdf.xdo_template_id ) xdo_template_id
from ben_Ext_dfn xdf,
ben_Ext_rslt xrs,
ben_ext_file xfi
where xrs.ext_rslt_id = p_ext_rslt_id
and xrs.ext_dfn_id = xdf.ext_dfn_id
and xdf.ext_file_id = xfi.ext_file_id ;
Line: 1537
select rcd.name ,
rcd.xml_tag_name ,
erf.seq_num,
rcd.rcd_type_cd,
erf.hide_flag ,
rcd.LOW_LVL_CD
from ben_ext_rcd_in_file erf ,
ben_ext_rcd rcd
where erf.ext_file_id = c_ext_file_id
and erf.ext_rcd_id = c_ext_rcd_id
and rcd.ext_rcd_id = erf.ext_rcd_id
order by erf.seq_num ;
Line: 1552
select elm.name,
elm.xml_tag_name,
rcd.seq_num,
elm.data_elmt_typ_cd,
elm.max_length_num,
elm.frmt_mask_cd,
elm.just_cd
from ben_ext_data_elmt_in_rcd rcd ,
ben_ext_data_elmt elm
where rcd.ext_rcd_id = c_ext_rcd_id
and elm.ext_data_elmt_id = rcd.ext_data_elmt_id
and nvl(rcd.hide_flag,'N') = 'N'
order by rcd.seq_num;
Line: 1567
select lookup_code ,
meaning
from hr_lookups
where lookup_type = 'BEN_EXT_XML_TAGS' ;
Line: 1598
select full_name,
employee_number
from per_all_people_f
where person_id = p_person_id
and p_effective_date between EFFECTIVE_START_DATE and
nvl(EFFECTIVE_END_DATE,trunc(sysdate));
Line: 1623
select outfile_name
from fnd_concurrent_requests
where request_id = fnd_global.conc_request_id ;
Line: 2193
add_delete_sub_level('DELETE' , l_prv_low_lvl_cd ) ;
Line: 2198
g_low_lvl_tbl.delete ;
Line: 2283
add_delete_sub_level('ADD' , l_ext_rcd.low_lvl_cd ) ;
Line: 2328
add_delete_sub_level('ADD' , l_ext_rcd.low_lvl_cd ) ;
Line: 2333
add_delete_sub_level('DELETE' , l_prv_low_lvl_cd ) ;
Line: 2356
add_delete_sub_level('ADD' , l_ext_rcd.low_lvl_cd ) ;
Line: 2475
g_low_lvl_tbl.delete ;
Line: 2542
update fnd_concurrent_requests
set output_file_type = 'XML'
where request_id = fnd_global.conc_request_id ;