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_CMBN_AGE_LOS_RT_F

Line 5914: -- START OF BEN_CMBN_AGE_LOS_RT_F ----------------------

5910: ---------------------------------------------------------------
5911: -- END OF BEN_BRGNG_UNIT_RT_F ----------------------
5912: ---------------------------------------------------------------
5913: ---------------------------------------------------------------
5914: -- START OF BEN_CMBN_AGE_LOS_RT_F ----------------------
5915: ---------------------------------------------------------------
5916: cursor c_cmr_from_parent(c_VRBL_RT_PRFL_ID number) is
5917: select distinct cmbn_age_los_rt_id
5918: from BEN_CMBN_AGE_LOS_RT_F

Line 5918: from BEN_CMBN_AGE_LOS_RT_F

5914: -- START OF BEN_CMBN_AGE_LOS_RT_F ----------------------
5915: ---------------------------------------------------------------
5916: cursor c_cmr_from_parent(c_VRBL_RT_PRFL_ID number) is
5917: select distinct cmbn_age_los_rt_id
5918: from BEN_CMBN_AGE_LOS_RT_F
5919: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
5920: --
5921: cursor c_cmr(c_cmbn_age_los_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
5922: select cmr.*

Line 5923: from BEN_CMBN_AGE_LOS_RT_F cmr

5919: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
5920: --
5921: cursor c_cmr(c_cmbn_age_los_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
5922: select cmr.*
5923: from BEN_CMBN_AGE_LOS_RT_F cmr
5924: where cmr.cmbn_age_los_rt_id = c_cmbn_age_los_rt_id
5925: -- and cmr.business_group_id = p_business_group_id
5926: and not exists (
5927: select /* */ null

Line 5934: -- and trt.where_clause = 'BEN_CMBN_AGE_LOS_RT_F'

5930: where copy_entity_txn_id = p_copy_entity_txn_id
5931: -- and trt.table_route_id = cpe.table_route_id
5932: and ( -- c_mirror_src_entity_result_id is null or
5933: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
5934: -- and trt.where_clause = 'BEN_CMBN_AGE_LOS_RT_F'
5935: and cpe.table_alias = c_table_alias
5936: and information1 = c_cmbn_age_los_rt_id
5937: -- and information4 = cmr.business_group_id
5938: and information2 = cmr.effective_start_date

Line 5950: -- and trt.where_clause = 'BEN_CMBN_AGE_LOS_RT_F'

5946: -- pqh_table_route trt
5947: where copy_entity_txn_id = p_copy_entity_txn_id
5948: -- and trt.table_route_id = cpe.table_route_id
5949: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
5950: -- and trt.where_clause = 'BEN_CMBN_AGE_LOS_RT_F'
5951: and cpe.table_alias = c_table_alias
5952: and information1 = c_cmbn_age_los_rt_id
5953: -- and information4 = p_business_group_id
5954: ;

Line 5956: -- END OF BEN_CMBN_AGE_LOS_RT_F ----------------------

5952: and information1 = c_cmbn_age_los_rt_id
5953: -- and information4 = p_business_group_id
5954: ;
5955: ---------------------------------------------------------------
5956: -- END OF BEN_CMBN_AGE_LOS_RT_F ----------------------
5957: ---------------------------------------------------------------
5958: ---------------------------------------------------------------
5959: -- START OF BEN_COMP_LVL_RT_F ----------------------
5960: ---------------------------------------------------------------

Line 8797: -- START OF BEN_CMBN_AGE_LOS_RT_F ----------------------

8793: ---------------------------------------------------------------
8794: -- END OF BEN_BRGNG_UNIT_RT_F ----------------------
8795: ---------------------------------------------------------------
8796: ---------------------------------------------------------------
8797: -- START OF BEN_CMBN_AGE_LOS_RT_F ----------------------
8798: ---------------------------------------------------------------
8799: --
8800: for l_parent_rec in c_cmr_from_parent(l_VRBL_RT_PRFL_ID) loop
8801: --

Line 8912: hr_utility.set_location('END OF BEN_CMBN_AGE_LOS_RT_F',100);

8908: ,p_effective_date => p_effective_date
8909: );
8910: end loop;
8911: end loop;
8912: hr_utility.set_location('END OF BEN_CMBN_AGE_LOS_RT_F',100);
8913: ---------------------------------------------------------------
8914: -- END OF BEN_CMBN_AGE_LOS_RT_F ----------------------
8915: ---------------------------------------------------------------
8916: ---------------------------------------------------------------

Line 8914: -- END OF BEN_CMBN_AGE_LOS_RT_F ----------------------

8910: end loop;
8911: end loop;
8912: hr_utility.set_location('END OF BEN_CMBN_AGE_LOS_RT_F',100);
8913: ---------------------------------------------------------------
8914: -- END OF BEN_CMBN_AGE_LOS_RT_F ----------------------
8915: ---------------------------------------------------------------
8916: ---------------------------------------------------------------
8917: -- START OF BEN_COMP_LVL_RT_F ----------------------
8918: ---------------------------------------------------------------