[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select asg.assignment_id
into l_assignment_id
from ben_per_in_ler pil,per_all_assignments_f asg
where p_effective_date between asg.effective_start_date and asg.effective_end_date
and pil.per_in_ler_id = p_per_in_ler_id
and pil.person_id = asg.person_id
and asg.assignment_type = 'E'
and asg.primary_flag ='Y';
select ptnl.ptnl_ler_for_per_id, ptnl.object_version_number
from ben_per_in_ler per
,ben_ptnl_ler_for_per ptnl
where per.per_in_ler_id = cp_per_in_ler_id
and per.ptnl_ler_for_per_id = ptnl.ptnl_ler_for_per_id;
Select legislation_code
from per_business_groups bg, ben_per_in_ler pil
where pil.business_group_id = bg.business_group_id
and pil.per_in_ler_id = p_per_in_ler_id;
Ben_Person_Life_Event_api.UPDATE_PERSON_LIFE_EVENT
(P_PER_IN_LER_ID => P_PER_IN_LER_ID
,P_PER_IN_LER_STAT_CD => 'VOIDD'
,P_PROCD_DT => l_procd_dt
,P_STRTD_DT => l_strtd_dt
,P_VOIDD_DT => l_voidd_dt
,P_OBJECT_VERSION_NUMBER => L_Pil_Ovn
,P_EFFECTIVE_DATE => P_Effective_Date);
ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per
(p_ptnl_ler_for_per_id => l_PTNL_LER_FOR_PER_ID
,p_ptnl_ler_for_per_stat_cd => 'VOIDD'
,p_voidd_dt => p_effective_date
,p_object_version_number => l_PTNL_LER_FOR_PER_OVN
,p_effective_date => p_effective_date);
Ben_Person_Life_Event_api.UPDATE_PERSON_LIFE_EVENT
(P_PER_IN_LER_ID => P_PER_IN_LER_ID
,P_PER_IN_LER_STAT_CD => 'VOIDD'
,P_PROCD_DT => l_procd_dt
,P_STRTD_DT => l_strtd_dt
,P_VOIDD_DT => l_voidd_dt
,P_OBJECT_VERSION_NUMBER => L_Pil_Ovn
,P_EFFECTIVE_DATE => P_Effective_Date);
ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per
(p_ptnl_ler_for_per_id => l_PTNL_LER_FOR_PER_ID
,p_ptnl_ler_for_per_stat_cd => 'VOIDD'
,p_voidd_dt => p_effective_date
,p_object_version_number => l_PTNL_LER_FOR_PER_OVN
,p_effective_date => p_effective_date);
select epe.ELIG_PER_ELCTBL_CHC_ID
into l_electbl_chc_id
from ben_elig_per_elctbl_chc epe, ben_per_in_ler pil
where pil.per_in_ler_id = epe.per_in_ler_id
and pil.per_in_ler_id = p_per_in_ler_id
and pil.per_in_ler_stat_cd = 'STRTD'
and epe.comp_lvl_cd ='OIPL'
and epe.oipl_id = p_oipl_id;
select epe.ELIG_PER_ELCTBL_CHC_ID
into l_electbl_chc_id
from ben_elig_per_elctbl_chc epe, ben_per_in_ler pil
where pil.per_in_ler_id = epe.per_in_ler_id
and pil.per_in_ler_id = p_per_in_ler_id
and pil.per_in_ler_stat_cd = 'STRTD'
and epe.comp_lvl_cd ='PLAN'
and epe.pl_id = p_pl_id;
select sequence,grade_spine_id
into p_step_seq,p_grade_spine_id
from per_spinal_point_steps_f
where p_effective_date between effective_start_date and effective_end_date
and step_id = p_step_id;
Select Sequence, Step_Id
From Per_Spinal_Point_steps_F a
Where Grade_Spine_id = P_Grade_Spine_id
and P_Effective_Date Between Effective_Start_Date and effective_End_Date
and Sequence > P_Seq
Order By Sequence asc;
select step_id
into p_next_step_id
from per_spinal_point_steps_f
where p_effective_date between effective_start_date and effective_end_date
and grade_spine_id = l_grade_spine_id
and sequence = l_dest_step_seq;
select ordr_num
into l_ordr_num
from ben_plip_f
where pgm_id = p_gl_id
and p_effective_date between effective_start_date and effective_end_date
and pl_id = l_pl_id;
select grade_id
from per_all_assignments_f
where assignment_id = p_assignment_id
and l_asg_check_date between effective_start_date and effective_end_date;
select step_id
from per_spinal_point_placements_f
where assignment_id = p_assignment_id
and l_asg_check_date between effective_start_date and effective_end_date;
select step_id,sequence
from per_spinal_point_steps_f
where grade_spine_id = l_grade_spine_id
and p_effective_date between effective_start_date and effective_end_date
and sequence > l_seq
order by sequence;
select grade_spine_id
into l_grade_spine_id
from per_grade_spines_f
where grade_id = p_grade_id
and p_effective_date between effective_start_date and effective_end_date;
select pl_id,ordr_num
from ben_plip_f
where pgm_id = p_gl_id
and p_effective_date between effective_start_date and effective_end_date
and plip_stat_cd ='A'
and ordr_num > l_ordr_num
order by ordr_num;
select plip_id,ordr_num
into l_plip_id,l_ordr_num
from ben_plip_f
where pgm_id = p_gl_id
and p_effective_date between effective_start_date and effective_end_date
and plip_stat_cd ='A'
and pl_id = p_pl_id;
select effective_start_date,effective_end_date,grade_ladder_pgm_id,grade_id,
special_ceiling_step_id,business_group_id
from per_all_assignments_f
where assignment_id = l_assignment_id
and p_effective_date between effective_start_date and effective_end_date;
select step_id,increment_number
into p_emp_step_id,p_num_incr
from per_spinal_point_placements_f
where assignment_id = p_assignment_id
and p_effective_date between effective_start_date and effective_end_date;
select pgm_id
into l_gl_id
from ben_pgm_f
where p_effective_date between effective_start_date and effective_end_date
and pgm_stat_cd ='A' -- active program
and pgm_typ_cd ='GSP' -- context should be GSP
and dflt_pgm_flag = 'Y' -- default
and business_group_id = p_business_group_id;
select enrt_mthd_cd,name,dflt_step_cd,dflt_step_rl
into p_post_style_cd,p_gl_name,p_dflt_step_cd,p_dflt_step_rl
from ben_pgm_f
where pgm_id = p_gl_id
and pgm_stat_cd ='A' -- program should be active
and p_effective_date between effective_start_date and effective_end_date
and pgm_typ_cd ='GSP' ;-- should be Grade ladder
select pev.screen_entry_value
from pay_element_entries_f pee
,pay_element_entry_values_f pev
where pev.element_entry_id = pee.element_entry_id
and p_Effective_Date between pev.Effective_Start_Date and pev.Effective_End_Date
and pee.assignment_id = p_assignment_id
and p_Effective_Date between pee.Effective_Start_Date and pee.Effective_End_Date
and pev.Input_Value_id = l_input_value_id;
Select input_value_id
From Per_Pay_Bases ppb,
Per_All_Assignments_f paf
Where paf.Assignment_Id = p_Assignment_Id
and p_Effective_Date Between Paf.Effective_Start_Date and Paf.Effective_End_Date
and paf.pay_basis_id = ppb.pay_basis_id;
Select DFLT_INPUT_VALUE_ID
from Ben_Pgm_f pgm,
Per_All_Assignments_f paf
Where paf.Assignment_Id = p_Assignment_Id
and p_Effective_Date
Between Paf.Effective_Start_Date and Paf.Effective_End_Date
and paf.GRADE_LADDER_PGM_ID = pgm.pgm_id
and p_Effective_Date
Between pgm.Effective_Start_date and pgm.Effective_End_Date;
Select pqh_gsp_hr_to_stage.get_step_for_oipl(Elctbl.oipl_id, p_effective_date) Step_Id
from Per_all_Assignments_F Asgt,
Ben_Per_In_Ler Pler,
Ben_Ler_F Ler,
Ben_Elig_Per_Elctbl_Chc ELctbl,
Ben_Enrt_Rt Rt
Where Asgt.Assignment_Id = P_Assignment_id
and P_Effective_Date
Between Asgt.Effective_Start_Date
and Asgt.Effective_End_Date
and Pler.Person_id = Asgt.Person_Id
and Pler.Per_In_Ler_Stat_cd = 'STRTD'
and Ler.Ler_id = Pler.Ler_id
and ler.typ_Cd = 'GSP'
and P_Effective_Date
Between ler.Effective_Start_Date
and Ler.Effective_End_Date
and Elctbl.Per_In_Ler_id = Pler.Per_In_ler_id
and Elctbl.Pl_Id = pqh_gsp_hr_to_stage.get_plan_for_grade
(p_grade_id, p_effective_date)
and Elctbl.Oipl_id is NOT NULL
and Rt.ELig_Per_Elctbl_Chc_Id = Elctbl.Elig_Per_Elctbl_Chc_id
and Nvl(rt.ann_Val,0) > P_Cur_Sal
Order by Rt.ann_Val Asc;
select pev.screen_entry_value*l_annualization_factor
from pay_element_entries_f pee
,pay_element_entry_values_f pev
where pev.element_entry_id = pee.element_entry_id
and p_Effective_Date between pev.Effective_Start_Date and pev.Effective_End_Date
and pee.assignment_id = p_assignment_id
and p_Effective_Date between pee.Effective_Start_Date and pee.Effective_End_Date
and pev.Input_Value_id = l_input_value_id;
Select input_value_id,pay_annualization_factor
From Per_Pay_Bases ppb,
Per_All_Assignments_f paf
Where paf.Assignment_Id = p_Assignment_Id
and p_Effective_Date Between Paf.Effective_Start_Date and Paf.Effective_End_Date
and paf.pay_basis_id = ppb.pay_basis_id;
Select DFLT_INPUT_VALUE_ID
from Ben_Pgm_f pgm,
Per_All_Assignments_f paf
Where paf.Assignment_Id = p_Assignment_Id
and p_Effective_Date
Between Paf.Effective_Start_Date and Paf.Effective_End_Date
and paf.GRADE_LADDER_PGM_ID = pgm.pgm_id
and p_Effective_Date
Between pgm.Effective_Start_date and pgm.Effective_End_Date;