APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_HRLY_SLRD_PRTE_F

Line 2114: -- START OF BEN_ELIG_HRLY_SLRD_PRTE_F ----------------------

2110: ---------------------------------------------------------------
2111: -- END OF BEN_ELIG_GRD_PRTE_F ----------------------
2112: ---------------------------------------------------------------
2113: ---------------------------------------------------------------
2114: -- START OF BEN_ELIG_HRLY_SLRD_PRTE_F ----------------------
2115: ---------------------------------------------------------------
2116: cursor c_ehs_from_parent(c_ELIGY_PRFL_ID number) is
2117: select elig_hrly_slrd_prte_id
2118: from BEN_ELIG_HRLY_SLRD_PRTE_F

Line 2118: from BEN_ELIG_HRLY_SLRD_PRTE_F

2114: -- START OF BEN_ELIG_HRLY_SLRD_PRTE_F ----------------------
2115: ---------------------------------------------------------------
2116: cursor c_ehs_from_parent(c_ELIGY_PRFL_ID number) is
2117: select elig_hrly_slrd_prte_id
2118: from BEN_ELIG_HRLY_SLRD_PRTE_F
2119: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
2120: --
2121: cursor c_ehs(c_elig_hrly_slrd_prte_id number,c_mirror_src_entity_result_id number ,
2122: c_table_alias varchar2 ) is

Line 2124: from BEN_ELIG_HRLY_SLRD_PRTE_F ehs

2120: --
2121: cursor c_ehs(c_elig_hrly_slrd_prte_id number,c_mirror_src_entity_result_id number ,
2122: c_table_alias varchar2 ) is
2123: select ehs.*
2124: from BEN_ELIG_HRLY_SLRD_PRTE_F ehs
2125: where ehs.elig_hrly_slrd_prte_id = c_elig_hrly_slrd_prte_id
2126: -- and ehs.business_group_id = p_business_group_id
2127: and not exists (
2128: select /* */ null

Line 2135: -- and trt.where_clause = 'BEN_ELIG_HRLY_SLRD_PRTE_F'

2131: where copy_entity_txn_id = p_copy_entity_txn_id
2132: -- and trt.table_route_id = cpe.table_route_id
2133: and ( -- c_mirror_src_entity_result_id is null or
2134: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
2135: -- and trt.where_clause = 'BEN_ELIG_HRLY_SLRD_PRTE_F'
2136: and cpe.table_alias = c_table_alias
2137: and information1 = c_elig_hrly_slrd_prte_id
2138: -- and information4 = ehs.business_group_id
2139: and information2 = ehs.effective_start_date

Line 2145: -- END OF BEN_ELIG_HRLY_SLRD_PRTE_F ----------------------

2141: );
2142: l_elig_hrly_slrd_prte_id number(15);
2143: l_out_ehs_result_id number(15);
2144: ---------------------------------------------------------------
2145: -- END OF BEN_ELIG_HRLY_SLRD_PRTE_F ----------------------
2146: ---------------------------------------------------------------
2147: ---------------------------------------------------------------
2148: -- START OF BEN_ELIG_HRS_WKD_PRTE_F ----------------------
2149: ---------------------------------------------------------------

Line 6801: -- START OF BEN_ELIG_HRLY_SLRD_PRTE_F ----------------------

6797: ---------------------------------------------------------------
6798: -- END OF BEN_ELIG_GRD_PRTE_F ----------------------
6799: ---------------------------------------------------------------
6800: ---------------------------------------------------------------
6801: -- START OF BEN_ELIG_HRLY_SLRD_PRTE_F ----------------------
6802: ---------------------------------------------------------------
6803: --
6804: for l_parent_rec in c_ehs_from_parent(l_ELIGY_PRFL_ID) loop
6805: --

Line 6903: -- END OF BEN_ELIG_HRLY_SLRD_PRTE_F ----------------------

6899: end loop;
6900: --
6901: end loop;
6902: ---------------------------------------------------------------
6903: -- END OF BEN_ELIG_HRLY_SLRD_PRTE_F ----------------------
6904: ---------------------------------------------------------------
6905: ---------------------------------------------------------------
6906: -- START OF BEN_ELIG_HRS_WKD_PRTE_F ----------------------
6907: ---------------------------------------------------------------