APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_OTHR_PTIP_PRTE_F

Line 2607: -- START OF BEN_ELIG_OTHR_PTIP_PRTE_F ----------------------

2603: ---------------------------------------------------------------
2604: -- END OF BEN_ELIG_ORG_UNIT_PRTE_F ----------------------
2605: ---------------------------------------------------------------
2606: ---------------------------------------------------------------
2607: -- START OF BEN_ELIG_OTHR_PTIP_PRTE_F ----------------------
2608: ---------------------------------------------------------------
2609: cursor c_eoy_from_parent(c_ELIGY_PRFL_ID number) is
2610: select elig_othr_ptip_prte_id
2611: from BEN_ELIG_OTHR_PTIP_PRTE_F

Line 2611: from BEN_ELIG_OTHR_PTIP_PRTE_F

2607: -- START OF BEN_ELIG_OTHR_PTIP_PRTE_F ----------------------
2608: ---------------------------------------------------------------
2609: cursor c_eoy_from_parent(c_ELIGY_PRFL_ID number) is
2610: select elig_othr_ptip_prte_id
2611: from BEN_ELIG_OTHR_PTIP_PRTE_F
2612: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
2613: --
2614: cursor c_eoy(c_elig_othr_ptip_prte_id number,c_mirror_src_entity_result_id number ,
2615: c_table_alias varchar2 ) is

Line 2617: from BEN_ELIG_OTHR_PTIP_PRTE_F eoy

2613: --
2614: cursor c_eoy(c_elig_othr_ptip_prte_id number,c_mirror_src_entity_result_id number ,
2615: c_table_alias varchar2 ) is
2616: select eoy.*
2617: from BEN_ELIG_OTHR_PTIP_PRTE_F eoy
2618: where eoy.elig_othr_ptip_prte_id = c_elig_othr_ptip_prte_id
2619: -- and eoy.business_group_id = p_business_group_id
2620: and not exists (
2621: select /* */ null

Line 2628: -- and trt.where_clause = 'BEN_ELIG_OTHR_PTIP_PRTE_F'

2624: where copy_entity_txn_id = p_copy_entity_txn_id
2625: -- and trt.table_route_id = cpe.table_route_id
2626: and ( -- c_mirror_src_entity_result_id is null or
2627: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
2628: -- and trt.where_clause = 'BEN_ELIG_OTHR_PTIP_PRTE_F'
2629: and cpe.table_alias = c_table_alias
2630: and information1 = c_elig_othr_ptip_prte_id
2631: -- and information4 = eoy.business_group_id
2632: and information2 = eoy.effective_start_date

Line 2638: -- END OF BEN_ELIG_OTHR_PTIP_PRTE_F ----------------------

2634: );
2635: l_elig_othr_ptip_prte_id number(15);
2636: l_out_eoy_result_id number(15);
2637: ---------------------------------------------------------------
2638: -- END OF BEN_ELIG_OTHR_PTIP_PRTE_F ----------------------
2639: ---------------------------------------------------------------
2640: ---------------------------------------------------------------
2641: -- START OF BEN_ELIG_PCT_FL_TM_PRTE_F ----------------------
2642: ---------------------------------------------------------------

Line 8339: -- START OF BEN_ELIG_OTHR_PTIP_PRTE_F ----------------------

8335: ---------------------------------------------------------------
8336: -- END OF BEN_ELIG_ORG_UNIT_PRTE_F ----------------------
8337: ---------------------------------------------------------------
8338: ---------------------------------------------------------------
8339: -- START OF BEN_ELIG_OTHR_PTIP_PRTE_F ----------------------
8340: ---------------------------------------------------------------
8341: --
8342: for l_parent_rec in c_eoy_from_parent(l_ELIGY_PRFL_ID) loop
8343: --

Line 8445: -- END OF BEN_ELIG_OTHR_PTIP_PRTE_F ----------------------

8441: end loop;
8442: --
8443: end loop;
8444: ---------------------------------------------------------------
8445: -- END OF BEN_ELIG_OTHR_PTIP_PRTE_F ----------------------
8446: ---------------------------------------------------------------
8447: ---------------------------------------------------------------
8448: -- START OF BEN_ELIG_PCT_FL_TM_PRTE_F ----------------------
8449: ---------------------------------------------------------------