APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_BENFTS_GRP_RT_F

Line 5834: -- START OF BEN_BENFTS_GRP_RT_F ----------------------

5830: ---------------------------------------------------------------
5831: -- END OF BEN_ASNT_SET_RT_F ----------------------
5832: ---------------------------------------------------------------
5833: ---------------------------------------------------------------
5834: -- START OF BEN_BENFTS_GRP_RT_F ----------------------
5835: ---------------------------------------------------------------
5836: cursor c_brg_from_parent(c_VRBL_RT_PRFL_ID number) is
5837: select distinct benfts_grp_rt_id
5838: from BEN_BENFTS_GRP_RT_F

Line 5838: from BEN_BENFTS_GRP_RT_F

5834: -- START OF BEN_BENFTS_GRP_RT_F ----------------------
5835: ---------------------------------------------------------------
5836: cursor c_brg_from_parent(c_VRBL_RT_PRFL_ID number) is
5837: select distinct benfts_grp_rt_id
5838: from BEN_BENFTS_GRP_RT_F
5839: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
5840: --
5841: cursor c_brg(c_benfts_grp_rt_id number,c_mirror_src_entity_result_id number,
5842: c_table_alias varchar2 ) is

Line 5844: from BEN_BENFTS_GRP_RT_F brg

5840: --
5841: cursor c_brg(c_benfts_grp_rt_id number,c_mirror_src_entity_result_id number,
5842: c_table_alias varchar2 ) is
5843: select brg.*
5844: from BEN_BENFTS_GRP_RT_F brg
5845: where brg.benfts_grp_rt_id = c_benfts_grp_rt_id
5846: -- and brg.business_group_id = p_business_group_id
5847: and not exists (
5848: select /* */ null

Line 5855: -- and trt.where_clause = 'BEN_BENFTS_GRP_RT_F'

5851: where copy_entity_txn_id = p_copy_entity_txn_id
5852: -- and trt.table_route_id = cpe.table_route_id
5853: and ( -- c_mirror_src_entity_result_id is null or
5854: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
5855: -- and trt.where_clause = 'BEN_BENFTS_GRP_RT_F'
5856: and cpe.table_alias = c_table_alias
5857: and information1 = c_benfts_grp_rt_id
5858: -- and information4 = brg.business_group_id
5859: and information2 = brg.effective_start_date

Line 5871: -- and trt.where_clause = 'BEN_BENFTS_GRP_RT_F'

5867: -- pqh_table_route trt
5868: where copy_entity_txn_id = p_copy_entity_txn_id
5869: -- and trt.table_route_id = cpe.table_route_id
5870: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
5871: -- and trt.where_clause = 'BEN_BENFTS_GRP_RT_F'
5872: and cpe.table_alias = c_table_alias
5873: and information1 = c_benfts_grp_rt_id
5874: -- and information4 = p_business_group_id
5875: ;

Line 5877: -- END OF BEN_BENFTS_GRP_RT_F ----------------------

5873: and information1 = c_benfts_grp_rt_id
5874: -- and information4 = p_business_group_id
5875: ;
5876: ---------------------------------------------------------------
5877: -- END OF BEN_BENFTS_GRP_RT_F ----------------------
5878: ---------------------------------------------------------------
5879:
5880: ---------------------------------------------------------------
5881: -- START OF BEN_BRGNG_UNIT_RT_F ----------------------

Line 8577: -- START OF BEN_BENFTS_GRP_RT_F ----------------------

8573: ---------------------------------------------------------------
8574: -- END OF BEN_ASNT_SET_RT_F ----------------------
8575: ---------------------------------------------------------------
8576: ---------------------------------------------------------------
8577: -- START OF BEN_BENFTS_GRP_RT_F ----------------------
8578: ---------------------------------------------------------------
8579: --
8580: for l_parent_rec in c_brg_from_parent(l_VRBL_RT_PRFL_ID) loop
8581: --

Line 8690: -- END OF BEN_BENFTS_GRP_RT_F ----------------------

8686: );
8687: end loop;
8688: end loop;
8689: ---------------------------------------------------------------
8690: -- END OF BEN_BENFTS_GRP_RT_F ----------------------
8691: ---------------------------------------------------------------
8692:
8693: ---------------------------------------------------------------
8694: -- START OF BEN_BRGNG_UNIT_RT_F ----------------------