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_LOS_PRTE_F

Line 2407: -- START OF BEN_ELIG_LOS_PRTE_F ----------------------

2403: ---------------------------------------------------------------
2404: -- END OF BEN_ELIG_LOA_RSN_PRTE_F ----------------------
2405: ---------------------------------------------------------------
2406: ---------------------------------------------------------------
2407: -- START OF BEN_ELIG_LOS_PRTE_F ----------------------
2408: ---------------------------------------------------------------
2409: cursor c_els_from_parent(c_ELIGY_PRFL_ID number) is
2410: select distinct elig_los_prte_id
2411: from BEN_ELIG_LOS_PRTE_F

Line 2411: from BEN_ELIG_LOS_PRTE_F

2407: -- START OF BEN_ELIG_LOS_PRTE_F ----------------------
2408: ---------------------------------------------------------------
2409: cursor c_els_from_parent(c_ELIGY_PRFL_ID number) is
2410: select distinct elig_los_prte_id
2411: from BEN_ELIG_LOS_PRTE_F
2412: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
2413: --
2414: cursor c_els(c_elig_los_prte_id number,c_mirror_src_entity_result_id number ,
2415: c_table_alias varchar2 ) is

Line 2417: from BEN_ELIG_LOS_PRTE_F els

2413: --
2414: cursor c_els(c_elig_los_prte_id number,c_mirror_src_entity_result_id number ,
2415: c_table_alias varchar2 ) is
2416: select els.*
2417: from BEN_ELIG_LOS_PRTE_F els
2418: where els.elig_los_prte_id = c_elig_los_prte_id
2419: -- and els.business_group_id = p_business_group_id
2420: and not exists (
2421: select /* */ null

Line 2428: -- and trt.where_clause = 'BEN_ELIG_LOS_PRTE_F'

2424: where copy_entity_txn_id = p_copy_entity_txn_id
2425: -- and trt.table_route_id = cpe.table_route_id
2426: and ( -- c_mirror_src_entity_result_id is null or
2427: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
2428: -- and trt.where_clause = 'BEN_ELIG_LOS_PRTE_F'
2429: and cpe.table_alias = c_table_alias
2430: and information1 = c_elig_los_prte_id
2431: -- and information4 = els.business_group_id
2432: and information2 = els.effective_start_date

Line 2447: -- and trt.where_clause = 'BEN_ELIG_LOS_PRTE_F'

2443: -- pqh_table_route trt
2444: where copy_entity_txn_id = p_copy_entity_txn_id
2445: -- and trt.table_route_id = cpe.table_route_id
2446: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
2447: -- and trt.where_clause = 'BEN_ELIG_LOS_PRTE_F'
2448: and cpe.table_alias = c_table_alias
2449: and information1 = c_elig_los_prte_id
2450: -- and information4 = p_business_group_id
2451: ;

Line 2453: -- END OF BEN_ELIG_LOS_PRTE_F ----------------------

2449: and information1 = c_elig_los_prte_id
2450: -- and information4 = p_business_group_id
2451: ;
2452: ---------------------------------------------------------------
2453: -- END OF BEN_ELIG_LOS_PRTE_F ----------------------
2454: ---------------------------------------------------------------
2455: ---------------------------------------------------------------
2456: -- START OF BEN_ELIG_LVG_RSN_PRTE_F ----------------------
2457: ---------------------------------------------------------------

Line 7761: -- START OF BEN_ELIG_LOS_PRTE_F ----------------------

7757: ---------------------------------------------------------------
7758: -- END OF BEN_ELIG_LOA_RSN_PRTE_F ----------------------
7759: ---------------------------------------------------------------
7760: ---------------------------------------------------------------
7761: -- START OF BEN_ELIG_LOS_PRTE_F ----------------------
7762: ---------------------------------------------------------------
7763: --
7764: for l_parent_rec in c_els_from_parent(l_ELIGY_PRFL_ID) loop
7765: --

Line 7881: -- END OF BEN_ELIG_LOS_PRTE_F ----------------------

7877: );
7878: end loop;
7879: end loop;
7880: ---------------------------------------------------------------
7881: -- END OF BEN_ELIG_LOS_PRTE_F ----------------------
7882: ---------------------------------------------------------------
7883: ---------------------------------------------------------------
7884: -- START OF BEN_ELIG_LVG_RSN_PRTE_F ----------------------
7885: ---------------------------------------------------------------