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_PCT_FL_TM_PRTE_F

Line 2641: -- START OF BEN_ELIG_PCT_FL_TM_PRTE_F ----------------------

2637: ---------------------------------------------------------------
2638: -- END OF BEN_ELIG_OTHR_PTIP_PRTE_F ----------------------
2639: ---------------------------------------------------------------
2640: ---------------------------------------------------------------
2641: -- START OF BEN_ELIG_PCT_FL_TM_PRTE_F ----------------------
2642: ---------------------------------------------------------------
2643: cursor c_epf_from_parent(c_ELIGY_PRFL_ID number) is
2644: select distinct elig_pct_fl_tm_prte_id
2645: from BEN_ELIG_PCT_FL_TM_PRTE_F

Line 2645: from BEN_ELIG_PCT_FL_TM_PRTE_F

2641: -- START OF BEN_ELIG_PCT_FL_TM_PRTE_F ----------------------
2642: ---------------------------------------------------------------
2643: cursor c_epf_from_parent(c_ELIGY_PRFL_ID number) is
2644: select distinct elig_pct_fl_tm_prte_id
2645: from BEN_ELIG_PCT_FL_TM_PRTE_F
2646: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
2647: --
2648: cursor c_epf(c_elig_pct_fl_tm_prte_id number,c_mirror_src_entity_result_id number ,
2649: c_table_alias varchar2 ) is

Line 2651: from BEN_ELIG_PCT_FL_TM_PRTE_F epf

2647: --
2648: cursor c_epf(c_elig_pct_fl_tm_prte_id number,c_mirror_src_entity_result_id number ,
2649: c_table_alias varchar2 ) is
2650: select epf.*
2651: from BEN_ELIG_PCT_FL_TM_PRTE_F epf
2652: where epf.elig_pct_fl_tm_prte_id = c_elig_pct_fl_tm_prte_id
2653: -- and epf.business_group_id = p_business_group_id
2654: and not exists (
2655: select /* */ null

Line 2662: -- and trt.where_clause = 'BEN_ELIG_PCT_FL_TM_PRTE_F'

2658: where copy_entity_txn_id = p_copy_entity_txn_id
2659: -- and trt.table_route_id = cpe.table_route_id
2660: and ( -- c_mirror_src_entity_result_id is null or
2661: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
2662: -- and trt.where_clause = 'BEN_ELIG_PCT_FL_TM_PRTE_F'
2663: and cpe.table_alias = c_table_alias
2664: and information1 = c_elig_pct_fl_tm_prte_id
2665: -- and information4 = epf.business_group_id
2666: and information2 = epf.effective_start_date

Line 2680: -- and trt.where_clause = 'BEN_ELIG_PCT_FL_TM_PRTE_F'

2676: -- pqh_table_route trt
2677: where copy_entity_txn_id = p_copy_entity_txn_id
2678: -- and trt.table_route_id = cpe.table_route_id
2679: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
2680: -- and trt.where_clause = 'BEN_ELIG_PCT_FL_TM_PRTE_F'
2681: and cpe.table_alias = c_table_alias
2682: and information1 = c_elig_pct_fl_tm_prte_id
2683: -- and information4 = p_business_group_id
2684: ;

Line 2686: -- END OF BEN_ELIG_PCT_FL_TM_PRTE_F ----------------------

2682: and information1 = c_elig_pct_fl_tm_prte_id
2683: -- and information4 = p_business_group_id
2684: ;
2685: ---------------------------------------------------------------
2686: -- END OF BEN_ELIG_PCT_FL_TM_PRTE_F ----------------------
2687: ---------------------------------------------------------------
2688: ---------------------------------------------------------------
2689: -- START OF BEN_ELIG_PER_TYP_PRTE_F ----------------------
2690: ---------------------------------------------------------------

Line 8448: -- START OF BEN_ELIG_PCT_FL_TM_PRTE_F ----------------------

8444: ---------------------------------------------------------------
8445: -- END OF BEN_ELIG_OTHR_PTIP_PRTE_F ----------------------
8446: ---------------------------------------------------------------
8447: ---------------------------------------------------------------
8448: -- START OF BEN_ELIG_PCT_FL_TM_PRTE_F ----------------------
8449: ---------------------------------------------------------------
8450: --
8451: for l_parent_rec in c_epf_from_parent(l_ELIGY_PRFL_ID) loop
8452: --

Line 8569: -- END OF BEN_ELIG_PCT_FL_TM_PRTE_F ----------------------

8565: );
8566: end loop;
8567: end loop;
8568: ---------------------------------------------------------------
8569: -- END OF BEN_ELIG_PCT_FL_TM_PRTE_F ----------------------
8570: ---------------------------------------------------------------
8571: ---------------------------------------------------------------
8572: -- START OF BEN_ELIG_PER_TYP_PRTE_F ----------------------
8573: ---------------------------------------------------------------