APPS.BEN_CWB_RSGN_EMP dependencies on BEN_CWB_GROUP_HRCHY

Line 684: from ben_cwb_group_hrchy hrchy,

680: cursor approver_hrchy(c_per_in_ler_id in number) is
681:
682: select pil.person_id , pil.per_in_ler_id
683:
684: from ben_cwb_group_hrchy hrchy,
685: ben_per_in_ler pil
686: where hrchy.emp_per_in_ler_id = c_per_in_ler_id
687: --and hrchy.mgr_per_in_ler_id <> hrchy.emp_per_in_ler_id
688: and hrchy.lvl_num <> 0

Line 696: from ben_cwb_group_hrchy hrchy,

692: cursor get_manager_id_from_pil(c_per_in_ler_id in number) is
693:
694: select pil.person_id
695:
696: from ben_cwb_group_hrchy hrchy,
697: ben_per_in_ler pil
698:
699: where
700: hrchy.emp_per_in_ler_id =c_per_in_ler_id

Line 708: from ben_cwb_group_hrchy hrchy,

704:
705:
706: cursor get_top_person_id(c_plan_id in number) is
707: select distinct pil.person_id
708: from ben_cwb_group_hrchy hrchy,
709: ben_per_in_ler pil
710: where
711: pil.group_pl_id = c_plan_id
712: and pil.per_in_ler_id= hrchy.mgr_per_in_ler_id

Line 715: from ben_cwb_group_hrchy h1

711: pil.group_pl_id = c_plan_id
712: and pil.per_in_ler_id= hrchy.mgr_per_in_ler_id
713: and emp_per_in_ler_id=p_prop_ws_mgr_per_in_ler_id
714: and hrchy.lvl_num = (select max(h1.lvl_num)
715: from ben_cwb_group_hrchy h1
716: where h1.emp_per_in_ler_id = p_prop_ws_mgr_per_in_ler_id
717: );
718:
719: l_person_id number;