APPS.BEN_POPULATE_RBV dependencies on BEN_PRTT_RT_VAL

Line 20: Type t_prv_tab is table of ben_prtt_rt_val%rowtype index by binary_integer;

16: Type t_pdp_tab is table of ben_elig_cvrd_dpnt_f%rowtype index by binary_integer;
17: Type t_enb_tab is table of ben_enrt_bnft%rowtype index by binary_integer;
18: Type t_epr_tab is table of ben_enrt_prem%rowtype index by binary_integer;
19: Type t_ecr_tab is table of ben_enrt_rt%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;

Line 2254: insert into ben_prtt_rt_val_rbv

2250: --
2251: for elenum in p_prv_set.first ..p_prv_set.last
2252: loop
2253: --
2254: insert into ben_prtt_rt_val_rbv
2255: ( prtt_rt_val_id,
2256: rt_strt_dt,
2257: rt_end_dt,
2258: rt_typ_cd,

Line 3336: from ben_prtt_rt_val prv,

3332: ,c_lu_dt date
3333: )
3334: is
3335: select prv.*
3336: from ben_prtt_rt_val prv,
3337: ben_per_in_ler pil
3338: where pil.person_id = c_per_id
3339: and prv.per_in_ler_id = pil.per_in_ler_id
3340: and prv.last_update_date

Line 3970: l_table_name := 'BEN_PRTT_RT_VAL_RBV';

3966: );
3967: --
3968: -- Participant rate values
3969: --
3970: l_table_name := 'BEN_PRTT_RT_VAL_RBV';
3971: l_elenum := 0;
3972: --
3973: for row in c_prvrbv
3974: (c_per_id => l_person_id