[Home] [Help]
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
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
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
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
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: ;
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 ----------------------
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: --
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 ----------------------
16549: l_result_type_cd varchar2(30);
16550: l_information5 ben_copy_entity_results.information5%type;
16551: l_number_of_copies number(15);
16552: ---------------------------------------------------------------
16553: -- START OF BEN_BENFTS_GRP ----------------------
16554: ---------------------------------------------------------------
16555: cursor c_bng(c_benfts_grp_id number,c_mirror_src_entity_result_id number,
16556: c_table_alias varchar2 ) is
16557: select bng.*
16554: ---------------------------------------------------------------
16555: cursor c_bng(c_benfts_grp_id number,c_mirror_src_entity_result_id number,
16556: c_table_alias varchar2 ) is
16557: select bng.*
16558: from BEN_BENFTS_GRP bng
16559: where bng.benfts_grp_id = c_benfts_grp_id
16560: --and bng.business_group_id = p_business_group_id
16561: and not exists (
16562: select /* */ null
16565: where copy_entity_txn_id = p_copy_entity_txn_id
16566: -- and trt.table_route_id = cpe.table_route_id
16567: and ( -- c_mirror_src_entity_result_id is null or
16568: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
16569: -- and trt.where_clause = 'BEN_BENFTS_GRP'
16570: and cpe.table_alias = c_table_alias
16571: and information1 = c_benfts_grp_id
16572: -- and information4 = bng.business_group_id
16573: );
16573: );
16574: l_benfts_grp_id number(15);
16575: l_out_bng_result_id number(15);
16576: ---------------------------------------------------------------
16577: -- END OF BEN_BENFTS_GRP ----------------------
16578: ---------------------------------------------------------------
16579: cursor c_object_exists(c_pk_id number,
16580: c_table_alias varchar2) is
16581: select null
16599: end if;
16600:
16601: l_number_of_copies := p_number_of_copies ;
16602: ---------------------------------------------------------------
16603: -- START OF BEN_BENFTS_GRP ----------------------
16604: ---------------------------------------------------------------
16605: --
16606: l_mirror_src_entity_result_id := p_copy_entity_result_id ;
16607: --
16683: --
16684: end loop;
16685: --
16686: ---------------------------------------------------------------
16687: -- END OF BEN_BENFTS_GRP ----------------------
16688: ---------------------------------------------------------------
16689: end ;
16690: --
16691: procedure create_acrs_ptip_cvg_results