APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_VRBL_RT_PRFL_RL_F

Line 7080: -- START OF BEN_VRBL_RT_PRFL_RL_F ----------------------

7076: ---------------------------------------------------------------
7077: -- END OF BEN_VRBL_MTCHG_RT_F ----------------------
7078: ---------------------------------------------------------------
7079: ---------------------------------------------------------------
7080: -- START OF BEN_VRBL_RT_PRFL_RL_F ----------------------
7081: ---------------------------------------------------------------
7082: cursor c_vpr_from_parent(c_VRBL_RT_PRFL_ID number) is
7083: select vrbl_rt_prfl_rl_id
7084: from BEN_VRBL_RT_PRFL_RL_F

Line 7084: from BEN_VRBL_RT_PRFL_RL_F

7080: -- START OF BEN_VRBL_RT_PRFL_RL_F ----------------------
7081: ---------------------------------------------------------------
7082: cursor c_vpr_from_parent(c_VRBL_RT_PRFL_ID number) is
7083: select vrbl_rt_prfl_rl_id
7084: from BEN_VRBL_RT_PRFL_RL_F
7085: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7086: --
7087: cursor c_vpr(c_vrbl_rt_prfl_rl_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
7088: select vpr.*

Line 7089: from BEN_VRBL_RT_PRFL_RL_F vpr

7085: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7086: --
7087: cursor c_vpr(c_vrbl_rt_prfl_rl_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
7088: select vpr.*
7089: from BEN_VRBL_RT_PRFL_RL_F vpr
7090: where vpr.vrbl_rt_prfl_rl_id = c_vrbl_rt_prfl_rl_id
7091: -- and vpr.business_group_id = p_business_group_id
7092: and not exists (
7093: select /* */ null

Line 7100: -- and trt.where_clause = 'BEN_VRBL_RT_PRFL_RL_F'

7096: where copy_entity_txn_id = p_copy_entity_txn_id
7097: -- and trt.table_route_id = cpe.table_route_id
7098: and ( -- c_mirror_src_entity_result_id is null or
7099: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7100: -- and trt.where_clause = 'BEN_VRBL_RT_PRFL_RL_F'
7101: and cpe.table_alias = c_table_alias
7102: and information1 = c_vrbl_rt_prfl_rl_id
7103: -- and information4 = vpr.business_group_id
7104: and information2 = vpr.effective_start_date

Line 7109: -- END OF BEN_VRBL_RT_PRFL_RL_F ----------------------

7105: and information3 = vpr.effective_end_date);
7106: l_vrbl_rt_prfl_rl_id number(15);
7107: l_out_vpr_result_id number(15);
7108: ---------------------------------------------------------------
7109: -- END OF BEN_VRBL_RT_PRFL_RL_F ----------------------
7110: ---------------------------------------------------------------
7111: ---------------------------------------------------------------
7112: -- START OF BEN_WK_LOC_RT_F ----------------------
7113: ---------------------------------------------------------------

Line 12343: -- START OF BEN_VRBL_RT_PRFL_RL_F ----------------------

12339: ---------------------------------------------------------------
12340: -- END OF BEN_VRBL_MTCHG_RT_F ----------------------
12341: ---------------------------------------------------------------
12342: ---------------------------------------------------------------
12343: -- START OF BEN_VRBL_RT_PRFL_RL_F ----------------------
12344: ---------------------------------------------------------------
12345: --
12346: for l_parent_rec in c_vpr_from_parent(l_VRBL_RT_PRFL_ID) loop
12347: --

Line 12464: -- END OF BEN_VRBL_RT_PRFL_RL_F ----------------------

12460: end loop;
12461: --
12462: end loop;
12463: ---------------------------------------------------------------
12464: -- END OF BEN_VRBL_RT_PRFL_RL_F ----------------------
12465: ---------------------------------------------------------------
12466: ---------------------------------------------------------------
12467: -- START OF BEN_WK_LOC_RT_F ----------------------
12468: ---------------------------------------------------------------