The following lines contain the word 'select', 'insert', 'update' or 'delete':
select effective_date
from fnd_sessions
where session_id = userenv('SESSIONID');
select ler.ler_id
, ler.typ_cd
, ler.ocrd_dt_det_cd
from ben_ler_f ler
where ler.business_group_id = p_new.business_group_id
and l_session_date between ler.effective_start_date and ler.effective_end_date
and ( l_status = 'I' or ler.typ_cd in ('COMP','GSP','ABS','CHECKLIST') )
and ((exists
(select 1
from ben_per_info_chg_cs_ler_f psl
, ben_ler_per_info_cs_ler_f lpl
where source_table like 'PER_PERSON_ANALYSES%'
and psl.per_info_chg_cs_ler_id = lpl.per_info_chg_cs_ler_id
and lpl.business_group_id = psl.business_group_id
and lpl.business_group_id = ler.business_group_id
and l_session_date between psl.effective_start_date and psl.effective_end_date
and l_session_date between lpl.effective_start_date and lpl.effective_end_date
and lpl.ler_id = ler.ler_id)
)
OR (exists
(select 1
from ben_rltd_per_chg_cs_ler_f rpc
, ben_ler_rltd_per_cs_ler_f lrp
where source_table like 'PER_PERSON_ANALYSES%'
and lrp.business_group_id = rpc.business_group_id
and lrp.business_group_id = ler.business_group_id
and l_session_date between rpc.effective_start_date and rpc.effective_end_date
and l_session_date between lrp.effective_start_date and lrp.effective_end_date
and rpc.rltd_per_chg_cs_ler_id = lrp.rltd_per_chg_cs_ler_id
and lrp.ler_id = ler.ler_id)
))
order by ler.ler_id;
select psl.source_column, psl.new_val, psl.old_val,
'P', psl.per_info_chg_cs_ler_rl, psl.rule_overrides_flag,
lpl.chg_mandatory_cd, psl.source_table ,
substr(psl.source_table, instr(psl.source_table, '-')+2 ,length(psl.source_table)) l_context
from ben_ler_per_info_cs_ler_f lpl,
ben_per_info_chg_cs_ler_f psl
where lpl.ler_id = p_ler_id
and lpl.business_group_id = p_new.business_group_id
and lpl.business_group_id = psl.business_group_id
and l_session_date between psl.effective_start_date and psl.effective_end_date
and l_session_date between lpl.effective_start_date and lpl.effective_end_date
and psl.per_info_chg_cs_ler_id = lpl.per_info_chg_cs_ler_id
and source_table like 'PER_PERSON_ANALYSES%'
UNION
select rpc.source_column, rpc.new_val, rpc.old_val,
'R', rpc.rltd_per_chg_cs_ler_rl per_info_chg_cs_ler, rpc.rule_overrides_flag,
lrp.chg_mandatory_cd, rpc.source_table,
substr(rpc.source_table, instr(rpc.source_table, '-')+2 ,length(rpc.source_table)) l_context
from ben_ler_rltd_per_cs_ler_f lrp,
ben_rltd_per_chg_cs_ler_f rpc
where lrp.ler_id = p_ler_id
and lrp.business_group_id = p_new.business_group_id
and lrp.business_group_id = rpc.business_group_id
and l_session_date between rpc.effective_start_date and rpc.effective_end_date
and l_session_date between lrp.effective_start_date and lrp.effective_end_date
and rpc.rltd_per_chg_cs_ler_id = lrp.rltd_per_chg_cs_ler_id
and source_table like 'PER_PERSON_ANALYSES%'
order by 1;
select 'Y'
from ben_ptnl_ler_for_per
where person_id = p_person_id
and ler_id = p_ler_id
and ptnl_ler_for_per_stat_cd = 'DTCTD'
and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;
select person_id
from per_contact_relationships
where contact_person_id = p_person_id
and business_group_id = p_new.business_group_id
and l_session_date between nvl(date_start,l_session_date)
and nvl(date_end,l_session_date)
and personal_flag = 'Y'
order by person_id;
select *
from per_analysis_criteria
where ANALYSIS_CRITERIA_ID = p_id;
select id_flex_num
from FND_ID_FLEX_STRUCTURES_TL
where id_flex_structure_name = p_name
and language = userenv('LANG');