APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_SCHEDD_HRS_PRTE_F

Line 2949: -- START OF BEN_ELIG_SCHEDD_HRS_PRTE_F ----------------------

2945: ---------------------------------------------------------------
2946: -- END OF BEN_ELIG_PY_BSS_PRTE_F ----------------------
2947: ---------------------------------------------------------------
2948: ---------------------------------------------------------------
2949: -- START OF BEN_ELIG_SCHEDD_HRS_PRTE_F ----------------------
2950: ---------------------------------------------------------------
2951: cursor c_esh_from_parent(c_ELIGY_PRFL_ID number) is
2952: select elig_schedd_hrs_prte_id
2953: from BEN_ELIG_SCHEDD_HRS_PRTE_F

Line 2953: from BEN_ELIG_SCHEDD_HRS_PRTE_F

2949: -- START OF BEN_ELIG_SCHEDD_HRS_PRTE_F ----------------------
2950: ---------------------------------------------------------------
2951: cursor c_esh_from_parent(c_ELIGY_PRFL_ID number) is
2952: select elig_schedd_hrs_prte_id
2953: from BEN_ELIG_SCHEDD_HRS_PRTE_F
2954: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
2955: --
2956: cursor c_esh(c_elig_schedd_hrs_prte_id number,c_mirror_src_entity_result_id number ,
2957: c_table_alias varchar2 ) is

Line 2959: from BEN_ELIG_SCHEDD_HRS_PRTE_F esh

2955: --
2956: cursor c_esh(c_elig_schedd_hrs_prte_id number,c_mirror_src_entity_result_id number ,
2957: c_table_alias varchar2 ) is
2958: select esh.*
2959: from BEN_ELIG_SCHEDD_HRS_PRTE_F esh
2960: where esh.elig_schedd_hrs_prte_id = c_elig_schedd_hrs_prte_id
2961: -- and esh.business_group_id = p_business_group_id
2962: and not exists (
2963: select /* */ null

Line 2970: -- and trt.where_clause = 'BEN_ELIG_SCHEDD_HRS_PRTE_F'

2966: where copy_entity_txn_id = p_copy_entity_txn_id
2967: -- and trt.table_route_id = cpe.table_route_id
2968: and ( -- c_mirror_src_entity_result_id is null or
2969: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
2970: -- and trt.where_clause = 'BEN_ELIG_SCHEDD_HRS_PRTE_F'
2971: and cpe.table_alias = c_table_alias
2972: and information1 = c_elig_schedd_hrs_prte_id
2973: -- and information4 = esh.business_group_id
2974: and information2 = esh.effective_start_date

Line 2980: -- END OF BEN_ELIG_SCHEDD_HRS_PRTE_F ----------------------

2976: );
2977: l_elig_schedd_hrs_prte_id number(15);
2978: l_out_esh_result_id number(15);
2979: ---------------------------------------------------------------
2980: -- END OF BEN_ELIG_SCHEDD_HRS_PRTE_F ----------------------
2981: ---------------------------------------------------------------
2982: ---------------------------------------------------------------
2983: -- START OF BEN_ELIG_SVC_AREA_PRTE_F ----------------------
2984: ---------------------------------------------------------------

Line 9321: -- START OF BEN_ELIG_SCHEDD_HRS_PRTE_F ----------------------

9317: ---------------------------------------------------------------
9318: -- END OF BEN_ELIG_PY_BSS_PRTE_F ----------------------
9319: ---------------------------------------------------------------
9320: ---------------------------------------------------------------
9321: -- START OF BEN_ELIG_SCHEDD_HRS_PRTE_F ----------------------
9322: ---------------------------------------------------------------
9323: --
9324: for l_parent_rec in c_esh_from_parent(l_ELIGY_PRFL_ID) loop
9325: --

Line 9476: -- END OF BEN_ELIG_SCHEDD_HRS_PRTE_F ----------------------

9472: end loop;
9473: --
9474: end loop;
9475: ---------------------------------------------------------------
9476: -- END OF BEN_ELIG_SCHEDD_HRS_PRTE_F ----------------------
9477: ---------------------------------------------------------------
9478: ---------------------------------------------------------------
9479: -- START OF BEN_ELIG_SVC_AREA_PRTE_F ----------------------
9480: ---------------------------------------------------------------