APPS.BEN_CWB_RSGN_EMP dependencies on BEN_CWB_GROUP_HRCHY

Line 683: from ben_cwb_group_hrchy hrchy,

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

Line 695: from ben_cwb_group_hrchy hrchy,

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

Line 707: from ben_cwb_group_hrchy hrchy,

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

Line 714: from ben_cwb_group_hrchy h1

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