APPS.BEN_CWB_APPROVALS dependencies on BEN_CWB_PERSON_INFO

Line 200: from ben_cwb_person_info

196:
197: cursor get_name(c_per_in_ler_id in number) is
198: select
199: decode(p_ben_cwb_profile_disp_name,'FN',full_name,'CN',custom_name,brief_name) manager_name
200: from ben_cwb_person_info
201: where ben_cwb_person_info.group_per_in_ler_id = c_per_in_ler_id;
202:
203: cursor get_manager_name(c_per_in_ler_id in number) is
204: select

Line 201: where ben_cwb_person_info.group_per_in_ler_id = c_per_in_ler_id;

197: cursor get_name(c_per_in_ler_id in number) is
198: select
199: decode(p_ben_cwb_profile_disp_name,'FN',full_name,'CN',custom_name,brief_name) manager_name
200: from ben_cwb_person_info
201: where ben_cwb_person_info.group_per_in_ler_id = c_per_in_ler_id;
202:
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 ,

Line 208: ben_cwb_person_info

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;
212:

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