[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select ctr.*
from per_contact_relationships ctr,
per_all_people_f ppf
where ctr.person_id = p_person_id
and ctr.personal_flag = 'Y'
and ctr.contact_person_id = ppf.person_id
and nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date))
between ppf.effective_start_date
and ppf.effective_end_date
and nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date))
between nvl(ctr.date_start,hr_api.g_sot)
and nvl(ctr.date_end,hr_api.g_eot)
and ctr.business_group_id = p_business_group_id;
select count(ctr.person_id)
from per_contact_relationships ctr,
per_all_people_f ppf
where ctr.person_id = p_person_id
and ctr.personal_flag = 'Y'
and ctr.contact_person_id = ppf.person_id
and nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date))
between ppf.effective_start_date
and ppf.effective_end_date
and nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date))
between nvl(ctr.date_start,hr_api.g_sot)
and nvl(ctr.date_end,hr_api.g_eot)
and ctr.business_group_id = p_business_group_id;
select pl_typ_id
from ben_ptip_f
where ptip_id = p_ptip_id
and c_effective_date
between effective_start_date
and effective_end_date;
select pln.pl_typ_id
from ben_plip_f plip,
ben_pl_f pln
where plip_id = p_plip_id
and c_effective_date
between plip.effective_start_date and plip.effective_end_date
and pln.pl_id = plip.pl_id
and c_effective_date
between pln.effective_start_date and pln.effective_end_date ;
select pln.pl_typ_id
from ben_oipl_f oipl,
ben_pl_f pln
where oipl_id = p_oipl_id
and c_effective_date
between oipl.effective_start_date and oipl.effective_end_date
and pln.pl_id = oipl.pl_id
and c_effective_date
between pln.effective_start_date and pln.effective_end_date ;
select 'Y'
from ff_fdi_usages_f
where FORMULA_ID = cv_formula_id
and ITEM_NAME = 'ASSIGNMENT_ID'
and usage = 'U';
g_elig_dpnt_rec.delete;