eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_POPULATE_RBV dependencies on BEN_BNFT_PRVDD_LDGR_F

Line 23: Type t_bpl_tab is table of ben_bnft_prvdd_ldgr_f%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
27: (p_benefit_action_id in number

Line 2737: insert into ben_bnft_prvdd_ldgr_f_rbv

2733: --
2734: for elenum in p_bpl_set.first ..p_bpl_set.last
2735: loop
2736: --
2737: insert into ben_bnft_prvdd_ldgr_f_rbv
2738: ( bnft_prvdd_ldgr_id,
2739: effective_start_date,
2740: effective_end_date,
2741: prtt_ro_of_unusd_amt_flag,

Line 3374: from ben_bnft_prvdd_ldgr_f bpl,

3370: ,c_lu_dt date
3371: )
3372: is
3373: select bpl.*
3374: from ben_bnft_prvdd_ldgr_f bpl,
3375: ben_per_in_ler pil
3376: where pil.person_id = c_per_id
3377: and bpl.per_in_ler_id = pil.per_in_ler_id
3378: and bpl.last_update_date