APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_VRBL_MTCHG_RT_F

Line 7047: -- START OF BEN_VRBL_MTCHG_RT_F ----------------------

7043: ---------------------------------------------------------------
7044: -- END OF BEN_TTL_PRTT_RT_F ----------------------
7045: ---------------------------------------------------------------
7046: ---------------------------------------------------------------
7047: -- START OF BEN_VRBL_MTCHG_RT_F ----------------------
7048: ---------------------------------------------------------------
7049: cursor c_vmr_from_parent(c_VRBL_RT_PRFL_ID number) is
7050: select vrbl_mtchg_rt_id
7051: from BEN_VRBL_MTCHG_RT_F

Line 7051: from BEN_VRBL_MTCHG_RT_F

7047: -- START OF BEN_VRBL_MTCHG_RT_F ----------------------
7048: ---------------------------------------------------------------
7049: cursor c_vmr_from_parent(c_VRBL_RT_PRFL_ID number) is
7050: select vrbl_mtchg_rt_id
7051: from BEN_VRBL_MTCHG_RT_F
7052: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7053: --
7054: cursor c_vmr(c_vrbl_mtchg_rt_id number,c_mirror_src_entity_result_id number,
7055: c_table_alias varchar2 ) is

Line 7057: from BEN_VRBL_MTCHG_RT_F vmr

7053: --
7054: cursor c_vmr(c_vrbl_mtchg_rt_id number,c_mirror_src_entity_result_id number,
7055: c_table_alias varchar2 ) is
7056: select vmr.*
7057: from BEN_VRBL_MTCHG_RT_F vmr
7058: where vmr.vrbl_mtchg_rt_id = c_vrbl_mtchg_rt_id
7059: -- and vmr.business_group_id = p_business_group_id
7060: and not exists (
7061: select /* */ null

Line 7068: -- and trt.where_clause = 'BEN_VRBL_MTCHG_RT_F'

7064: where copy_entity_txn_id = p_copy_entity_txn_id
7065: -- and trt.table_route_id = cpe.table_route_id
7066: and ( -- c_mirror_src_entity_result_id is null or
7067: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7068: -- and trt.where_clause = 'BEN_VRBL_MTCHG_RT_F'
7069: and cpe.table_alias = c_table_alias
7070: and information1 = c_vrbl_mtchg_rt_id
7071: -- and information4 = vmr.business_group_id
7072: and information2 = vmr.effective_start_date

Line 7077: -- END OF BEN_VRBL_MTCHG_RT_F ----------------------

7073: and information3 = vmr.effective_end_date);
7074: l_vrbl_mtchg_rt_id number(15);
7075: l_out_vmr_result_id number(15);
7076: ---------------------------------------------------------------
7077: -- END OF BEN_VRBL_MTCHG_RT_F ----------------------
7078: ---------------------------------------------------------------
7079: ---------------------------------------------------------------
7080: -- START OF BEN_VRBL_RT_PRFL_RL_F ----------------------
7081: ---------------------------------------------------------------

Line 12210: -- START OF BEN_VRBL_MTCHG_RT_F ----------------------

12206: ---------------------------------------------------------------
12207: -- END OF BEN_TTL_PRTT_RT_F ----------------------
12208: ---------------------------------------------------------------
12209: ---------------------------------------------------------------
12210: -- START OF BEN_VRBL_MTCHG_RT_F ----------------------
12211: ---------------------------------------------------------------
12212: --
12213: for l_parent_rec in c_vmr_from_parent(l_VRBL_RT_PRFL_ID) loop
12214: --

Line 12340: -- END OF BEN_VRBL_MTCHG_RT_F ----------------------

12336: end loop;
12337: --
12338: end loop;
12339: ---------------------------------------------------------------
12340: -- END OF BEN_VRBL_MTCHG_RT_F ----------------------
12341: ---------------------------------------------------------------
12342: ---------------------------------------------------------------
12343: -- START OF BEN_VRBL_RT_PRFL_RL_F ----------------------
12344: ---------------------------------------------------------------