[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select effective_date
from fnd_sessions
where session_id = userenv('SESSIONID');
select trunc(sysdate)
from dual;
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 a.person_id
from per_all_people_f a,
per_all_assignments_f asg
where a.person_id = asg.person_id
and asg.assignment_id = p_assignment_id
and asg.business_group_id = a.business_group_id
and p_effective_date
between a.effective_start_date
and a.effective_end_date
and p_effective_date
between asg.effective_start_date
and asg.effective_end_date;
select *
from per_pay_proposals
where pay_proposal_id = p_old.pay_proposal_id;
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 ((exists
(select 1
from ben_per_info_chg_cs_ler_f psl
, ben_ler_per_info_cs_ler_f lpl
where source_table = 'PER_PAY_PROPOSALS'
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 = 'PER_PAY_PROPOSALS'
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
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 = 'PER_PAY_PROPOSALS'
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_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 = 'PER_PAY_PROPOSALS'
order by 1;
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;
/* 8888 delete lines.
if p_new.date_to is null then
l_date_to := l_session_date;
select ler.ler_id
,ler.ocrd_dt_det_cd
from ben_ler_f ler
where ler.business_group_id = p_business_group_id
and typ_cd = 'QUAINGR'
and l_session_date between ler.effective_start_date and
ler.effective_end_date
order by ler.ler_id;
select (maximum * grade_annualization_factor) maximum ,
(minimum * grade_annualization_factor) minimum
from pay_grade_rules_f pgr,
per_pay_bases ppb
where ppb.pay_basis_id = p_pay_basis_id
and ppb.business_group_id = p_business_group_id
and pgr.rate_id = ppb.rate_id
and pgr.business_group_id = p_business_group_id
and pgr.grade_or_spinal_point_id = p_grade_id
and p_lf_evt_ocrd_dt between nvl(pgr.effective_start_date, p_lf_evt_ocrd_dt)
and nvl(pgr.effective_end_date, p_lf_evt_ocrd_dt);
select ppp.proposed_salary_n * ppb.pay_annualization_factor annual_salary,ppp.change_date
from per_pay_bases ppb,
per_pay_proposals ppp
where ppb.pay_basis_id = p_pay_basis_id
and ppb.business_group_id = p_business_group_id
and ppp.assignment_id = p_assignment_id
and ppp.approved = 'Y'
and ppp.change_date <= p_lf_evt_ocrd_dt
and (p_called_from = 'A' or (p_called_from = 'P' and p_old_new = 'new') )
union
select ppp.proposed_salary_n * ppb.pay_annualization_factor annual_salary,ppp.change_date
from per_pay_bases ppb,
per_pay_proposals ppp
where ppb.pay_basis_id = p_pay_basis_id
and ppb.business_group_id = p_business_group_id
and ppp.assignment_id = p_assignment_id
and ppp.approved = 'Y'
and ppp.pay_proposal_id <> p_new_pro.pay_proposal_id
and ppp.change_date <= p_lf_evt_ocrd_dt
and p_called_from = 'P' and p_old_new = 'old'
order by 2 desc ;
select grade_id,pay_basis_id
from per_all_assignments_f
where assignment_id = p_assignment_id
and person_id = p_person_id
and business_group_id = p_business_group_id
and l_session_date between effective_start_date and effective_end_date;