APPS.BEN_CWB_APPROVALS dependencies on BEN_CWB_GROUP_HRCHY

Line 48: ben_cwb_group_hrchy hrchy,

44: access_cd,
45: grp.object_version_number
46: from
47: ben_cwb_person_groups grp,
48: ben_cwb_group_hrchy hrchy,
49: ben_cwb_group_hrchy hrchy_mgr
50: where
51: hrchy.mgr_per_in_ler_id = p_group_per_in_ler_id
52: and hrchy.lvl_num>0

Line 49: ben_cwb_group_hrchy hrchy_mgr

45: grp.object_version_number
46: from
47: ben_cwb_person_groups grp,
48: ben_cwb_group_hrchy hrchy,
49: ben_cwb_group_hrchy hrchy_mgr
50: where
51: hrchy.mgr_per_in_ler_id = p_group_per_in_ler_id
52: and hrchy.lvl_num>0
53: and hrchy.emp_per_in_ler_id=hrchy_mgr.mgr_per_in_ler_id

Line 207: from ben_cwb_group_hrchy,

203: cursor get_manager_name(c_per_in_ler_id in number) is
204: select
205: decode(p_ben_cwb_profile_disp_name,'FN',full_name,'CN',custom_name,brief_name) manager_name ,
206: person_id
207: from ben_cwb_group_hrchy,
208: ben_cwb_person_info
209: where ben_cwb_group_hrchy.emp_per_in_ler_id = c_per_in_ler_id
210: and lvl_num=1
211: and ben_cwb_person_info.group_per_in_ler_id = ben_cwb_group_hrchy.mgr_per_in_ler_id;

Line 209: where ben_cwb_group_hrchy.emp_per_in_ler_id = c_per_in_ler_id

205: decode(p_ben_cwb_profile_disp_name,'FN',full_name,'CN',custom_name,brief_name) manager_name ,
206: person_id
207: from ben_cwb_group_hrchy,
208: ben_cwb_person_info
209: where ben_cwb_group_hrchy.emp_per_in_ler_id = c_per_in_ler_id
210: and lvl_num=1
211: and ben_cwb_person_info.group_per_in_ler_id = ben_cwb_group_hrchy.mgr_per_in_ler_id;
212:
213: cursor get_next_approver is

Line 211: and ben_cwb_person_info.group_per_in_ler_id = ben_cwb_group_hrchy.mgr_per_in_ler_id;

207: from ben_cwb_group_hrchy,
208: ben_cwb_person_info
209: where ben_cwb_group_hrchy.emp_per_in_ler_id = c_per_in_ler_id
210: and lvl_num=1
211: and ben_cwb_person_info.group_per_in_ler_id = ben_cwb_group_hrchy.mgr_per_in_ler_id;
212:
213: cursor get_next_approver is
214: select mgr_per_in_ler_id
215: from

Line 216: ben_cwb_group_hrchy,

212:
213: cursor get_next_approver is
214: select mgr_per_in_ler_id
215: from
216: ben_cwb_group_hrchy,
217: ben_cwb_person_groups
218: where
219: ben_cwb_group_hrchy.emp_per_in_ler_id = p_per_in_ler_id
220: and ben_cwb_group_hrchy.mgr_per_in_ler_id = ben_cwb_person_groups.group_per_in_ler_id

Line 219: ben_cwb_group_hrchy.emp_per_in_ler_id = p_per_in_ler_id

215: from
216: ben_cwb_group_hrchy,
217: ben_cwb_person_groups
218: where
219: ben_cwb_group_hrchy.emp_per_in_ler_id = p_per_in_ler_id
220: and ben_cwb_group_hrchy.mgr_per_in_ler_id = ben_cwb_person_groups.group_per_in_ler_id
221: and group_oipl_id=-1
222: and ((approval_cd is null ) or (approval_cd = 'RJ' ))
223: and lvl_num <> -1

Line 220: and ben_cwb_group_hrchy.mgr_per_in_ler_id = ben_cwb_person_groups.group_per_in_ler_id

216: ben_cwb_group_hrchy,
217: ben_cwb_person_groups
218: where
219: ben_cwb_group_hrchy.emp_per_in_ler_id = p_per_in_ler_id
220: and ben_cwb_group_hrchy.mgr_per_in_ler_id = ben_cwb_person_groups.group_per_in_ler_id
221: and group_oipl_id=-1
222: and ((approval_cd is null ) or (approval_cd = 'RJ' ))
223: and lvl_num <> -1
224: order by lvl_num;