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_PSTL_CD_R_RNG_PRTE_F

Line 2811: -- START OF BEN_ELIG_PSTL_CD_R_RNG_PRTE_F ----------------------

2807: ---------------------------------------------------------------
2808: -- END OF BEN_ELIG_PRTT_ANTHR_PL_PRTE_F ----------------------
2809: ---------------------------------------------------------------
2810: ---------------------------------------------------------------
2811: -- START OF BEN_ELIG_PSTL_CD_R_RNG_PRTE_F ----------------------
2812: ---------------------------------------------------------------
2813: cursor c_epz_from_parent(c_ELIGY_PRFL_ID number) is
2814: select distinct elig_pstl_cd_r_rng_prte_id
2815: from BEN_ELIG_PSTL_CD_R_RNG_PRTE_F

Line 2815: from BEN_ELIG_PSTL_CD_R_RNG_PRTE_F

2811: -- START OF BEN_ELIG_PSTL_CD_R_RNG_PRTE_F ----------------------
2812: ---------------------------------------------------------------
2813: cursor c_epz_from_parent(c_ELIGY_PRFL_ID number) is
2814: select distinct elig_pstl_cd_r_rng_prte_id
2815: from BEN_ELIG_PSTL_CD_R_RNG_PRTE_F
2816: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
2817: --
2818: cursor c_epz(c_elig_pstl_cd_r_rng_prte_id number,c_mirror_src_entity_result_id number ,
2819: c_table_alias varchar2 ) is

Line 2821: from BEN_ELIG_PSTL_CD_R_RNG_PRTE_F epz

2817: --
2818: cursor c_epz(c_elig_pstl_cd_r_rng_prte_id number,c_mirror_src_entity_result_id number ,
2819: c_table_alias varchar2 ) is
2820: select epz.*
2821: from BEN_ELIG_PSTL_CD_R_RNG_PRTE_F epz
2822: where epz.elig_pstl_cd_r_rng_prte_id = c_elig_pstl_cd_r_rng_prte_id
2823: -- and epz.business_group_id = p_business_group_id
2824: and not exists (
2825: select /* */ null

Line 2832: -- and trt.where_clause = 'BEN_ELIG_PSTL_CD_R_RNG_PRTE_F'

2828: where copy_entity_txn_id = p_copy_entity_txn_id
2829: -- and trt.table_route_id = cpe.table_route_id
2830: and ( -- c_mirror_src_entity_result_id is null or
2831: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
2832: -- and trt.where_clause = 'BEN_ELIG_PSTL_CD_R_RNG_PRTE_F'
2833: and cpe.table_alias = c_table_alias
2834: and information1 = c_elig_pstl_cd_r_rng_prte_id
2835: -- and information4 = epz.business_group_id
2836: and information2 = epz.effective_start_date

Line 2850: -- and trt.where_clause = 'BEN_ELIG_PSTL_CD_R_RNG_PRTE_F'

2846: -- pqh_table_route trt
2847: where copy_entity_txn_id = p_copy_entity_txn_id
2848: -- and trt.table_route_id = cpe.table_route_id
2849: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
2850: -- and trt.where_clause = 'BEN_ELIG_PSTL_CD_R_RNG_PRTE_F'
2851: and cpe.table_alias = c_table_alias
2852: and information1 = c_elig_pstl_cd_r_rng_prte_id
2853: -- and information4 = p_business_group_id
2854: ;

Line 2856: -- END OF BEN_ELIG_PSTL_CD_R_RNG_PRTE_F ----------------------

2852: and information1 = c_elig_pstl_cd_r_rng_prte_id
2853: -- and information4 = p_business_group_id
2854: ;
2855: ---------------------------------------------------------------
2856: -- END OF BEN_ELIG_PSTL_CD_R_RNG_PRTE_F ----------------------
2857: ---------------------------------------------------------------
2858: ---------------------------------------------------------------
2859: -- START OF BEN_ELIG_PYRL_PRTE_F ----------------------
2860: ---------------------------------------------------------------

Line 8919: -- START OF BEN_ELIG_PSTL_CD_R_RNG_PRTE_F ----------------------

8915: ---------------------------------------------------------------
8916: -- END OF BEN_ELIG_PRTT_ANTHR_PL_PRTE_F ----------------------
8917: ---------------------------------------------------------------
8918: ---------------------------------------------------------------
8919: -- START OF BEN_ELIG_PSTL_CD_R_RNG_PRTE_F ----------------------
8920: ---------------------------------------------------------------
8921: --
8922: for l_parent_rec in c_epz_from_parent(l_ELIGY_PRFL_ID) loop
8923: --

Line 9035: -- END OF BEN_ELIG_PSTL_CD_R_RNG_PRTE_F ----------------------

9031: ) ;
9032: end loop;
9033: end loop;
9034: ---------------------------------------------------------------
9035: -- END OF BEN_ELIG_PSTL_CD_R_RNG_PRTE_F ----------------------
9036: ---------------------------------------------------------------
9037: ---------------------------------------------------------------
9038: -- START OF BEN_ELIG_PYRL_PRTE_F ----------------------
9039: ---------------------------------------------------------------