APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_PPL_GRP_PRTE_F

Line 2743: -- START OF BEN_ELIG_PPL_GRP_PRTE_F ----------------------

2739: ---------------------------------------------------------------
2740: -- END OF BEN_ELIG_PER_TYP_PRTE_F ----------------------
2741: ---------------------------------------------------------------
2742: ---------------------------------------------------------------
2743: -- START OF BEN_ELIG_PPL_GRP_PRTE_F ----------------------
2744: ---------------------------------------------------------------
2745: cursor c_epg_from_parent(c_ELIGY_PRFL_ID number) is
2746: select elig_ppl_grp_prte_id
2747: from BEN_ELIG_PPL_GRP_PRTE_F

Line 2747: from BEN_ELIG_PPL_GRP_PRTE_F

2743: -- START OF BEN_ELIG_PPL_GRP_PRTE_F ----------------------
2744: ---------------------------------------------------------------
2745: cursor c_epg_from_parent(c_ELIGY_PRFL_ID number) is
2746: select elig_ppl_grp_prte_id
2747: from BEN_ELIG_PPL_GRP_PRTE_F
2748: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
2749: --
2750: cursor c_epg(c_elig_ppl_grp_prte_id number,c_mirror_src_entity_result_id number ,
2751: c_table_alias varchar2 ) is

Line 2753: from BEN_ELIG_PPL_GRP_PRTE_F epg

2749: --
2750: cursor c_epg(c_elig_ppl_grp_prte_id number,c_mirror_src_entity_result_id number ,
2751: c_table_alias varchar2 ) is
2752: select epg.*
2753: from BEN_ELIG_PPL_GRP_PRTE_F epg
2754: where epg.elig_ppl_grp_prte_id = c_elig_ppl_grp_prte_id
2755: -- and epg.business_group_id = p_business_group_id
2756: and not exists (
2757: select /* */ null

Line 2764: -- and trt.where_clause = 'BEN_ELIG_PPL_GRP_PRTE_F'

2760: where copy_entity_txn_id = p_copy_entity_txn_id
2761: -- and trt.table_route_id = cpe.table_route_id
2762: and ( -- c_mirror_src_entity_result_id is null or
2763: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
2764: -- and trt.where_clause = 'BEN_ELIG_PPL_GRP_PRTE_F'
2765: and cpe.table_alias = c_table_alias
2766: and information1 = c_elig_ppl_grp_prte_id
2767: -- and information4 = epg.business_group_id
2768: and information2 = epg.effective_start_date

Line 2774: -- END OF BEN_ELIG_PPL_GRP_PRTE_F ----------------------

2770: );
2771: l_elig_ppl_grp_prte_id number(15);
2772: l_out_epg_result_id number(15);
2773: ---------------------------------------------------------------
2774: -- END OF BEN_ELIG_PPL_GRP_PRTE_F ----------------------
2775: ---------------------------------------------------------------
2776: ---------------------------------------------------------------
2777: -- START OF BEN_ELIG_PRTT_ANTHR_PL_PRTE_F ----------------------
2778: ---------------------------------------------------------------

Line 8709: -- START OF BEN_ELIG_PPL_GRP_PRTE_F ----------------------

8705: ---------------------------------------------------------------
8706: -- END OF BEN_ELIG_PER_TYP_PRTE_F ----------------------
8707: ---------------------------------------------------------------
8708: ---------------------------------------------------------------
8709: -- START OF BEN_ELIG_PPL_GRP_PRTE_F ----------------------
8710: ---------------------------------------------------------------
8711: --
8712: for l_parent_rec in c_epg_from_parent(l_ELIGY_PRFL_ID) loop
8713: --

Line 8811: -- END OF BEN_ELIG_PPL_GRP_PRTE_F ----------------------

8807: end loop;
8808: --
8809: end loop;
8810: ---------------------------------------------------------------
8811: -- END OF BEN_ELIG_PPL_GRP_PRTE_F ----------------------
8812: ---------------------------------------------------------------
8813: ---------------------------------------------------------------
8814: -- START OF BEN_ELIG_PRTT_ANTHR_PL_PRTE_F ----------------------
8815: ---------------------------------------------------------------