APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_LER_CHG_PLIP_ENRT_F

Line 634: -- START OF BEN_LER_CHG_PLIP_ENRT_F ----------------------

630: ---------------------------------------------------------------
631: -- END OF BEN_LER_BNFT_RSTRN_F ----------------------
632: ---------------------------------------------------------------
633: ---------------------------------------------------------------
634: -- START OF BEN_LER_CHG_PLIP_ENRT_F ----------------------
635: ---------------------------------------------------------------
636: cursor c_lpr_from_parent(c_PLIP_ID number) is
637: select distinct ler_chg_plip_enrt_id
638: from BEN_LER_CHG_PLIP_ENRT_F

Line 638: from BEN_LER_CHG_PLIP_ENRT_F

634: -- START OF BEN_LER_CHG_PLIP_ENRT_F ----------------------
635: ---------------------------------------------------------------
636: cursor c_lpr_from_parent(c_PLIP_ID number) is
637: select distinct ler_chg_plip_enrt_id
638: from BEN_LER_CHG_PLIP_ENRT_F
639: where PLIP_ID = c_PLIP_ID ;
640: --
641: cursor c_lpr(c_ler_chg_plip_enrt_id number,c_mirror_src_entity_result_id number ,
642: c_table_alias varchar2) is

Line 644: from BEN_LER_CHG_PLIP_ENRT_F lpr

640: --
641: cursor c_lpr(c_ler_chg_plip_enrt_id number,c_mirror_src_entity_result_id number ,
642: c_table_alias varchar2) is
643: select lpr.*
644: from BEN_LER_CHG_PLIP_ENRT_F lpr
645: where lpr.ler_chg_plip_enrt_id = c_ler_chg_plip_enrt_id
646: and not exists (
647: select /* */ null
648: from ben_copy_entity_results cpe

Line 673: -- END OF BEN_LER_CHG_PLIP_ENRT_F ----------------------

669: and cpe.table_alias = c_table_alias
670: and information1 = c_ler_chg_plip_enrt_id
671: ;
672: ---------------------------------------------------------------
673: -- END OF BEN_LER_CHG_PLIP_ENRT_F ----------------------
674: ---------------------------------------------------------------
675: ---------------------------------------------------------------
676: -- START OF BEN_CMBN_PLIP_F ----------------------
677: ---------------------------------------------------------------

Line 4899: -- START OF BEN_LER_CHG_PLIP_ENRT_F ----------------------

4895: ---------------------------------------------------------------
4896: -- END OF BEN_LER_BNFT_RSTRN_F ----------------------
4897: ---------------------------------------------------------------
4898: ---------------------------------------------------------------
4899: -- START OF BEN_LER_CHG_PLIP_ENRT_F ----------------------
4900: ---------------------------------------------------------------
4901: --
4902: for l_parent_rec in c_lpr_from_parent(l_PLIP_ID) loop
4903: --

Line 5077: -- END OF BEN_LER_CHG_PLIP_ENRT_F ----------------------

5073: end loop;
5074: --
5075: end loop;
5076: ---------------------------------------------------------------
5077: -- END OF BEN_LER_CHG_PLIP_ENRT_F ----------------------
5078: ---------------------------------------------------------------
5079: -- ------------------------------------------------------------------------
5080: -- Plans
5081: -- ------------------------------------------------------------------------