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_CVG_F

Line 12525: -- START OF BEN_ELIG_PSTL_CD_R_RNG_CVG_F ----------------------

12521: ---------------------------------------------------------------
12522: -- END OF BEN_ELIG_MRTL_STAT_CVG_F ----------------------
12523: ---------------------------------------------------------------
12524: ---------------------------------------------------------------
12525: -- START OF BEN_ELIG_PSTL_CD_R_RNG_CVG_F ----------------------
12526: ---------------------------------------------------------------
12527: cursor c_epl_from_parent(c_DPNT_CVG_ELIGY_PRFL_ID number) is
12528: select distinct elig_pstl_cd_r_rng_cvg_id
12529: from BEN_ELIG_PSTL_CD_R_RNG_CVG_F

Line 12529: from BEN_ELIG_PSTL_CD_R_RNG_CVG_F

12525: -- START OF BEN_ELIG_PSTL_CD_R_RNG_CVG_F ----------------------
12526: ---------------------------------------------------------------
12527: cursor c_epl_from_parent(c_DPNT_CVG_ELIGY_PRFL_ID number) is
12528: select distinct elig_pstl_cd_r_rng_cvg_id
12529: from BEN_ELIG_PSTL_CD_R_RNG_CVG_F
12530: where DPNT_CVG_ELIGY_PRFL_ID = c_DPNT_CVG_ELIGY_PRFL_ID ;
12531: --
12532: cursor c_epl(c_elig_pstl_cd_r_rng_cvg_id number,c_mirror_src_entity_result_id number ,
12533: c_table_alias varchar2 ) is

Line 12535: from BEN_ELIG_PSTL_CD_R_RNG_CVG_F epl

12531: --
12532: cursor c_epl(c_elig_pstl_cd_r_rng_cvg_id number,c_mirror_src_entity_result_id number ,
12533: c_table_alias varchar2 ) is
12534: select epl.*
12535: from BEN_ELIG_PSTL_CD_R_RNG_CVG_F epl
12536: where epl.elig_pstl_cd_r_rng_cvg_id = c_elig_pstl_cd_r_rng_cvg_id
12537: -- and epl.business_group_id = p_business_group_id
12538: and not exists (
12539: select /* */ null

Line 12546: -- and trt.where_clause = 'BEN_ELIG_PSTL_CD_R_RNG_CVG_F'

12542: where copy_entity_txn_id = p_copy_entity_txn_id
12543: -- and trt.table_route_id = cpe.table_route_id
12544: and ( -- c_mirror_src_entity_result_id is null or
12545: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
12546: -- and trt.where_clause = 'BEN_ELIG_PSTL_CD_R_RNG_CVG_F'
12547: and cpe.table_alias = c_table_alias
12548: and information1 = c_elig_pstl_cd_r_rng_cvg_id
12549: -- and information4 = epl.business_group_id
12550: and information2 = epl.effective_start_date

Line 12564: -- and trt.where_clause = 'BEN_ELIG_PSTL_CD_R_RNG_CVG_F'

12560: -- pqh_table_route trt
12561: where copy_entity_txn_id = p_copy_entity_txn_id
12562: -- and trt.table_route_id = cpe.table_route_id
12563: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
12564: -- and trt.where_clause = 'BEN_ELIG_PSTL_CD_R_RNG_CVG_F'
12565: and cpe.table_alias = c_table_alias
12566: and information1 = c_elig_pstl_cd_r_rng_cvg_id
12567: -- and information4 = p_business_group_id
12568: ;

Line 12570: -- END OF BEN_ELIG_PSTL_CD_R_RNG_CVG_F ----------------------

12566: and information1 = c_elig_pstl_cd_r_rng_cvg_id
12567: -- and information4 = p_business_group_id
12568: ;
12569: ---------------------------------------------------------------
12570: -- END OF BEN_ELIG_PSTL_CD_R_RNG_CVG_F ----------------------
12571: ---------------------------------------------------------------
12572: ---------------------------------------------------------------
12573: -- START OF BEN_ELIG_STDNT_STAT_CVG_F ----------------------
12574: ---------------------------------------------------------------

Line 13634: -- START OF BEN_ELIG_PSTL_CD_R_RNG_CVG_F ----------------------

13630: ---------------------------------------------------------------
13631: -- END OF BEN_ELIG_MRTL_STAT_CVG_F ----------------------
13632: ---------------------------------------------------------------
13633: ---------------------------------------------------------------
13634: -- START OF BEN_ELIG_PSTL_CD_R_RNG_CVG_F ----------------------
13635: ---------------------------------------------------------------
13636: --
13637: for l_parent_rec in c_epl_from_parent(l_DPNT_CVG_ELIGY_PRFL_ID) loop
13638: --

Line 13748: -- END OF BEN_ELIG_PSTL_CD_R_RNG_CVG_F ----------------------

13744: ) ;
13745: end loop;
13746: end loop;
13747: ---------------------------------------------------------------
13748: -- END OF BEN_ELIG_PSTL_CD_R_RNG_CVG_F ----------------------
13749: ---------------------------------------------------------------
13750: ---------------------------------------------------------------
13751: -- START OF BEN_ELIG_STDNT_STAT_CVG_F ----------------------
13752: ---------------------------------------------------------------