[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select code from ghr_remarks where remark_id = p_remark_id;
select asg.position_id
from per_all_assignments_f asg
where asg.person_id = l_person_id
and l_effective_date between asg.effective_start_date and asg.effective_end_date
and asg.assignment_type <> 'B';
select fnd.user_name
from fnd_user fnd
where l_gbx_user_id = fnd.employee_id;
select ler.ler_id
from ben_ler_f ler
where ler.business_group_id = p_business_group_id
and ler.name = 'Added for Migration'
and p_effective_date between effective_start_date and effective_end_date;
select pgm.pgm_id
from ben_pgm_f pgm
where pgm.name = 'Federal Employees Health Benefits'
and pgm.business_group_id = p_business_group_id
and p_effective_date between effective_start_date and effective_end_date;
select plt.pl_typ_id
from ben_pl_typ_f plt
where plt.name = 'Health Benefits'
and plt.business_group_id = p_business_group_id
and p_effective_date between effective_start_date and effective_end_date;
select ptip_id
from ben_ptip_f
where pl_typ_id = l_pl_typ_id
and pgm_id = l_pgm_id
and p_effective_date between effective_start_date and effective_end_date;
select pln.pl_id pl_id
from ben_pl_f pln
where pln.short_code = p_health_plan
and pln.business_group_id = p_business_group_id
and p_effective_date between effective_start_date and effective_end_date
and pl_stat_cd = 'A';
select plip.plip_id
from ben_plip_f plip
where plip.pl_id = l_pl_id
and plip.pgm_id = l_pgm_id
and plip.business_group_id = p_business_group_id
and p_effective_date between effective_start_date and effective_end_date;
Select opt_id
from ben_opt_f opt
where opt.short_code = p_option_code
and opt.business_group_id = p_business_group_id
and p_effective_date between effective_start_date and effective_end_date;
select oipl_id
from ben_oipl_f
where pl_id = l_pl_id
and opt_id = l_opt_id
and business_group_id = p_business_group_id
and p_effective_date between effective_start_date and effective_end_date;
select elig_per_elctbl_chc_id,
pil.per_in_ler_id
from ben_elig_per_ELCTBL_chc chc ,
ben_per_in_ler pil
where chc.pgm_id = l_pgm_id
and chc.pl_typ_id = l_pl_typ_id
and chc.pl_id = l_pl_id
and chc.plip_id = l_plip_id
and chc.ptip_id = l_ptip_id
and chc.oipl_id = l_oipl_id
and pil.per_in_ler_id = chc.per_in_ler_id
and pil.ler_id = l_ler_id
and pil.person_id = p_person_id;
select elig_per_elctbl_chc_id,
pil.per_in_ler_id
from ben_elig_per_ELCTBL_chc chc ,
ben_per_in_ler pil
where chc.pgm_id = l_pgm_id
and chc.pl_typ_id = l_pl_typ_id
and chc.pl_id = l_pl_id
and chc.plip_id = l_plip_id
and chc.ptip_id = l_ptip_id
and pil.per_in_ler_id = chc.per_in_ler_id
and pil.ler_id = l_ler_id
and pil.person_id = p_person_id;
select 1
from ben_prtt_enrt_rslt_f prt
where prt.person_id = p_person_id
and pgm_id = l_pgm_id;
select object_version_number
from pay_element_entries_f
where element_entry_id = p_element_entry_id
and effective_start_date < p_effective_date
order by effective_start_date desc;
SELECT eef_new.element_entry_id,
eef_new.object_version_number,
eef_new.element_type_id
FROM pay_element_entries_f eef_new,
pay_element_types_f elt_new
WHERE eef_new.assignment_id = p_assignment_id
and elt_new.element_type_id = eef_new.element_type_id
AND eef_new.effective_start_date BETWEEN elt_new.effective_start_date AND elt_new.effective_end_date
and eef_new.effective_start_date = trunc(p_effective_date)
and eef_new.effective_end_date = hr_api.g_eot
AND upper(pqp_fedhr_uspay_int_utils.return_old_element_name(elt_new.element_name,
p_business_group_id,
eef_new.effective_start_date))
IN ('HEALTH BENEFITS PRE TAX'
);
select input_value_id
from pay_input_values_f
where element_type_id = l_element_type_id
and name = 'Temps Total Cost'
and trunc(p_effective_date) between effective_start_date and effective_end_date;
select national_identifier,
--Bug # 9329643
employee_number
from per_all_people_f
where person_id = p_person_id
and trunc(p_effective_date) between effective_start_date and effective_end_date;
,p_datetrack_mode => 'INSERT'
,p_suspend_flag => l_suspend_flag
,p_effective_start_date => l_esd
,p_effective_end_date => l_eed
,p_object_version_number => l_ovn
,p_prtt_enrt_interim_id => l_prtt_enrt_interim_id
,p_business_group_id => p_business_group_id
,p_dpnt_actn_warning => l_Boolean
,p_bnf_actn_warning => l_Boolean
,p_ctfn_actn_warning => l_Boolean
);
py_element_entry_api.delete_element_entry(
p_datetrack_delete_mode => hr_api.g_zap,
p_effective_date => p_effective_date,
p_element_entry_id => p_element_entry_id,
p_object_version_number => l_object_version_number,
p_effective_start_date => l_eff_start_date,
p_effective_end_date => l_eff_end_date,
p_delete_warning => l_del_warning);
py_element_entry_api.delete_element_entry(
p_datetrack_delete_mode => hr_api.g_delete,
p_effective_date => (p_effective_date - 1),
p_element_entry_id => p_element_entry_id,
p_object_version_number => l_object_version_number,
p_effective_start_date => l_eff_start_date,
p_effective_end_date => l_eff_end_date,
p_delete_warning => l_del_warning);
py_element_entry_api.update_element_entry(
p_datetrack_update_mode => hr_api.g_correction
,p_effective_date => p_effective_date
,p_business_group_id => p_business_group_id
,p_element_entry_id => get_new_element_details.element_entry_id
,p_object_version_number => get_new_element_details.object_version_number
,p_input_value_id3 => l_input_val_id3
,p_entry_value3 => p_temps_cost
,p_effective_start_date => l_eff_start_date
,p_effective_end_date => l_eff_end_date
,p_update_warning => l_del_warning
);
select pgm.pgm_id
from ben_pgm_f pgm
where pgm.name = 'Federal Thrift Savings Plan (TSP)'
and pgm.business_group_id = p_business_group_id;
select plt.pl_typ_id
from ben_pl_typ_f plt
where plt.name = 'Savings Plan'
and plt.business_group_id = p_business_group_id;
select ptip_id
from ben_ptip_f
where pl_typ_id = l_pl_typ_id
and pgm_id = l_pgm_id;
select pln.pl_id pl_id
from ben_pl_f pln
where pln.name = 'TSP'
and pln.business_group_id = p_business_group_id;
select plip.plip_id
from ben_plip_f plip
where plip.pl_id = l_pl_id
and plip.pgm_id = l_pgm_id
and plip.business_group_id = p_business_group_id;
Select opt_id
from ben_opt_f opt
where name = p_opt_name
and opt.business_group_id = p_business_group_id;
select oipl_id
from ben_oipl_f
where pl_id = l_pl_id
and opt_id = l_opt_id
and business_group_id = p_business_group_id;
select elig_per_elctbl_chc_id,
pil.per_in_ler_id
from ben_elig_per_ELCTBL_chc chc ,
ben_per_in_ler pil
where chc.pgm_id = l_pgm_id
and chc.pl_typ_id = l_pl_typ_id
and chc.pl_id = l_pl_id
and chc.plip_id = l_plip_id
and chc.ptip_id = l_ptip_id
and chc.oipl_id = l_oipl_id
and pil.per_in_ler_id = chc.per_in_ler_id
--and pil.ler_id = l_ler_id
and pil.person_id = p_person_id;
select enrt_rt_id
from ben_enrt_rt
where elig_per_elctbl_chc_id = l_elig_per_elctbl_chc_id;
select 1
from ben_prtt_enrt_rslt_f
where person_id = p_person_id
and pgm_id = l_pgm_id;
select national_identifier,
employee_number
from per_all_people_f
where person_id = p_person_id
and trunc(p_effective_date) between effective_start_date and effective_end_date;
,p_datetrack_mode => 'INSERT'
,p_suspend_flag => l_suspend_flag
,p_effective_start_date => l_esd
,p_effective_end_date => l_eed
,p_object_version_number => l_ovn
,p_prtt_enrt_interim_id => l_prtt_enrt_interim_id
,p_business_group_id => p_business_group_id
,p_dpnt_actn_warning => l_Boolean
,p_bnf_actn_warning => l_Boolean
,p_ctfn_actn_warning => l_Boolean
);
select pgm.pgm_id
from ben_pgm_f pgm
where pgm.name = 'Federal Thrift Savings Plan (TSP) Catch Up Contributions'
and pgm.business_group_id = p_business_group_id;
select plt.pl_typ_id
from ben_pl_typ_f plt
where plt.name = 'Savings Plan'
and plt.business_group_id = p_business_group_id;
select ptip_id
from ben_ptip_f
where pl_typ_id = l_pl_typ_id
and pgm_id = l_pgm_id;
select pln.pl_id pl_id
from ben_pl_f pln
where pln.name = 'TSP Catch Up'
and pln.business_group_id = p_business_group_id;
select plip.plip_id
from ben_plip_f plip
where plip.pl_id = l_pl_id
and plip.pgm_id = l_pgm_id
and plip.business_group_id = p_business_group_id;
Select opt_id
from ben_opt_f opt
where name = p_opt_name
and opt.business_group_id = p_business_group_id;
select oipl_id
from ben_oipl_f
where pl_id = l_pl_id
and opt_id = l_opt_id
and business_group_id = p_business_group_id;
select elig_per_elctbl_chc_id,
pil.per_in_ler_id
from ben_elig_per_ELCTBL_chc chc ,
ben_per_in_ler pil
where chc.pgm_id = l_pgm_id
and chc.pl_typ_id = l_pl_typ_id
and chc.pl_id = l_pl_id
and chc.plip_id = l_plip_id
and chc.ptip_id = l_ptip_id
and chc.oipl_id = l_oipl_id
and pil.per_in_ler_id = chc.per_in_ler_id
and pil.person_id = p_person_id;
select enrt_rt_id
from ben_enrt_rt
where elig_per_elctbl_chc_id = l_elig_per_elctbl_chc_id;
select 1
from ben_prtt_enrt_rslt_f
where person_id = p_person_id
and pgm_id = l_pgm_id;
select national_identifier,
employee_number
from per_all_people_f
where person_id = p_person_id
and trunc(p_effective_date) between effective_start_date and effective_end_date;
,p_datetrack_mode => 'INSERT'
,p_suspend_flag => l_suspend_flag
,p_effective_start_date => l_esd
,p_effective_end_date => l_eed
,p_object_version_number => l_ovn
,p_prtt_enrt_interim_id => l_prtt_enrt_interim_id
,p_business_group_id => p_business_group_id
,p_dpnt_actn_warning => l_Boolean
,p_bnf_actn_warning => l_Boolean
,p_ctfn_actn_warning => l_Boolean
);