DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_LER_BNFT_RSTRN_F

Line 604: -- START OF BEN_LER_BNFT_RSTRN_F ----------------------

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

Line 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

Line 614: from BEN_LER_BNFT_RSTRN_F lbr

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

Line 631: -- END OF BEN_LER_BNFT_RSTRN_F ----------------------

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: ---------------------------------------------------------------

Line 4721: -- START OF BEN_LER_BNFT_RSTRN_F ----------------------

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: --

Line 4896: -- END OF BEN_LER_BNFT_RSTRN_F ----------------------

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: ---------------------------------------------------------------