APPS.BEN_EEV_LER SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 11

select per.person_id, per.business_group_id
from ben_prtt_rt_val prv,
ben_prtt_enrt_rslt per
where prv.element_entry_value_id = p_new.element_entry_value_id
and l_session_date between rt_strt_dt and rt_end_dt
and prv.prtt_enrt_rslt_id = per.prtt_enrt_rslt_id
and prv.business_group_id  = per.business_group_id ;

Line: 20

select effective_date
from   fnd_sessions
where  session_id = userenv('SESSIONID');

Line: 25

select trunc(sysdate)
from   dual;

Line: 29

	select ler.ler_id,
        ler.typ_cd ,
        ler.ocrd_dt_det_cd
	from ben_ler ler
	where ler.business_group_id = l_business_group_id
        and    l_session_date between ler.effective_start_date
        and    ler.effective_end_date   -- For Bug 3299709
        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 lpl
		where source_table = 'PAY_ELEMENT_ENTRY_VALUES_F'
		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    -- For Bug 3299709
		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 lrp
		where source_table = 'PAY_ELEMENT_ENTRY_VALUES_F'
		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   -- For Bug 3299709
		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;

Line: 66

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
from ben_ler_per_info_cs_ler lpl, ben_per_info_chg_cs_ler_f psl
where lpl.ler_id = p_ler_id and
lpl.business_group_id = l_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 psl.per_info_chg_cs_ler_id = lpl.per_info_chg_cs_ler_id
and source_table = 'PAY_ELEMENT_ENTRY_VALUES_F'
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
from ben_ler_rltd_per_cs_ler lrp, ben_rltd_per_chg_cs_ler_f rpc
where lrp.ler_id = p_ler_id and
lrp.business_group_id = l_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 rpc.rltd_per_chg_cs_ler_id = lrp.rltd_per_chg_cs_ler_id
and source_table = 'PAY_ELEMENT_ENTRY_VALUES_F'
order by 1;

Line: 90

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;

Line: 98

select contact_person_id
from per_contact_relationships
where person_id = p_person_id
and business_group_id = l_business_group_id
and l_session_date between nvl(date_start,l_session_date)
and nvl(date_end,l_session_date)
order by person_id;