APPS.BEN_POPULATE_RBV dependencies on BEN_CWB_MGR_HRCHY

Line 24: Type t_cwbmh_tab is table of ben_cwb_mgr_hrchy%rowtype index by binary_integer;

20: Type t_prv_tab is table of ben_prtt_rt_val%rowtype index by binary_integer;
21: Type t_pen_tab is table of ben_prtt_enrt_rslt_f%rowtype index by binary_integer;
22: Type t_pcm_tab is table of ben_per_cm_f%rowtype index by binary_integer;
23: Type t_bpl_tab is table of ben_bnft_prvdd_ldgr_f%rowtype index by binary_integer;
24: Type t_cwbmh_tab is table of ben_cwb_mgr_hrchy%rowtype index by binary_integer;
25: --
26: PROCEDURE write_ppl_rbvs
27: (p_benefit_action_id in number
28: ,p_person_action_id in number

Line 2870: insert into ben_cwb_mgr_hrchy_rbv

2866: --
2867: for elenum in p_cwbmh_set.first ..p_cwbmh_set.last
2868: loop
2869: --
2870: insert into ben_cwb_mgr_hrchy_rbv
2871: (mgr_elig_per_elctbl_chc_id
2872: ,emp_elig_per_elctbl_chc_id
2873: ,lvl_num
2874: ,last_update_date

Line 3390: ben_cwb_mgr_hrchy cwbmh

3386: is
3387: select cwbmh.*
3388: from ben_elig_per_elctbl_chc epe,
3389: ben_per_in_ler pil,
3390: ben_cwb_mgr_hrchy cwbmh
3391: where pil.person_id = c_per_id
3392: and epe.per_in_ler_id = pil.per_in_ler_id
3393: and epe.elig_per_elctbl_chc_id = cwbmh.emp_elig_per_elctbl_chc_id
3394: and cwbmh.last_update_date

Line 4087: l_table_name := 'BEN_CWB_MGR_HRCHY_RBV';

4083: ,p_person_action_id => p_person_action_id
4084: ,p_bpl_set => l_bpl_set
4085: );
4086: --
4087: l_table_name := 'BEN_CWB_MGR_HRCHY_RBV';
4088: l_elenum := 0;
4089: --
4090: for row in c_cwbmhrbv
4091: (c_per_id => l_person_id