APPS.BEN_POPULATE_RBV dependencies on BEN_PER_CM_F

Line 22: Type t_pcm_tab is table of ben_per_cm_f%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: --
26: PROCEDURE write_ppl_rbvs

Line 2596: insert into ben_per_cm_f_rbv

2592: --
2593: for elenum in p_pcm_set.first ..p_pcm_set.last
2594: loop
2595: --
2596: insert into ben_per_cm_f_rbv
2597: ( per_cm_id,
2598: effective_start_date,
2599: effective_end_date,
2600: lf_evt_ocrd_dt,

Line 3362: from ben_per_cm_f pcm

3358: ,c_lu_dt date
3359: )
3360: is
3361: select pcm.*
3362: from ben_per_cm_f pcm
3363: where pcm.person_id = c_per_id
3364: and pcm.last_update_date
3365: between c_lu_dt and sysdate
3366: order by pcm.per_cm_id;

Line 4033: l_table_name := 'BEN_PER_CM_F_RBV';

4029: );
4030: --
4031: -- Communications
4032: --
4033: l_table_name := 'BEN_PER_CM_F_RBV';
4034: l_elenum := 0;
4035: --
4036: for row in c_pcmrbv
4037: (c_per_id => l_person_id