APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_OPTD_MDCR_PRTE_F

Line 2524: -- START OF BEN_ELIG_OPTD_MDCR_PRTE_F ----------------------

2520: ---------------------------------------------------------------
2521: -- END OF BEN_ELIG_NO_OTHR_CVG_PRTE_F ----------------------
2522: ---------------------------------------------------------------
2523: ---------------------------------------------------------------
2524: -- START OF BEN_ELIG_OPTD_MDCR_PRTE_F ----------------------
2525: ---------------------------------------------------------------
2526: cursor c_eom_from_parent(c_ELIGY_PRFL_ID number) is
2527: select elig_optd_mdcr_prte_id
2528: from BEN_ELIG_OPTD_MDCR_PRTE_F

Line 2528: from BEN_ELIG_OPTD_MDCR_PRTE_F

2524: -- START OF BEN_ELIG_OPTD_MDCR_PRTE_F ----------------------
2525: ---------------------------------------------------------------
2526: cursor c_eom_from_parent(c_ELIGY_PRFL_ID number) is
2527: select elig_optd_mdcr_prte_id
2528: from BEN_ELIG_OPTD_MDCR_PRTE_F
2529: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
2530: --
2531: cursor c_eom(c_elig_optd_mdcr_prte_id number,c_mirror_src_entity_result_id number ,
2532: c_table_alias varchar2 ) is

Line 2534: from BEN_ELIG_OPTD_MDCR_PRTE_F eom

2530: --
2531: cursor c_eom(c_elig_optd_mdcr_prte_id number,c_mirror_src_entity_result_id number ,
2532: c_table_alias varchar2 ) is
2533: select eom.*
2534: from BEN_ELIG_OPTD_MDCR_PRTE_F eom
2535: where eom.elig_optd_mdcr_prte_id = c_elig_optd_mdcr_prte_id
2536: -- and eom.business_group_id = p_business_group_id
2537: and not exists (
2538: select /* */ null

Line 2545: -- and trt.where_clause = 'BEN_ELIG_OPTD_MDCR_PRTE_F'

2541: where copy_entity_txn_id = p_copy_entity_txn_id
2542: -- and trt.table_route_id = cpe.table_route_id
2543: and ( -- c_mirror_src_entity_result_id is null or
2544: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
2545: -- and trt.where_clause = 'BEN_ELIG_OPTD_MDCR_PRTE_F'
2546: and cpe.table_alias = c_table_alias
2547: and information1 = c_elig_optd_mdcr_prte_id
2548: -- and information4 = eom.business_group_id
2549: and information2 = eom.effective_start_date

Line 2555: -- END OF BEN_ELIG_OPTD_MDCR_PRTE_F ----------------------

2551: );
2552: l_elig_optd_mdcr_prte_id number(15);
2553: l_out_eom_result_id number(15);
2554: ---------------------------------------------------------------
2555: -- END OF BEN_ELIG_OPTD_MDCR_PRTE_F ----------------------
2556: ---------------------------------------------------------------
2557: ---------------------------------------------------------------
2558: -- START OF BEN_ELIG_ORG_UNIT_PRTE_F ----------------------
2559: ---------------------------------------------------------------

Line 8089: -- START OF BEN_ELIG_OPTD_MDCR_PRTE_F ----------------------

8085: ---------------------------------------------------------------
8086: -- END OF BEN_ELIG_NO_OTHR_CVG_PRTE_F ----------------------
8087: ---------------------------------------------------------------
8088: ---------------------------------------------------------------
8089: -- START OF BEN_ELIG_OPTD_MDCR_PRTE_F ----------------------
8090: ---------------------------------------------------------------
8091: --
8092: for l_parent_rec in c_eom_from_parent(l_ELIGY_PRFL_ID) loop
8093: --

Line 8188: -- END OF BEN_ELIG_OPTD_MDCR_PRTE_F ----------------------

8184: end loop;
8185: --
8186: end loop;
8187: ---------------------------------------------------------------
8188: -- END OF BEN_ELIG_OPTD_MDCR_PRTE_F ----------------------
8189: ---------------------------------------------------------------
8190: ---------------------------------------------------------------
8191: -- START OF BEN_ELIG_ORG_UNIT_PRTE_F ----------------------
8192: ---------------------------------------------------------------