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_EE_STAT_RT_F

Line 6038: -- START OF BEN_EE_STAT_RT_F ----------------------

6034: ---------------------------------------------------------------
6035: -- END OF BEN_DSBLD_RT_F ----------------------
6036: ---------------------------------------------------------------
6037: ---------------------------------------------------------------
6038: -- START OF BEN_EE_STAT_RT_F ----------------------
6039: ---------------------------------------------------------------
6040: cursor c_esr_from_parent(c_VRBL_RT_PRFL_ID number) is
6041: select ee_stat_rt_id
6042: from BEN_EE_STAT_RT_F

Line 6042: from BEN_EE_STAT_RT_F

6038: -- START OF BEN_EE_STAT_RT_F ----------------------
6039: ---------------------------------------------------------------
6040: cursor c_esr_from_parent(c_VRBL_RT_PRFL_ID number) is
6041: select ee_stat_rt_id
6042: from BEN_EE_STAT_RT_F
6043: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
6044: --
6045: cursor c_esr(c_ee_stat_rt_id number,c_mirror_src_entity_result_id number,
6046: c_table_alias varchar2 ) is

Line 6048: from BEN_EE_STAT_RT_F esr

6044: --
6045: cursor c_esr(c_ee_stat_rt_id number,c_mirror_src_entity_result_id number,
6046: c_table_alias varchar2 ) is
6047: select esr.*
6048: from BEN_EE_STAT_RT_F esr
6049: where esr.ee_stat_rt_id = c_ee_stat_rt_id
6050: -- and esr.business_group_id = p_business_group_id
6051: and not exists (
6052: select /* */ null

Line 6059: -- and trt.where_clause = 'BEN_EE_STAT_RT_F'

6055: where copy_entity_txn_id = p_copy_entity_txn_id
6056: -- and trt.table_route_id = cpe.table_route_id
6057: and ( -- c_mirror_src_entity_result_id is null or
6058: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6059: -- and trt.where_clause = 'BEN_EE_STAT_RT_F'
6060: and cpe.table_alias = c_table_alias
6061: and information1 = c_ee_stat_rt_id
6062: -- and information4 = esr.business_group_id
6063: and information2 = esr.effective_start_date

Line 6091: -- END OF BEN_EE_STAT_RT_F ----------------------

6087: and stl.assignment_status_type_id = s.assignment_status_type_id
6088: and stl.language = userenv('LANG');
6089: --
6090: ---------------------------------------------------------------
6091: -- END OF BEN_EE_STAT_RT_F ----------------------
6092: ---------------------------------------------------------------
6093: ---------------------------------------------------------------
6094: -- START OF BEN_FL_TM_PT_TM_RT_F ----------------------
6095: ---------------------------------------------------------------

Line 9143: -- START OF BEN_EE_STAT_RT_F ----------------------

9139: ---------------------------------------------------------------
9140: -- END OF BEN_DSBLD_RT_F ----------------------
9141: ---------------------------------------------------------------
9142: ---------------------------------------------------------------
9143: -- START OF BEN_EE_STAT_RT_F ----------------------
9144: ---------------------------------------------------------------
9145: --
9146: hr_utility.set_location('START OF BEN_EE_STAT_RT_F',100);
9147: for l_parent_rec in c_esr_from_parent(l_VRBL_RT_PRFL_ID) loop

Line 9146: hr_utility.set_location('START OF BEN_EE_STAT_RT_F',100);

9142: ---------------------------------------------------------------
9143: -- START OF BEN_EE_STAT_RT_F ----------------------
9144: ---------------------------------------------------------------
9145: --
9146: hr_utility.set_location('START OF BEN_EE_STAT_RT_F',100);
9147: for l_parent_rec in c_esr_from_parent(l_VRBL_RT_PRFL_ID) loop
9148: --
9149: l_mirror_src_entity_result_id := l_out_vpf_result_id ;
9150:

Line 9278: hr_utility.set_location('END OF BEN_EE_STAT_RT_F ',100);

9274: --
9275: end loop;
9276: --
9277: end loop;
9278: hr_utility.set_location('END OF BEN_EE_STAT_RT_F ',100);
9279: ---------------------------------------------------------------
9280: -- END OF BEN_EE_STAT_RT_F ----------------------
9281: ---------------------------------------------------------------
9282: ---------------------------------------------------------------

Line 9280: -- END OF BEN_EE_STAT_RT_F ----------------------

9276: --
9277: end loop;
9278: hr_utility.set_location('END OF BEN_EE_STAT_RT_F ',100);
9279: ---------------------------------------------------------------
9280: -- END OF BEN_EE_STAT_RT_F ----------------------
9281: ---------------------------------------------------------------
9282: ---------------------------------------------------------------
9283: -- START OF BEN_FL_TM_PT_TM_RT_F ----------------------
9284: ---------------------------------------------------------------