APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_LVG_RSN_PRTE_F

Line 2456: -- START OF BEN_ELIG_LVG_RSN_PRTE_F ----------------------

2452: ---------------------------------------------------------------
2453: -- END OF BEN_ELIG_LOS_PRTE_F ----------------------
2454: ---------------------------------------------------------------
2455: ---------------------------------------------------------------
2456: -- START OF BEN_ELIG_LVG_RSN_PRTE_F ----------------------
2457: ---------------------------------------------------------------
2458: cursor c_elv_from_parent(c_ELIGY_PRFL_ID number) is
2459: select elig_lvg_rsn_prte_id
2460: from BEN_ELIG_LVG_RSN_PRTE_F

Line 2460: from BEN_ELIG_LVG_RSN_PRTE_F

2456: -- START OF BEN_ELIG_LVG_RSN_PRTE_F ----------------------
2457: ---------------------------------------------------------------
2458: cursor c_elv_from_parent(c_ELIGY_PRFL_ID number) is
2459: select elig_lvg_rsn_prte_id
2460: from BEN_ELIG_LVG_RSN_PRTE_F
2461: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
2462: --
2463: cursor c_elv(c_elig_lvg_rsn_prte_id number,c_mirror_src_entity_result_id number ,
2464: c_table_alias varchar2 ) is

Line 2466: from BEN_ELIG_LVG_RSN_PRTE_F elv

2462: --
2463: cursor c_elv(c_elig_lvg_rsn_prte_id number,c_mirror_src_entity_result_id number ,
2464: c_table_alias varchar2 ) is
2465: select elv.*
2466: from BEN_ELIG_LVG_RSN_PRTE_F elv
2467: where elv.elig_lvg_rsn_prte_id = c_elig_lvg_rsn_prte_id
2468: -- and elv.business_group_id = p_business_group_id
2469: and not exists (
2470: select /* */ null

Line 2477: -- and trt.where_clause = 'BEN_ELIG_LVG_RSN_PRTE_F'

2473: where copy_entity_txn_id = p_copy_entity_txn_id
2474: -- and trt.table_route_id = cpe.table_route_id
2475: and ( -- c_mirror_src_entity_result_id is null or
2476: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
2477: -- and trt.where_clause = 'BEN_ELIG_LVG_RSN_PRTE_F'
2478: and cpe.table_alias = c_table_alias
2479: and information1 = c_elig_lvg_rsn_prte_id
2480: -- and information4 = elv.business_group_id
2481: and information2 = elv.effective_start_date

Line 2487: -- END OF BEN_ELIG_LVG_RSN_PRTE_F ----------------------

2483: );
2484: l_elig_lvg_rsn_prte_id number(15);
2485: l_out_elv_result_id number(15);
2486: ---------------------------------------------------------------
2487: -- END OF BEN_ELIG_LVG_RSN_PRTE_F ----------------------
2488: ---------------------------------------------------------------
2489: ---------------------------------------------------------------
2490: -- START OF BEN_ELIG_NO_OTHR_CVG_PRTE_F ----------------------
2491: ---------------------------------------------------------------

Line 7884: -- START OF BEN_ELIG_LVG_RSN_PRTE_F ----------------------

7880: ---------------------------------------------------------------
7881: -- END OF BEN_ELIG_LOS_PRTE_F ----------------------
7882: ---------------------------------------------------------------
7883: ---------------------------------------------------------------
7884: -- START OF BEN_ELIG_LVG_RSN_PRTE_F ----------------------
7885: ---------------------------------------------------------------
7886: --
7887: for l_parent_rec in c_elv_from_parent(l_ELIGY_PRFL_ID) loop
7888: --

Line 7986: -- END OF BEN_ELIG_LVG_RSN_PRTE_F ----------------------

7982: end loop;
7983: --
7984: end loop;
7985: ---------------------------------------------------------------
7986: -- END OF BEN_ELIG_LVG_RSN_PRTE_F ----------------------
7987: ---------------------------------------------------------------
7988: ---------------------------------------------------------------
7989: -- START OF BEN_ELIG_NO_OTHR_CVG_PRTE_F ----------------------
7990: ---------------------------------------------------------------