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_HLTH_CVG_PRTE_F

Line 3748: -- START OF BEN_ELIG_HLTH_CVG_PRTE_F ----------------------

3744: ---------------------------------------------------------------
3745: -- END OF BEN_ELIG_DSBLD_PRTE_F ----------------------
3746: ---------------------------------------------------------------
3747: ---------------------------------------------------------------
3748: -- START OF BEN_ELIG_HLTH_CVG_PRTE_F ----------------------
3749: ---------------------------------------------------------------
3750: cursor c_ehc_from_parent(c_ELIGY_PRFL_ID number) is
3751: select elig_hlth_cvg_prte_id
3752: from BEN_ELIG_HLTH_CVG_PRTE_F

Line 3752: from BEN_ELIG_HLTH_CVG_PRTE_F

3748: -- START OF BEN_ELIG_HLTH_CVG_PRTE_F ----------------------
3749: ---------------------------------------------------------------
3750: cursor c_ehc_from_parent(c_ELIGY_PRFL_ID number) is
3751: select elig_hlth_cvg_prte_id
3752: from BEN_ELIG_HLTH_CVG_PRTE_F
3753: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
3754: --
3755: cursor c_ehc(c_elig_hlth_cvg_prte_id number,c_mirror_src_entity_result_id number ,
3756: c_table_alias varchar2 ) is

Line 3758: from BEN_ELIG_HLTH_CVG_PRTE_F ehc

3754: --
3755: cursor c_ehc(c_elig_hlth_cvg_prte_id number,c_mirror_src_entity_result_id number ,
3756: c_table_alias varchar2 ) is
3757: select ehc.*
3758: from BEN_ELIG_HLTH_CVG_PRTE_F ehc
3759: where ehc.elig_hlth_cvg_prte_id = c_elig_hlth_cvg_prte_id
3760: -- and ehc.business_group_id = p_business_group_id
3761: and not exists (
3762: select /* */ null

Line 3769: -- and trt.where_clause = 'BEN_ELIG_HLTH_CVG_PRTE_F'

3765: where copy_entity_txn_id = p_copy_entity_txn_id
3766: -- and trt.table_route_id = cpe.table_route_id
3767: and ( -- c_mirror_src_entity_result_id is null or
3768: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
3769: -- and trt.where_clause = 'BEN_ELIG_HLTH_CVG_PRTE_F'
3770: and cpe.table_alias = c_table_alias
3771: and information1 = c_elig_hlth_cvg_prte_id
3772: -- and information4 = ehc.business_group_id
3773: and information2 = ehc.effective_start_date

Line 3779: -- END OF BEN_ELIG_HLTH_CVG_PRTE_F ----------------------

3775: );
3776: l_elig_hlth_cvg_prte_id number(15);
3777: l_out_ehc_result_id number(15);
3778: ---------------------------------------------------------------
3779: -- END OF BEN_ELIG_HLTH_CVG_PRTE_F ----------------------
3780: ---------------------------------------------------------------
3781: ---------------------------------------------------------------
3782: -- START OF BEN_ELIG_ANTHR_PL_PRTE_F ----------------------
3783: ---------------------------------------------------------------

Line 11648: -- START OF BEN_ELIG_HLTH_CVG_PRTE_F -------------------------

11644: ---------------------------------------------------------------
11645: -- END OF BEN_ELIG_DSBLD_PRTE_F ----------------------
11646: ---------------------------------------------------------------
11647: ---------------------------------------------------------------
11648: -- START OF BEN_ELIG_HLTH_CVG_PRTE_F -------------------------
11649: ---------------------------------------------------------------
11650: --
11651: for l_parent_rec in c_ehc_from_parent(l_ELIGY_PRFL_ID) loop
11652: --

Line 11749: -- END OF BEN_ELIG_HLTH_CVG_PRTE_F ----------------------

11745: end loop;
11746: --
11747: end loop;
11748: ---------------------------------------------------------------
11749: -- END OF BEN_ELIG_HLTH_CVG_PRTE_F ----------------------
11750: ---------------------------------------------------------------
11751: ---------------------------------------------------------------
11752: -- START OF BEN_ELIG_ANTHR_PL_PRTE_F -------------------------
11753: ---------------------------------------------------------------

Line 11851: -- END OF BEN_ELIG_HLTH_CVG_PRTE_F ----------------------

11847: end loop;
11848: --
11849: end loop;
11850: ---------------------------------------------------------------
11851: -- END OF BEN_ELIG_HLTH_CVG_PRTE_F ----------------------
11852: ---------------------------------------------------------------
11853: --
11854: -- Bug 4169120 : Rate By Criteria
11855: --