APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_LOS_RT_F

Line 6441: -- START OF BEN_LOS_RT_F ----------------------

6437: ---------------------------------------------------------------
6438: -- END OF BEN_LOA_RSN_RT_F ----------------------
6439: ---------------------------------------------------------------
6440: ---------------------------------------------------------------
6441: -- START OF BEN_LOS_RT_F ----------------------
6442: ---------------------------------------------------------------
6443: cursor c_lsr_from_parent(c_VRBL_RT_PRFL_ID number) is
6444: select distinct los_rt_id
6445: from BEN_LOS_RT_F

Line 6445: from BEN_LOS_RT_F

6441: -- START OF BEN_LOS_RT_F ----------------------
6442: ---------------------------------------------------------------
6443: cursor c_lsr_from_parent(c_VRBL_RT_PRFL_ID number) is
6444: select distinct los_rt_id
6445: from BEN_LOS_RT_F
6446: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
6447: --
6448: cursor c_lsr(c_los_rt_id number,c_mirror_src_entity_result_id number,
6449: c_table_alias varchar2 ) is

Line 6451: from BEN_LOS_RT_F lsr

6447: --
6448: cursor c_lsr(c_los_rt_id number,c_mirror_src_entity_result_id number,
6449: c_table_alias varchar2 ) is
6450: select lsr.*
6451: from BEN_LOS_RT_F lsr
6452: where lsr.los_rt_id = c_los_rt_id
6453: -- and lsr.business_group_id = p_business_group_id
6454: and not exists (
6455: select /* */ null

Line 6462: -- and trt.where_clause = 'BEN_LOS_RT_F'

6458: where copy_entity_txn_id = p_copy_entity_txn_id
6459: -- and trt.table_route_id = cpe.table_route_id
6460: and ( -- c_mirror_src_entity_result_id is null or
6461: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6462: -- and trt.where_clause = 'BEN_LOS_RT_F'
6463: and cpe.table_alias = c_table_alias
6464: and information1 = c_los_rt_id
6465: -- and information4 = lsr.business_group_id
6466: and information2 = lsr.effective_start_date

Line 6479: -- and trt.where_clause = 'BEN_LOS_RT_F'

6475: -- pqh_table_route trt
6476: where copy_entity_txn_id = p_copy_entity_txn_id
6477: -- and trt.table_route_id = cpe.table_route_id
6478: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
6479: -- and trt.where_clause = 'BEN_LOS_RT_F'
6480: and cpe.table_alias = c_table_alias
6481: and information1 = c_los_rt_id
6482: -- and information4 = p_business_group_id
6483: ;

Line 6485: -- END OF BEN_LOS_RT_F ----------------------

6481: and information1 = c_los_rt_id
6482: -- and information4 = p_business_group_id
6483: ;
6484: ---------------------------------------------------------------
6485: -- END OF BEN_LOS_RT_F ----------------------
6486: ---------------------------------------------------------------
6487: ---------------------------------------------------------------
6488: -- START OF BEN_LVG_RSN_RT_F ----------------------
6489: ---------------------------------------------------------------

Line 10287: -- START OF BEN_LOS_RT_F ----------------------

10283: ---------------------------------------------------------------
10284: -- END OF BEN_LOA_RSN_RT_F ----------------------
10285: ---------------------------------------------------------------
10286: ---------------------------------------------------------------
10287: -- START OF BEN_LOS_RT_F ----------------------
10288: ---------------------------------------------------------------
10289: --
10290: for l_parent_rec in c_lsr_from_parent(l_VRBL_RT_PRFL_ID) loop
10291: --

Line 10405: -- END OF BEN_LOS_RT_F ----------------------

10401: );
10402: end loop;
10403: end loop;
10404: ---------------------------------------------------------------
10405: -- END OF BEN_LOS_RT_F ----------------------
10406: ---------------------------------------------------------------
10407: ---------------------------------------------------------------
10408: -- START OF BEN_LVG_RSN_RT_F ----------------------
10409: ---------------------------------------------------------------