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_AGE_CVG_F

Line 12375: -- START OF BEN_ELIG_AGE_CVG_F ----------------------

12371: ---------------------------------------------------------------
12372: -- END OF BEN_DSGNTR_ENRLD_CVG_F ----------------------
12373: ---------------------------------------------------------------
12374: ---------------------------------------------------------------
12375: -- START OF BEN_ELIG_AGE_CVG_F ----------------------
12376: ---------------------------------------------------------------
12377: cursor c_eac_from_parent(c_DPNT_CVG_ELIGY_PRFL_ID number) is
12378: select distinct elig_age_cvg_id
12379: from BEN_ELIG_AGE_CVG_F

Line 12379: from BEN_ELIG_AGE_CVG_F

12375: -- START OF BEN_ELIG_AGE_CVG_F ----------------------
12376: ---------------------------------------------------------------
12377: cursor c_eac_from_parent(c_DPNT_CVG_ELIGY_PRFL_ID number) is
12378: select distinct elig_age_cvg_id
12379: from BEN_ELIG_AGE_CVG_F
12380: where DPNT_CVG_ELIGY_PRFL_ID = c_DPNT_CVG_ELIGY_PRFL_ID ;
12381: --
12382: cursor c_eac(c_elig_age_cvg_id number,c_mirror_src_entity_result_id number ,
12383: c_table_alias varchar2 ) is

Line 12385: from BEN_ELIG_AGE_CVG_F eac

12381: --
12382: cursor c_eac(c_elig_age_cvg_id number,c_mirror_src_entity_result_id number ,
12383: c_table_alias varchar2 ) is
12384: select eac.*
12385: from BEN_ELIG_AGE_CVG_F eac
12386: where eac.elig_age_cvg_id = c_elig_age_cvg_id
12387: -- and eac.business_group_id = p_business_group_id
12388: and not exists (
12389: select /* */ null

Line 12396: -- and trt.where_clause = 'BEN_ELIG_AGE_CVG_F'

12392: where copy_entity_txn_id = p_copy_entity_txn_id
12393: -- and trt.table_route_id = cpe.table_route_id
12394: and ( -- c_mirror_src_entity_result_id is null or
12395: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
12396: -- and trt.where_clause = 'BEN_ELIG_AGE_CVG_F'
12397: and cpe.table_alias = c_table_alias
12398: and information1 = c_elig_age_cvg_id
12399: -- and information4 = eac.business_group_id
12400: and information2 = eac.effective_start_date

Line 12414: -- and trt.where_clause = 'BEN_ELIG_AGE_CVG_F'

12410: -- pqh_table_route trt
12411: where copy_entity_txn_id = p_copy_entity_txn_id
12412: -- and trt.table_route_id = cpe.table_route_id
12413: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
12414: -- and trt.where_clause = 'BEN_ELIG_AGE_CVG_F'
12415: and cpe.table_alias = c_table_alias
12416: and information1 = c_elig_age_cvg_id
12417: -- and information4 = p_business_group_id
12418: ;

Line 12420: -- END OF BEN_ELIG_AGE_CVG_F ----------------------

12416: and information1 = c_elig_age_cvg_id
12417: -- and information4 = p_business_group_id
12418: ;
12419: ---------------------------------------------------------------
12420: -- END OF BEN_ELIG_AGE_CVG_F ----------------------
12421: ---------------------------------------------------------------
12422: ---------------------------------------------------------------
12423: -- START OF BEN_ELIG_DSBLD_STAT_CVG_F ----------------------
12424: ---------------------------------------------------------------

Line 13099: -- START OF BEN_ELIG_AGE_CVG_F ----------------------

13095: ---------------------------------------------------------------
13096: -- END OF BEN_DSGNTR_ENRLD_CVG_F ----------------------
13097: ---------------------------------------------------------------
13098: ---------------------------------------------------------------
13099: -- START OF BEN_ELIG_AGE_CVG_F ----------------------
13100: ---------------------------------------------------------------
13101: --
13102: for l_parent_rec in c_eac_from_parent(l_DPNT_CVG_ELIGY_PRFL_ID) loop
13103: --

Line 13244: -- END OF BEN_ELIG_AGE_CVG_F ----------------------

13240: );
13241: end loop;
13242: end loop;
13243: ---------------------------------------------------------------
13244: -- END OF BEN_ELIG_AGE_CVG_F ----------------------
13245: ---------------------------------------------------------------
13246: ---------------------------------------------------------------
13247: -- START OF BEN_ELIG_DSBLD_STAT_CVG_F ----------------------
13248: ---------------------------------------------------------------