APPS.BEN_CWB_RSGN_EMP dependencies on BEN_PER_IN_LER

Line 55: FROM ben_per_in_ler pil,

51: CURSOR c11
52: IS
53: SELECT nvl(dsgn.wthn_yr_start_dt,dsgn.yr_perd_start_dt)||' - '||
54: nvl(dsgn.wthn_yr_end_dt,dsgn.yr_perd_end_dt) forPeriod
55: FROM ben_per_in_ler pil,
56: ben_cwb_pl_dsgn dsgn
57: WHERE pil.per_in_ler_id = p_group_per_in_ler_id
58: AND pil.group_pl_id = dsgn.group_pl_id
59: AND pil.lf_evt_ocrd_dt = dsgn.lf_evt_ocrd_dt

Line 480: from ben_per_in_ler

476: and transaction_type = 'CWBEMPRSGN';
477:
478: cursor getObjVerNum(c_per_in_ler_id in number) is
479: select object_version_number
480: from ben_per_in_ler
481: where per_in_ler_id = c_per_in_ler_id;
482:
483: cursor get_approval_cd(c_per_in_ler_id in number, c_pl_id in number) is
484: select approval_cd

Line 684: ben_per_in_ler pil

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
688: and hrchy.mgr_per_in_ler_id = pil.per_in_ler_id;

Line 696: ben_per_in_ler pil

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
700: and hrchy.mgr_per_in_ler_id <>hrchy.emp_per_in_ler_id

Line 708: ben_per_in_ler pil

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
712: and emp_per_in_ler_id=p_prop_ws_mgr_per_in_ler_id