APPS.BEN_CWB_APPROVALS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 39

        	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')));

Line: 61

            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;

Line: 70

      		 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;

Line: 107

				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
				);

Line: 120

				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
				);

Line: 135

				-- Update task status to complete for all lower managers


				open getApprTaskId(l_group_per_in_ler_id);

Line: 152

					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
					);

Line: 193

		select approval_cd
		from ben_cwb_person_groups
		where group_per_in_ler_id= p_per_in_ler_id;

Line: 198

		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;

Line: 204

		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;

Line: 214

		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;