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_COMP_LVL_RT_F

Line 5959: -- START OF BEN_COMP_LVL_RT_F ----------------------

5955: ---------------------------------------------------------------
5956: -- END OF BEN_CMBN_AGE_LOS_RT_F ----------------------
5957: ---------------------------------------------------------------
5958: ---------------------------------------------------------------
5959: -- START OF BEN_COMP_LVL_RT_F ----------------------
5960: ---------------------------------------------------------------
5961: cursor c_clr_from_parent(c_VRBL_RT_PRFL_ID number) is
5962: select distinct comp_lvl_rt_id
5963: from BEN_COMP_LVL_RT_F

Line 5963: from BEN_COMP_LVL_RT_F

5959: -- START OF BEN_COMP_LVL_RT_F ----------------------
5960: ---------------------------------------------------------------
5961: cursor c_clr_from_parent(c_VRBL_RT_PRFL_ID number) is
5962: select distinct comp_lvl_rt_id
5963: from BEN_COMP_LVL_RT_F
5964: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
5965: --
5966: cursor c_clr(c_comp_lvl_rt_id number,c_mirror_src_entity_result_id number,
5967: c_table_alias varchar2 ) is

Line 5969: from BEN_COMP_LVL_RT_F clr

5965: --
5966: cursor c_clr(c_comp_lvl_rt_id number,c_mirror_src_entity_result_id number,
5967: c_table_alias varchar2 ) is
5968: select clr.*
5969: from BEN_COMP_LVL_RT_F clr
5970: where clr.comp_lvl_rt_id = c_comp_lvl_rt_id
5971: -- and clr.business_group_id = p_business_group_id
5972: and not exists (
5973: select /* */ null

Line 5980: -- and trt.where_clause = 'BEN_COMP_LVL_RT_F'

5976: where copy_entity_txn_id = p_copy_entity_txn_id
5977: -- and trt.table_route_id = cpe.table_route_id
5978: and ( -- c_mirror_src_entity_result_id is null or
5979: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
5980: -- and trt.where_clause = 'BEN_COMP_LVL_RT_F'
5981: and cpe.table_alias = c_table_alias
5982: and information1 = c_comp_lvl_rt_id
5983: -- and information4 = clr.business_group_id
5984: and information2 = clr.effective_start_date

Line 5996: -- and trt.where_clause = 'BEN_COMP_LVL_RT_F'

5992: -- pqh_table_route trt
5993: where copy_entity_txn_id = p_copy_entity_txn_id
5994: -- and trt.table_route_id = cpe.table_route_id
5995: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
5996: -- and trt.where_clause = 'BEN_COMP_LVL_RT_F'
5997: and cpe.table_alias = c_table_alias
5998: and information1 = c_comp_lvl_rt_id
5999: -- and information4 = p_business_group_id
6000: ;

Line 6002: -- END OF BEN_COMP_LVL_RT_F ----------------------

5998: and information1 = c_comp_lvl_rt_id
5999: -- and information4 = p_business_group_id
6000: ;
6001: ---------------------------------------------------------------
6002: -- END OF BEN_COMP_LVL_RT_F ----------------------
6003: ---------------------------------------------------------------
6004: ---------------------------------------------------------------
6005: -- START OF BEN_DSBLD_RT_F ----------------------
6006: ---------------------------------------------------------------

Line 8917: -- START OF BEN_COMP_LVL_RT_F ----------------------

8913: ---------------------------------------------------------------
8914: -- END OF BEN_CMBN_AGE_LOS_RT_F ----------------------
8915: ---------------------------------------------------------------
8916: ---------------------------------------------------------------
8917: -- START OF BEN_COMP_LVL_RT_F ----------------------
8918: ---------------------------------------------------------------
8919: --
8920: hr_utility.set_location('START OF BEN_COMP_LVL_RT_F',100);
8921: for l_parent_rec in c_clr_from_parent(l_VRBL_RT_PRFL_ID) loop

Line 8920: hr_utility.set_location('START OF BEN_COMP_LVL_RT_F',100);

8916: ---------------------------------------------------------------
8917: -- START OF BEN_COMP_LVL_RT_F ----------------------
8918: ---------------------------------------------------------------
8919: --
8920: hr_utility.set_location('START OF BEN_COMP_LVL_RT_F',100);
8921: for l_parent_rec in c_clr_from_parent(l_VRBL_RT_PRFL_ID) loop
8922: --
8923: l_mirror_src_entity_result_id := l_out_vpf_result_id ;
8924:

Line 9036: hr_utility.set_location('END OF BEN_COMP_LVL_RT_F',100);

9032: ,p_effective_date => p_effective_date
9033: );
9034: end loop;
9035: end loop;
9036: hr_utility.set_location('END OF BEN_COMP_LVL_RT_F',100);
9037: ---------------------------------------------------------------
9038: -- END OF BEN_COMP_LVL_RT_F ----------------------
9039: ---------------------------------------------------------------
9040: ---------------------------------------------------------------

Line 9038: -- END OF BEN_COMP_LVL_RT_F ----------------------

9034: end loop;
9035: end loop;
9036: hr_utility.set_location('END OF BEN_COMP_LVL_RT_F',100);
9037: ---------------------------------------------------------------
9038: -- END OF BEN_COMP_LVL_RT_F ----------------------
9039: ---------------------------------------------------------------
9040: ---------------------------------------------------------------
9041: -- START OF BEN_DSBLD_RT_F ----------------------
9042: ---------------------------------------------------------------