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_PD_RATE_AND_CVG_MODULE dependencies on BEN_BNFT_VRBL_RT_RL_F

Line 2550: -- START OF BEN_BNFT_VRBL_RT_RL_F ----------------------

2546: ---------------------------------------------------------------
2547: -- END OF BEN_CVG_AMT_CALC_MTHD_F ----------------------
2548: ---------------------------------------------------------------
2549: ---------------------------------------------------------------
2550: -- START OF BEN_BNFT_VRBL_RT_RL_F ----------------------
2551: ---------------------------------------------------------------
2552: cursor c_brr_from_parent(c_CVG_AMT_CALC_MTHD_ID number) is
2553: select bnft_vrbl_rt_rl_id
2554: from BEN_BNFT_VRBL_RT_RL_F

Line 2554: from BEN_BNFT_VRBL_RT_RL_F

2550: -- START OF BEN_BNFT_VRBL_RT_RL_F ----------------------
2551: ---------------------------------------------------------------
2552: cursor c_brr_from_parent(c_CVG_AMT_CALC_MTHD_ID number) is
2553: select bnft_vrbl_rt_rl_id
2554: from BEN_BNFT_VRBL_RT_RL_F
2555: where CVG_AMT_CALC_MTHD_ID = c_CVG_AMT_CALC_MTHD_ID ;
2556: --
2557: cursor c_brr(c_bnft_vrbl_rt_rl_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
2558: select brr.*

Line 2559: from BEN_BNFT_VRBL_RT_RL_F brr

2555: where CVG_AMT_CALC_MTHD_ID = c_CVG_AMT_CALC_MTHD_ID ;
2556: --
2557: cursor c_brr(c_bnft_vrbl_rt_rl_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
2558: select brr.*
2559: from BEN_BNFT_VRBL_RT_RL_F brr
2560: where brr.bnft_vrbl_rt_rl_id = c_bnft_vrbl_rt_rl_id
2561: -- and brr.business_group_id = p_business_group_id
2562: and not exists (
2563: select /* */ null

Line 2570: -- and trt.where_clause = 'BEN_BNFT_VRBL_RT_RL_F'

2566: where copy_entity_txn_id = p_copy_entity_txn_id
2567: -- and trt.table_route_id = cpe.table_route_id
2568: and ( -- c_mirror_src_entity_result_id is null or
2569: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
2570: -- and trt.where_clause = 'BEN_BNFT_VRBL_RT_RL_F'
2571: and cpe.table_alias = c_table_alias
2572: and information1 = c_bnft_vrbl_rt_rl_id
2573: -- and information4 = brr.business_group_id
2574: and information2 = brr.effective_start_date

Line 2579: -- END OF BEN_BNFT_VRBL_RT_RL_F ----------------------

2575: and information3 = brr.effective_end_date);
2576: l_bnft_vrbl_rt_rl_id number(15);
2577: l_out_brr_result_id number(15);
2578: ---------------------------------------------------------------
2579: -- END OF BEN_BNFT_VRBL_RT_RL_F ----------------------
2580: ---------------------------------------------------------------
2581: ---------------------------------------------------------------
2582: -- START OF BEN_BNFT_VRBL_RT_F ----------------------
2583: ---------------------------------------------------------------

Line 2861: -- START OF BEN_BNFT_VRBL_RT_RL_F ----------------------

2857:
2858: end loop;
2859: --
2860: ---------------------------------------------------------------
2861: -- START OF BEN_BNFT_VRBL_RT_RL_F ----------------------
2862: ---------------------------------------------------------------
2863: --
2864: for l_parent_rec in c_brr_from_parent(l_CVG_AMT_CALC_MTHD_ID) loop
2865: --

Line 2980: -- END OF BEN_BNFT_VRBL_RT_RL_F ----------------------

2976: end loop;
2977: --
2978: end loop;
2979: ---------------------------------------------------------------
2980: -- END OF BEN_BNFT_VRBL_RT_RL_F ----------------------
2981: ---------------------------------------------------------------
2982: ---------------------------------------------------------------
2983: -- START OF BEN_BNFT_VRBL_RT_F ----------------------
2984: ---------------------------------------------------------------