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_MLTRY_STAT_CVG_F

Line 12457: -- START OF BEN_ELIG_MLTRY_STAT_CVG_F ----------------------

12453: ---------------------------------------------------------------
12454: -- END OF BEN_ELIG_DSBLD_STAT_CVG_F ----------------------
12455: ---------------------------------------------------------------
12456: ---------------------------------------------------------------
12457: -- START OF BEN_ELIG_MLTRY_STAT_CVG_F ----------------------
12458: ---------------------------------------------------------------
12459: cursor c_emc_from_parent(c_DPNT_CVG_ELIGY_PRFL_ID number) is
12460: select elig_mltry_stat_cvg_id
12461: from BEN_ELIG_MLTRY_STAT_CVG_F

Line 12461: from BEN_ELIG_MLTRY_STAT_CVG_F

12457: -- START OF BEN_ELIG_MLTRY_STAT_CVG_F ----------------------
12458: ---------------------------------------------------------------
12459: cursor c_emc_from_parent(c_DPNT_CVG_ELIGY_PRFL_ID number) is
12460: select elig_mltry_stat_cvg_id
12461: from BEN_ELIG_MLTRY_STAT_CVG_F
12462: where DPNT_CVG_ELIGY_PRFL_ID = c_DPNT_CVG_ELIGY_PRFL_ID ;
12463: --
12464: cursor c_emc(c_elig_mltry_stat_cvg_id number,c_mirror_src_entity_result_id number ,
12465: c_table_alias varchar2 ) is

Line 12467: from BEN_ELIG_MLTRY_STAT_CVG_F emc

12463: --
12464: cursor c_emc(c_elig_mltry_stat_cvg_id number,c_mirror_src_entity_result_id number ,
12465: c_table_alias varchar2 ) is
12466: select emc.*
12467: from BEN_ELIG_MLTRY_STAT_CVG_F emc
12468: where emc.elig_mltry_stat_cvg_id = c_elig_mltry_stat_cvg_id
12469: -- and emc.business_group_id = p_business_group_id
12470: and not exists (
12471: select /* */ null

Line 12478: -- and trt.where_clause = 'BEN_ELIG_MLTRY_STAT_CVG_F'

12474: where copy_entity_txn_id = p_copy_entity_txn_id
12475: -- and trt.table_route_id = cpe.table_route_id
12476: and ( -- c_mirror_src_entity_result_id is null or
12477: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
12478: -- and trt.where_clause = 'BEN_ELIG_MLTRY_STAT_CVG_F'
12479: and cpe.table_alias = c_table_alias
12480: and information1 = c_elig_mltry_stat_cvg_id
12481: -- and information4 = emc.business_group_id
12482: and information2 = emc.effective_start_date

Line 12488: -- END OF BEN_ELIG_MLTRY_STAT_CVG_F ----------------------

12484: );
12485: l_elig_mltry_stat_cvg_id number(15);
12486: l_out_emc_result_id number(15);
12487: ---------------------------------------------------------------
12488: -- END OF BEN_ELIG_MLTRY_STAT_CVG_F ----------------------
12489: ---------------------------------------------------------------
12490: ---------------------------------------------------------------
12491: -- START OF BEN_ELIG_MRTL_STAT_CVG_F ----------------------
12492: ---------------------------------------------------------------

Line 13375: -- START OF BEN_ELIG_MLTRY_STAT_CVG_F ----------------------

13371: ---------------------------------------------------------------
13372: -- END OF BEN_ELIG_DSBLD_STAT_CVG_F ----------------------
13373: ---------------------------------------------------------------
13374: ---------------------------------------------------------------
13375: -- START OF BEN_ELIG_MLTRY_STAT_CVG_F ----------------------
13376: ---------------------------------------------------------------
13377: --
13378: for l_parent_rec in c_emc_from_parent(l_DPNT_CVG_ELIGY_PRFL_ID) loop
13379: --

Line 13502: -- END OF BEN_ELIG_MLTRY_STAT_CVG_F ----------------------

13498: end loop;
13499: --
13500: end loop;
13501: ---------------------------------------------------------------
13502: -- END OF BEN_ELIG_MLTRY_STAT_CVG_F ----------------------
13503: ---------------------------------------------------------------
13504: ---------------------------------------------------------------
13505: -- START OF BEN_ELIG_MRTL_STAT_CVG_F ----------------------
13506: ---------------------------------------------------------------