APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_FL_TM_PT_TM_RT_F

Line 6094: -- START OF BEN_FL_TM_PT_TM_RT_F ----------------------

6090: ---------------------------------------------------------------
6091: -- END OF BEN_EE_STAT_RT_F ----------------------
6092: ---------------------------------------------------------------
6093: ---------------------------------------------------------------
6094: -- START OF BEN_FL_TM_PT_TM_RT_F ----------------------
6095: ---------------------------------------------------------------
6096: cursor c_ftr_from_parent(c_VRBL_RT_PRFL_ID number) is
6097: select fl_tm_pt_tm_rt_id
6098: from BEN_FL_TM_PT_TM_RT_F

Line 6098: from BEN_FL_TM_PT_TM_RT_F

6094: -- START OF BEN_FL_TM_PT_TM_RT_F ----------------------
6095: ---------------------------------------------------------------
6096: cursor c_ftr_from_parent(c_VRBL_RT_PRFL_ID number) is
6097: select fl_tm_pt_tm_rt_id
6098: from BEN_FL_TM_PT_TM_RT_F
6099: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
6100: --
6101: cursor c_ftr(c_fl_tm_pt_tm_rt_id number,c_mirror_src_entity_result_id number,
6102: c_table_alias varchar2 ) is

Line 6104: from BEN_FL_TM_PT_TM_RT_F ftr

6100: --
6101: cursor c_ftr(c_fl_tm_pt_tm_rt_id number,c_mirror_src_entity_result_id number,
6102: c_table_alias varchar2 ) is
6103: select ftr.*
6104: from BEN_FL_TM_PT_TM_RT_F ftr
6105: where ftr.fl_tm_pt_tm_rt_id = c_fl_tm_pt_tm_rt_id
6106: -- and ftr.business_group_id = p_business_group_id
6107: and not exists (
6108: select /* */ null

Line 6115: -- and trt.where_clause = 'BEN_FL_TM_PT_TM_RT_F'

6111: where copy_entity_txn_id = p_copy_entity_txn_id
6112: -- and trt.table_route_id = cpe.table_route_id
6113: and ( -- c_mirror_src_entity_result_id is null or
6114: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6115: -- and trt.where_clause = 'BEN_FL_TM_PT_TM_RT_F'
6116: and cpe.table_alias = c_table_alias
6117: and information1 = c_fl_tm_pt_tm_rt_id
6118: -- and information4 = ftr.business_group_id
6119: and information2 = ftr.effective_start_date

Line 6125: -- END OF BEN_FL_TM_PT_TM_RT_F ----------------------

6121:
6122: l_fl_tm_pt_tm_rt_id number(15);
6123: l_out_ftr_result_id number(15);
6124: ---------------------------------------------------------------
6125: -- END OF BEN_FL_TM_PT_TM_RT_F ----------------------
6126: ---------------------------------------------------------------
6127: ---------------------------------------------------------------
6128: -- START OF BEN_GNDR_RT_F ----------------------
6129: ---------------------------------------------------------------

Line 9283: -- START OF BEN_FL_TM_PT_TM_RT_F ----------------------

9279: ---------------------------------------------------------------
9280: -- END OF BEN_EE_STAT_RT_F ----------------------
9281: ---------------------------------------------------------------
9282: ---------------------------------------------------------------
9283: -- START OF BEN_FL_TM_PT_TM_RT_F ----------------------
9284: ---------------------------------------------------------------
9285: --
9286: for l_parent_rec in c_ftr_from_parent(l_VRBL_RT_PRFL_ID) loop
9287: --

Line 9382: -- END OF BEN_FL_TM_PT_TM_RT_F ----------------------

9378: end loop;
9379: --
9380: end loop;
9381: ---------------------------------------------------------------
9382: -- END OF BEN_FL_TM_PT_TM_RT_F ----------------------
9383: ---------------------------------------------------------------
9384: ---------------------------------------------------------------
9385: -- START OF BEN_GNDR_RT_F ----------------------
9386: ---------------------------------------------------------------