APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_PRTT_ANTHR_PL_PRTE_F

Line 2777: -- START OF BEN_ELIG_PRTT_ANTHR_PL_PRTE_F ----------------------

2773: ---------------------------------------------------------------
2774: -- END OF BEN_ELIG_PPL_GRP_PRTE_F ----------------------
2775: ---------------------------------------------------------------
2776: ---------------------------------------------------------------
2777: -- START OF BEN_ELIG_PRTT_ANTHR_PL_PRTE_F ----------------------
2778: ---------------------------------------------------------------
2779: cursor c_epp_from_parent(c_ELIGY_PRFL_ID number) is
2780: select elig_prtt_anthr_pl_prte_id
2781: from BEN_ELIG_PRTT_ANTHR_PL_PRTE_F

Line 2781: from BEN_ELIG_PRTT_ANTHR_PL_PRTE_F

2777: -- START OF BEN_ELIG_PRTT_ANTHR_PL_PRTE_F ----------------------
2778: ---------------------------------------------------------------
2779: cursor c_epp_from_parent(c_ELIGY_PRFL_ID number) is
2780: select elig_prtt_anthr_pl_prte_id
2781: from BEN_ELIG_PRTT_ANTHR_PL_PRTE_F
2782: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
2783: --
2784: cursor c_epp(c_elig_prtt_anthr_pl_prte_id number,c_mirror_src_entity_result_id number ,
2785: c_table_alias varchar2 ) is

Line 2787: from BEN_ELIG_PRTT_ANTHR_PL_PRTE_F epp

2783: --
2784: cursor c_epp(c_elig_prtt_anthr_pl_prte_id number,c_mirror_src_entity_result_id number ,
2785: c_table_alias varchar2 ) is
2786: select epp.*
2787: from BEN_ELIG_PRTT_ANTHR_PL_PRTE_F epp
2788: where epp.elig_prtt_anthr_pl_prte_id = c_elig_prtt_anthr_pl_prte_id
2789: -- and epp.business_group_id = p_business_group_id
2790: and not exists (
2791: select /* */ null

Line 2798: -- and trt.where_clause = 'BEN_ELIG_PRTT_ANTHR_PL_PRTE_F'

2794: where copy_entity_txn_id = p_copy_entity_txn_id
2795: -- and trt.table_route_id = cpe.table_route_id
2796: and ( -- c_mirror_src_entity_result_id is null or
2797: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
2798: -- and trt.where_clause = 'BEN_ELIG_PRTT_ANTHR_PL_PRTE_F'
2799: and cpe.table_alias = c_table_alias
2800: and information1 = c_elig_prtt_anthr_pl_prte_id
2801: -- and information4 = epp.business_group_id
2802: and information2 = epp.effective_start_date

Line 2808: -- END OF BEN_ELIG_PRTT_ANTHR_PL_PRTE_F ----------------------

2804: );
2805: l_elig_prtt_anthr_pl_prte_id number(15);
2806: l_out_epp_result_id number(15);
2807: ---------------------------------------------------------------
2808: -- END OF BEN_ELIG_PRTT_ANTHR_PL_PRTE_F ----------------------
2809: ---------------------------------------------------------------
2810: ---------------------------------------------------------------
2811: -- START OF BEN_ELIG_PSTL_CD_R_RNG_PRTE_F ----------------------
2812: ---------------------------------------------------------------

Line 8814: -- START OF BEN_ELIG_PRTT_ANTHR_PL_PRTE_F ----------------------

8810: ---------------------------------------------------------------
8811: -- END OF BEN_ELIG_PPL_GRP_PRTE_F ----------------------
8812: ---------------------------------------------------------------
8813: ---------------------------------------------------------------
8814: -- START OF BEN_ELIG_PRTT_ANTHR_PL_PRTE_F ----------------------
8815: ---------------------------------------------------------------
8816: --
8817: for l_parent_rec in c_epp_from_parent(l_ELIGY_PRFL_ID) loop
8818: --

Line 8916: -- END OF BEN_ELIG_PRTT_ANTHR_PL_PRTE_F ----------------------

8912: end loop;
8913: --
8914: end loop;
8915: ---------------------------------------------------------------
8916: -- END OF BEN_ELIG_PRTT_ANTHR_PL_PRTE_F ----------------------
8917: ---------------------------------------------------------------
8918: ---------------------------------------------------------------
8919: -- START OF BEN_ELIG_PSTL_CD_R_RNG_PRTE_F ----------------------
8920: ---------------------------------------------------------------