eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_HRS_WKD_PRTE_F

Line 2148: -- START OF BEN_ELIG_HRS_WKD_PRTE_F ----------------------

2144: ---------------------------------------------------------------
2145: -- END OF BEN_ELIG_HRLY_SLRD_PRTE_F ----------------------
2146: ---------------------------------------------------------------
2147: ---------------------------------------------------------------
2148: -- START OF BEN_ELIG_HRS_WKD_PRTE_F ----------------------
2149: ---------------------------------------------------------------
2150: cursor c_ehw_from_parent(c_ELIGY_PRFL_ID number) is
2151: select distinct elig_hrs_wkd_prte_id
2152: from BEN_ELIG_HRS_WKD_PRTE_F

Line 2152: from BEN_ELIG_HRS_WKD_PRTE_F

2148: -- START OF BEN_ELIG_HRS_WKD_PRTE_F ----------------------
2149: ---------------------------------------------------------------
2150: cursor c_ehw_from_parent(c_ELIGY_PRFL_ID number) is
2151: select distinct elig_hrs_wkd_prte_id
2152: from BEN_ELIG_HRS_WKD_PRTE_F
2153: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
2154: --
2155: cursor c_ehw(c_elig_hrs_wkd_prte_id number,c_mirror_src_entity_result_id number ,
2156: c_table_alias varchar2 ) is

Line 2158: from BEN_ELIG_HRS_WKD_PRTE_F ehw

2154: --
2155: cursor c_ehw(c_elig_hrs_wkd_prte_id number,c_mirror_src_entity_result_id number ,
2156: c_table_alias varchar2 ) is
2157: select ehw.*
2158: from BEN_ELIG_HRS_WKD_PRTE_F ehw
2159: where ehw.elig_hrs_wkd_prte_id = c_elig_hrs_wkd_prte_id
2160: -- and ehw.business_group_id = p_business_group_id
2161: and not exists (
2162: select /* */ null

Line 2169: -- and trt.where_clause = 'BEN_ELIG_HRS_WKD_PRTE_F'

2165: where copy_entity_txn_id = p_copy_entity_txn_id
2166: -- and trt.table_route_id = cpe.table_route_id
2167: and ( -- c_mirror_src_entity_result_id is null or
2168: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
2169: -- and trt.where_clause = 'BEN_ELIG_HRS_WKD_PRTE_F'
2170: and cpe.table_alias = c_table_alias
2171: and information1 = c_elig_hrs_wkd_prte_id
2172: -- and information4 = ehw.business_group_id
2173: and information2 = ehw.effective_start_date

Line 2187: -- and trt.where_clause = 'BEN_ELIG_HRS_WKD_PRTE_F'

2183: -- pqh_table_route trt
2184: where copy_entity_txn_id = p_copy_entity_txn_id
2185: -- and trt.table_route_id = cpe.table_route_id
2186: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
2187: -- and trt.where_clause = 'BEN_ELIG_HRS_WKD_PRTE_F'
2188: and cpe.table_alias = c_table_alias
2189: and information1 = c_elig_hrs_wkd_prte_id
2190: -- and information4 = p_business_group_id
2191: ;

Line 2193: -- END OF BEN_ELIG_HRS_WKD_PRTE_F ----------------------

2189: and information1 = c_elig_hrs_wkd_prte_id
2190: -- and information4 = p_business_group_id
2191: ;
2192: ---------------------------------------------------------------
2193: -- END OF BEN_ELIG_HRS_WKD_PRTE_F ----------------------
2194: ---------------------------------------------------------------
2195: ---------------------------------------------------------------
2196: -- START OF BEN_ELIG_JOB_PRTE_F ----------------------
2197: ---------------------------------------------------------------

Line 6906: -- START OF BEN_ELIG_HRS_WKD_PRTE_F ----------------------

6902: ---------------------------------------------------------------
6903: -- END OF BEN_ELIG_HRLY_SLRD_PRTE_F ----------------------
6904: ---------------------------------------------------------------
6905: ---------------------------------------------------------------
6906: -- START OF BEN_ELIG_HRS_WKD_PRTE_F ----------------------
6907: ---------------------------------------------------------------
6908: --
6909: for l_parent_rec in c_ehw_from_parent(l_ELIGY_PRFL_ID) loop
6910: --

Line 7026: -- END OF BEN_ELIG_HRS_WKD_PRTE_F ----------------------

7022: );
7023: end loop;
7024: end loop;
7025: ---------------------------------------------------------------
7026: -- END OF BEN_ELIG_HRS_WKD_PRTE_F ----------------------
7027: ---------------------------------------------------------------
7028: ---------------------------------------------------------------
7029: -- START OF BEN_ELIG_JOB_PRTE_F ----------------------
7030: ---------------------------------------------------------------