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_F

Line 2582: -- START OF BEN_BNFT_VRBL_RT_F ----------------------

2578: ---------------------------------------------------------------
2579: -- END OF BEN_BNFT_VRBL_RT_RL_F ----------------------
2580: ---------------------------------------------------------------
2581: ---------------------------------------------------------------
2582: -- START OF BEN_BNFT_VRBL_RT_F ----------------------
2583: ---------------------------------------------------------------
2584: cursor c_bvr_from_parent(c_CVG_AMT_CALC_MTHD_ID number) is
2585: select distinct bnft_vrbl_rt_id
2586: from BEN_BNFT_VRBL_RT_F

Line 2586: from BEN_BNFT_VRBL_RT_F

2582: -- START OF BEN_BNFT_VRBL_RT_F ----------------------
2583: ---------------------------------------------------------------
2584: cursor c_bvr_from_parent(c_CVG_AMT_CALC_MTHD_ID number) is
2585: select distinct bnft_vrbl_rt_id
2586: from BEN_BNFT_VRBL_RT_F
2587: where CVG_AMT_CALC_MTHD_ID = c_CVG_AMT_CALC_MTHD_ID ;
2588: --
2589: cursor c_bvr(c_bnft_vrbl_rt_id number,c_mirror_src_entity_result_id number,
2590: c_table_alias varchar2 ) is

Line 2592: from BEN_BNFT_VRBL_RT_F bvr

2588: --
2589: cursor c_bvr(c_bnft_vrbl_rt_id number,c_mirror_src_entity_result_id number,
2590: c_table_alias varchar2 ) is
2591: select bvr.*
2592: from BEN_BNFT_VRBL_RT_F bvr
2593: where bvr.bnft_vrbl_rt_id = c_bnft_vrbl_rt_id
2594: -- and bvr.business_group_id = p_business_group_id
2595: and not exists (
2596: select /* */ null

Line 2603: -- and trt.where_clause = 'BEN_BNFT_VRBL_RT_F'

2599: where copy_entity_txn_id = p_copy_entity_txn_id
2600: -- and trt.table_route_id = cpe.table_route_id
2601: and ( -- c_mirror_src_entity_result_id is null or
2602: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
2603: -- and trt.where_clause = 'BEN_BNFT_VRBL_RT_F'
2604: and cpe.table_alias = c_table_alias
2605: and information1 = c_bnft_vrbl_rt_id
2606: -- and information4 = bvr.business_group_id
2607: and information2 = bvr.effective_start_date

Line 2617: -- and trt.where_clause = 'BEN_BNFT_VRBL_RT_F'

2613: -- pqh_table_route trt
2614: where copy_entity_txn_id = p_copy_entity_txn_id
2615: -- and trt.table_route_id = cpe.table_route_id
2616: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
2617: -- and trt.where_clause = 'BEN_BNFT_VRBL_RT_F'
2618: and cpe.table_alias = c_table_alias
2619: and information1 = c_bnft_vrbl_rt_id
2620: -- and information4 = p_business_group_id
2621: ;

Line 2627: -- END OF BEN_BNFT_VRBL_RT_F ----------------------

2623:
2624: l_bnft_vrbl_rt_id number(15);
2625: l_out_bvr_result_id number(15);
2626: ---------------------------------------------------------------
2627: -- END OF BEN_BNFT_VRBL_RT_F ----------------------
2628: ---------------------------------------------------------------
2629: begin
2630: l_number_of_copies := p_number_of_copies ;
2631: ---------------------------------------------------------------

Line 2983: -- START OF BEN_BNFT_VRBL_RT_F ----------------------

2979: ---------------------------------------------------------------
2980: -- END OF BEN_BNFT_VRBL_RT_RL_F ----------------------
2981: ---------------------------------------------------------------
2982: ---------------------------------------------------------------
2983: -- START OF BEN_BNFT_VRBL_RT_F ----------------------
2984: ---------------------------------------------------------------
2985: --
2986: for l_parent_rec in c_bvr_from_parent(l_CVG_AMT_CALC_MTHD_ID) loop
2987: --

Line 3017: p_parent_entity_result_id => null, -- Hide BEN_BNFT_VRBL_RT_F for HGrid

3013: p_copy_entity_result_id => l_copy_entity_result_id,
3014: p_copy_entity_txn_id => p_copy_entity_txn_id,
3015: p_result_type_cd => l_result_type_cd,
3016: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
3017: p_parent_entity_result_id => null, -- Hide BEN_BNFT_VRBL_RT_F for HGrid
3018: p_number_of_copies => l_number_of_copies,
3019: p_table_route_id => l_table_route_id,
3020: P_TABLE_ALIAS => 'BVR1',
3021: p_information1 => l_bvr_rec.bnft_vrbl_rt_id,

Line 3099: -- END OF BEN_BNFT_VRBL_RT_F ----------------------

3095: end loop;
3096: --
3097: end loop;
3098: ---------------------------------------------------------------
3099: -- END OF BEN_BNFT_VRBL_RT_F ----------------------
3100: ---------------------------------------------------------------
3101: end loop;
3102: ---------------------------------------------------------------
3103: -- END OF BEN_CVG_AMT_CALC_MTHD_F ----------------------