APPS.BEN_CWB_RSGN_EMP dependencies on BEN_PER_IN_LER

Line 56: FROM ben_per_in_ler pil,

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

Line 481: from ben_per_in_ler

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

Line 685: ben_per_in_ler pil

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

Line 697: ben_per_in_ler pil

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

Line 709: ben_per_in_ler pil

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