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_SVC_AREA_RT_F

Line 6902: -- START OF BEN_SVC_AREA_RT_F ----------------------

6898: ---------------------------------------------------------------
6899: -- END OF BEN_SCHEDD_HRS_RT_F ----------------------
6900: ---------------------------------------------------------------
6901: ---------------------------------------------------------------
6902: -- START OF BEN_SVC_AREA_RT_F ----------------------
6903: ---------------------------------------------------------------
6904: cursor c_sar_from_parent(c_VRBL_RT_PRFL_ID number) is
6905: select distinct svc_area_rt_id
6906: from BEN_SVC_AREA_RT_F

Line 6906: from BEN_SVC_AREA_RT_F

6902: -- START OF BEN_SVC_AREA_RT_F ----------------------
6903: ---------------------------------------------------------------
6904: cursor c_sar_from_parent(c_VRBL_RT_PRFL_ID number) is
6905: select distinct svc_area_rt_id
6906: from BEN_SVC_AREA_RT_F
6907: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
6908: --
6909: cursor c_sar(c_svc_area_rt_id number,c_mirror_src_entity_result_id number,
6910: c_table_alias varchar2 ) is

Line 6912: from BEN_SVC_AREA_RT_F sar

6908: --
6909: cursor c_sar(c_svc_area_rt_id number,c_mirror_src_entity_result_id number,
6910: c_table_alias varchar2 ) is
6911: select sar.*
6912: from BEN_SVC_AREA_RT_F sar
6913: where sar.svc_area_rt_id = c_svc_area_rt_id
6914: -- and sar.business_group_id = p_business_group_id
6915: and not exists (
6916: select /* */ null

Line 6923: -- and trt.where_clause = 'BEN_SVC_AREA_RT_F'

6919: where copy_entity_txn_id = p_copy_entity_txn_id
6920: -- and trt.table_route_id = cpe.table_route_id
6921: and ( -- c_mirror_src_entity_result_id is null or
6922: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6923: -- and trt.where_clause = 'BEN_SVC_AREA_RT_F'
6924: and cpe.table_alias = c_table_alias
6925: and information1 = c_svc_area_rt_id
6926: -- and information4 = sar.business_group_id
6927: and information2 = sar.effective_start_date

Line 6939: -- and trt.where_clause = 'BEN_SVC_AREA_RT_F'

6935: -- pqh_table_route trt
6936: where copy_entity_txn_id = p_copy_entity_txn_id
6937: -- and trt.table_route_id = cpe.table_route_id
6938: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
6939: -- and trt.where_clause = 'BEN_SVC_AREA_RT_F'
6940: and cpe.table_alias = c_table_alias
6941: and information1 = c_svc_area_rt_id
6942: -- and information4 = p_business_group_id
6943: ;

Line 6945: -- END OF BEN_SVC_AREA_RT_F ----------------------

6941: and information1 = c_svc_area_rt_id
6942: -- and information4 = p_business_group_id
6943: ;
6944: ---------------------------------------------------------------
6945: -- END OF BEN_SVC_AREA_RT_F ----------------------
6946: ---------------------------------------------------------------
6947: ---------------------------------------------------------------
6948: -- START OF BEN_TBCO_USE_RT_F ----------------------
6949: ---------------------------------------------------------------

Line 11731: -- START OF BEN_SVC_AREA_RT_F ----------------------

11727: ---------------------------------------------------------------
11728: -- END OF BEN_SCHEDD_HRS_RT_F ----------------------
11729: ---------------------------------------------------------------
11730: ---------------------------------------------------------------
11731: -- START OF BEN_SVC_AREA_RT_F ----------------------
11732: ---------------------------------------------------------------
11733: --
11734: for l_parent_rec in c_sar_from_parent(l_VRBL_RT_PRFL_ID) loop
11735: --

Line 11844: -- END OF BEN_SVC_AREA_RT_F ----------------------

11840: );
11841: end loop;
11842: end loop;
11843: ---------------------------------------------------------------
11844: -- END OF BEN_SVC_AREA_RT_F ----------------------
11845: ---------------------------------------------------------------
11846: ---------------------------------------------------------------
11847: -- START OF BEN_TBCO_USE_RT_F ----------------------
11848: ---------------------------------------------------------------