600: ---------------------------------------------------------------
601: -- END OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
602: ---------------------------------------------------------------
603: ---------------------------------------------------------------
604: -- START OF BEN_LER_BNFT_RSTRN_F ----------------------
605: ---------------------------------------------------------------
606: cursor c_lbr1_from_parent(c_PLIP_ID number) is
607: select ler_bnft_rstrn_id
608: from BEN_LER_BNFT_RSTRN_F
604: -- START OF BEN_LER_BNFT_RSTRN_F ----------------------
605: ---------------------------------------------------------------
606: cursor c_lbr1_from_parent(c_PLIP_ID number) is
607: select ler_bnft_rstrn_id
608: from BEN_LER_BNFT_RSTRN_F
609: where PLIP_ID = c_PLIP_ID ;
610: --
611: cursor c_lbr1(c_ler_bnft_rstrn_id number,c_mirror_src_entity_result_id number ,
612: c_table_alias varchar2) is
610: --
611: cursor c_lbr1(c_ler_bnft_rstrn_id number,c_mirror_src_entity_result_id number ,
612: c_table_alias varchar2) is
613: select lbr.*
614: from BEN_LER_BNFT_RSTRN_F lbr
615: where lbr.ler_bnft_rstrn_id = c_ler_bnft_rstrn_id
616: and not exists (
617: select /* */ null
618: from ben_copy_entity_results cpe
627: );
628: l_ler_bnft_rstrn_id number(15);
629: l_out_lbr_result_id number(15);
630: ---------------------------------------------------------------
631: -- END OF BEN_LER_BNFT_RSTRN_F ----------------------
632: ---------------------------------------------------------------
633: ---------------------------------------------------------------
634: -- START OF BEN_LER_CHG_PLIP_ENRT_F ----------------------
635: ---------------------------------------------------------------
4717: ---------------------------------------------------------------
4718: -- END OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
4719: ---------------------------------------------------------------
4720: ---------------------------------------------------------------
4721: -- START OF BEN_LER_BNFT_RSTRN_F ----------------------
4722: ---------------------------------------------------------------
4723: --
4724: for l_parent_rec in c_lbr1_from_parent(l_PLIP_ID) loop
4725: --
4892: end loop;
4893: --
4894: end loop;
4895: ---------------------------------------------------------------
4896: -- END OF BEN_LER_BNFT_RSTRN_F ----------------------
4897: ---------------------------------------------------------------
4898: ---------------------------------------------------------------
4899: -- START OF BEN_LER_CHG_PLIP_ENRT_F ----------------------
4900: ---------------------------------------------------------------