APPS.BEN_POPULATE_RBV dependencies on BEN_PRTT_ENRT_RSLT_F

Line 21: Type t_pen_tab is table of ben_prtt_enrt_rslt_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;
25: --

Line 2409: insert into ben_prtt_enrt_rslt_f_rbv

2405: --
2406: for elenum in p_pen_set.first ..p_pen_set.last
2407: loop
2408: --
2409: insert into ben_prtt_enrt_rslt_f_rbv
2410: ( prtt_enrt_rslt_id,
2411: effective_start_date,
2412: effective_end_date,
2413: business_group_id,

Line 3350: from ben_prtt_enrt_rslt_f pen

3346: ,c_lu_dt date
3347: )
3348: is
3349: select pen.*
3350: from ben_prtt_enrt_rslt_f pen
3351: where pen.person_id = c_per_id
3352: and pen.last_update_date
3353: between c_lu_dt and sysdate
3354: order by pen.prtt_enrt_rslt_id;

Line 4005: l_table_name := 'BEN_PRTT_ENRT_RSLT_F_RBV';

4001: );
4002: --
4003: -- Enrolment results
4004: --
4005: l_table_name := 'BEN_PRTT_ENRT_RSLT_F_RBV';
4006: l_elenum := 0;
4007: --
4008: for row in c_penrbv
4009: (c_per_id => l_person_id