APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_PER_TYP_PRTE_F

Line 2689: -- START OF BEN_ELIG_PER_TYP_PRTE_F ----------------------

2685: ---------------------------------------------------------------
2686: -- END OF BEN_ELIG_PCT_FL_TM_PRTE_F ----------------------
2687: ---------------------------------------------------------------
2688: ---------------------------------------------------------------
2689: -- START OF BEN_ELIG_PER_TYP_PRTE_F ----------------------
2690: ---------------------------------------------------------------
2691: cursor c_ept_from_parent(c_ELIGY_PRFL_ID number) is
2692: select elig_per_typ_prte_id
2693: from BEN_ELIG_PER_TYP_PRTE_F

Line 2693: from BEN_ELIG_PER_TYP_PRTE_F

2689: -- START OF BEN_ELIG_PER_TYP_PRTE_F ----------------------
2690: ---------------------------------------------------------------
2691: cursor c_ept_from_parent(c_ELIGY_PRFL_ID number) is
2692: select elig_per_typ_prte_id
2693: from BEN_ELIG_PER_TYP_PRTE_F
2694: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
2695: --
2696: cursor c_ept(c_elig_per_typ_prte_id number,c_mirror_src_entity_result_id number ,
2697: c_table_alias varchar2 ) is

Line 2699: from BEN_ELIG_PER_TYP_PRTE_F ept

2695: --
2696: cursor c_ept(c_elig_per_typ_prte_id number,c_mirror_src_entity_result_id number ,
2697: c_table_alias varchar2 ) is
2698: select ept.*
2699: from BEN_ELIG_PER_TYP_PRTE_F ept
2700: where ept.elig_per_typ_prte_id = c_elig_per_typ_prte_id
2701: -- and ept.business_group_id = p_business_group_id
2702: and not exists (
2703: select /* */ null

Line 2710: -- and trt.where_clause = 'BEN_ELIG_PER_TYP_PRTE_F'

2706: where copy_entity_txn_id = p_copy_entity_txn_id
2707: -- and trt.table_route_id = cpe.table_route_id
2708: and ( -- c_mirror_src_entity_result_id is null or
2709: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
2710: -- and trt.where_clause = 'BEN_ELIG_PER_TYP_PRTE_F'
2711: and cpe.table_alias = c_table_alias
2712: and information1 = c_elig_per_typ_prte_id
2713: -- and information4 = ept.business_group_id
2714: and information2 = ept.effective_start_date

Line 2740: -- END OF BEN_ELIG_PER_TYP_PRTE_F ----------------------

2736: l_mapping_person_type_id number;
2737: l_mapping_person_type_name varchar2(600);
2738: l_information172 varchar2(300);
2739: ---------------------------------------------------------------
2740: -- END OF BEN_ELIG_PER_TYP_PRTE_F ----------------------
2741: ---------------------------------------------------------------
2742: ---------------------------------------------------------------
2743: -- START OF BEN_ELIG_PPL_GRP_PRTE_F ----------------------
2744: ---------------------------------------------------------------

Line 8572: -- START OF BEN_ELIG_PER_TYP_PRTE_F ----------------------

8568: ---------------------------------------------------------------
8569: -- END OF BEN_ELIG_PCT_FL_TM_PRTE_F ----------------------
8570: ---------------------------------------------------------------
8571: ---------------------------------------------------------------
8572: -- START OF BEN_ELIG_PER_TYP_PRTE_F ----------------------
8573: ---------------------------------------------------------------
8574: --
8575: for l_parent_rec in c_ept_from_parent(l_ELIGY_PRFL_ID) loop
8576: --

Line 8706: -- END OF BEN_ELIG_PER_TYP_PRTE_F ----------------------

8702: end loop;
8703: --
8704: end loop;
8705: ---------------------------------------------------------------
8706: -- END OF BEN_ELIG_PER_TYP_PRTE_F ----------------------
8707: ---------------------------------------------------------------
8708: ---------------------------------------------------------------
8709: -- START OF BEN_ELIG_PPL_GRP_PRTE_F ----------------------
8710: ---------------------------------------------------------------