The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
group_per_in_ler_id,
group_pl_id,
group_oipl_id,
grp.approval_cd,
access_cd,
grp.object_version_number
from
ben_cwb_person_groups grp,
ben_cwb_group_hrchy hrchy,
ben_cwb_group_hrchy hrchy_mgr
where
hrchy.mgr_per_in_ler_id = p_group_per_in_ler_id
and hrchy.lvl_num>0
and hrchy.emp_per_in_ler_id=hrchy_mgr.mgr_per_in_ler_id
and hrchy_mgr.lvl_num=0
and grp.group_per_in_ler_id=hrchy_mgr.mgr_per_in_ler_id
and grp.group_pl_id = p_group_pl_id
and grp.group_oipl_id = p_group_oipl_id
and ((nvl(grp.approval_cd,'NULL') not in ('AP','PR')));
select
object_version_number ovn,
status_cd status
from ben_cwb_person_tasks
where group_per_in_ler_id = c_group_per_in_ler_id
and task_id = c_task_id
and group_pl_id=p_group_pl_id;
SELECT cwb_wksht_grp_id
from
ben_cwb_wksht_grp grp,
ben_cwb_person_tasks tsk
where grp.wksht_grp_cd = 'APPR'
and tsk.group_per_in_ler_id= c_group_per_in_ler_id
and tsk.task_id= grp.cwb_wksht_grp_id;
BEN_CWB_PERSON_GROUPS_API.update_group_budget
(
p_validate => false
,p_group_per_in_ler_id => l_group_per_in_ler_id
,p_group_pl_id => l_group_pl_id
,p_group_oipl_id => l_group_oipl_id
,p_access_cd => 'RO'
,p_approval_cd => 'AP'
,p_approval_date => p_effective_date
,p_approval_comments => ' '
,p_object_version_number => l_object_version_number
);
BEN_CWB_PERSON_GROUPS_API.update_group_budget
(
p_validate => false
,p_group_per_in_ler_id => l_group_per_in_ler_id
,p_group_pl_id => l_group_pl_id
,p_group_oipl_id => l_group_oipl_id
,p_approval_cd => 'AP'
,p_approval_date => p_effective_date
,p_approval_comments => ' '
,p_object_version_number => l_object_version_number
);
-- Update task status to complete for all lower managers
open getApprTaskId(l_group_per_in_ler_id);
BEN_CWB_PERSON_TASKS_API.update_person_task
(
p_validate => false
,p_group_per_in_ler_id => l_group_per_in_ler_id
,p_group_pl_id => l_group_pl_id
,p_task_id => l_task_id
,p_status_cd => 'CO'
,p_object_version_number => l_object_version_number_task
,p_task_last_update_date => p_effective_date
,p_task_last_update_by => p_login_person_id
);
select approval_cd
from ben_cwb_person_groups
where group_per_in_ler_id= p_per_in_ler_id;
select
decode(p_ben_cwb_profile_disp_name,'FN',full_name,'CN',custom_name,brief_name) manager_name
from ben_cwb_person_info
where ben_cwb_person_info.group_per_in_ler_id = c_per_in_ler_id;
select
decode(p_ben_cwb_profile_disp_name,'FN',full_name,'CN',custom_name,brief_name) manager_name ,
person_id
from ben_cwb_group_hrchy,
ben_cwb_person_info
where ben_cwb_group_hrchy.emp_per_in_ler_id = c_per_in_ler_id
and lvl_num=1
and ben_cwb_person_info.group_per_in_ler_id = ben_cwb_group_hrchy.mgr_per_in_ler_id;
select mgr_per_in_ler_id
from
ben_cwb_group_hrchy,
ben_cwb_person_groups
where
ben_cwb_group_hrchy.emp_per_in_ler_id = p_per_in_ler_id
and ben_cwb_group_hrchy.mgr_per_in_ler_id = ben_cwb_person_groups.group_per_in_ler_id
and group_oipl_id=-1
and ((approval_cd is null ) or (approval_cd = 'RJ' ))
and lvl_num <> -1
order by lvl_num;