APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_TBCO_USE_RT_F

Line 6948: -- START OF BEN_TBCO_USE_RT_F ----------------------

6944: ---------------------------------------------------------------
6945: -- END OF BEN_SVC_AREA_RT_F ----------------------
6946: ---------------------------------------------------------------
6947: ---------------------------------------------------------------
6948: -- START OF BEN_TBCO_USE_RT_F ----------------------
6949: ---------------------------------------------------------------
6950: cursor c_tur_from_parent(c_VRBL_RT_PRFL_ID number) is
6951: select tbco_use_rt_id
6952: from BEN_TBCO_USE_RT_F

Line 6952: from BEN_TBCO_USE_RT_F

6948: -- START OF BEN_TBCO_USE_RT_F ----------------------
6949: ---------------------------------------------------------------
6950: cursor c_tur_from_parent(c_VRBL_RT_PRFL_ID number) is
6951: select tbco_use_rt_id
6952: from BEN_TBCO_USE_RT_F
6953: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
6954: --
6955: cursor c_tur(c_tbco_use_rt_id number,c_mirror_src_entity_result_id number,
6956: c_table_alias varchar2 ) is

Line 6958: from BEN_TBCO_USE_RT_F tur

6954: --
6955: cursor c_tur(c_tbco_use_rt_id number,c_mirror_src_entity_result_id number,
6956: c_table_alias varchar2 ) is
6957: select tur.*
6958: from BEN_TBCO_USE_RT_F tur
6959: where tur.tbco_use_rt_id = c_tbco_use_rt_id
6960: -- and tur.business_group_id = p_business_group_id
6961: and not exists (
6962: select /* */ null

Line 6969: -- and trt.where_clause = 'BEN_TBCO_USE_RT_F'

6965: where copy_entity_txn_id = p_copy_entity_txn_id
6966: -- and trt.table_route_id = cpe.table_route_id
6967: and ( -- c_mirror_src_entity_result_id is null or
6968: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6969: -- and trt.where_clause = 'BEN_TBCO_USE_RT_F'
6970: and cpe.table_alias = c_table_alias
6971: and information1 = c_tbco_use_rt_id
6972: -- and information4 = tur.business_group_id
6973: and information2 = tur.effective_start_date

Line 6978: -- END OF BEN_TBCO_USE_RT_F ----------------------

6974: and information3 = tur.effective_end_date);
6975: l_tbco_use_rt_id number(15);
6976: l_out_tur_result_id number(15);
6977: ---------------------------------------------------------------
6978: -- END OF BEN_TBCO_USE_RT_F ----------------------
6979: ---------------------------------------------------------------
6980: ---------------------------------------------------------------
6981: -- START OF BEN_TTL_CVG_VOL_RT_F ----------------------
6982: ---------------------------------------------------------------

Line 11847: -- START OF BEN_TBCO_USE_RT_F ----------------------

11843: ---------------------------------------------------------------
11844: -- END OF BEN_SVC_AREA_RT_F ----------------------
11845: ---------------------------------------------------------------
11846: ---------------------------------------------------------------
11847: -- START OF BEN_TBCO_USE_RT_F ----------------------
11848: ---------------------------------------------------------------
11849: --
11850: for l_parent_rec in c_tur_from_parent(l_VRBL_RT_PRFL_ID) loop
11851: --

Line 11947: -- END OF BEN_TBCO_USE_RT_F ----------------------

11943: end loop;
11944: --
11945: end loop;
11946: ---------------------------------------------------------------
11947: -- END OF BEN_TBCO_USE_RT_F ----------------------
11948: ---------------------------------------------------------------
11949: ---------------------------------------------------------------
11950: -- START OF BEN_TTL_CVG_VOL_RT_F ----------------------
11951: ---------------------------------------------------------------