APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_NO_OTHR_CVG_PRTE_F

Line 2490: -- START OF BEN_ELIG_NO_OTHR_CVG_PRTE_F ----------------------

2486: ---------------------------------------------------------------
2487: -- END OF BEN_ELIG_LVG_RSN_PRTE_F ----------------------
2488: ---------------------------------------------------------------
2489: ---------------------------------------------------------------
2490: -- START OF BEN_ELIG_NO_OTHR_CVG_PRTE_F ----------------------
2491: ---------------------------------------------------------------
2492: cursor c_eno_from_parent(c_ELIGY_PRFL_ID number) is
2493: select elig_no_othr_cvg_prte_id
2494: from BEN_ELIG_NO_OTHR_CVG_PRTE_F

Line 2494: from BEN_ELIG_NO_OTHR_CVG_PRTE_F

2490: -- START OF BEN_ELIG_NO_OTHR_CVG_PRTE_F ----------------------
2491: ---------------------------------------------------------------
2492: cursor c_eno_from_parent(c_ELIGY_PRFL_ID number) is
2493: select elig_no_othr_cvg_prte_id
2494: from BEN_ELIG_NO_OTHR_CVG_PRTE_F
2495: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
2496: --
2497: cursor c_eno(c_elig_no_othr_cvg_prte_id number,c_mirror_src_entity_result_id number ,
2498: c_table_alias varchar2 ) is

Line 2500: from BEN_ELIG_NO_OTHR_CVG_PRTE_F eno

2496: --
2497: cursor c_eno(c_elig_no_othr_cvg_prte_id number,c_mirror_src_entity_result_id number ,
2498: c_table_alias varchar2 ) is
2499: select eno.*
2500: from BEN_ELIG_NO_OTHR_CVG_PRTE_F eno
2501: where eno.elig_no_othr_cvg_prte_id = c_elig_no_othr_cvg_prte_id
2502: -- and eno.business_group_id = p_business_group_id
2503: and not exists (
2504: select /* */ null

Line 2511: -- and trt.where_clause = 'BEN_ELIG_NO_OTHR_CVG_PRTE_F'

2507: where copy_entity_txn_id = p_copy_entity_txn_id
2508: -- and trt.table_route_id = cpe.table_route_id
2509: and ( -- c_mirror_src_entity_result_id is null or
2510: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
2511: -- and trt.where_clause = 'BEN_ELIG_NO_OTHR_CVG_PRTE_F'
2512: and cpe.table_alias = c_table_alias
2513: and information1 = c_elig_no_othr_cvg_prte_id
2514: -- and information4 = eno.business_group_id
2515: and information2 = eno.effective_start_date

Line 2521: -- END OF BEN_ELIG_NO_OTHR_CVG_PRTE_F ----------------------

2517: );
2518: l_elig_no_othr_cvg_prte_id number(15);
2519: l_out_eno_result_id number(15);
2520: ---------------------------------------------------------------
2521: -- END OF BEN_ELIG_NO_OTHR_CVG_PRTE_F ----------------------
2522: ---------------------------------------------------------------
2523: ---------------------------------------------------------------
2524: -- START OF BEN_ELIG_OPTD_MDCR_PRTE_F ----------------------
2525: ---------------------------------------------------------------

Line 7989: -- START OF BEN_ELIG_NO_OTHR_CVG_PRTE_F ----------------------

7985: ---------------------------------------------------------------
7986: -- END OF BEN_ELIG_LVG_RSN_PRTE_F ----------------------
7987: ---------------------------------------------------------------
7988: ---------------------------------------------------------------
7989: -- START OF BEN_ELIG_NO_OTHR_CVG_PRTE_F ----------------------
7990: ---------------------------------------------------------------
7991: --
7992: for l_parent_rec in c_eno_from_parent(l_ELIGY_PRFL_ID) loop
7993: --

Line 8086: -- END OF BEN_ELIG_NO_OTHR_CVG_PRTE_F ----------------------

8082: end loop;
8083: --
8084: end loop;
8085: ---------------------------------------------------------------
8086: -- END OF BEN_ELIG_NO_OTHR_CVG_PRTE_F ----------------------
8087: ---------------------------------------------------------------
8088: ---------------------------------------------------------------
8089: -- START OF BEN_ELIG_OPTD_MDCR_PRTE_F ----------------------
8090: ---------------------------------------------------------------