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_DPNT_CVG_ELIGY_PRFL_F

Line 985: -- START OF BEN_DPNT_CVG_ELIGY_PRFL_F ----------------------

981: ---------------------------------------------------------------
982: -- END OF BEN_APLD_DPNT_CVG_ELIG_PRFL_F ----------------------
983: ---------------------------------------------------------------
984: ---------------------------------------------------------------
985: -- START OF BEN_DPNT_CVG_ELIGY_PRFL_F ----------------------
986: ---------------------------------------------------------------
987: cursor c_dce_from_parent(c_APLD_DPNT_CVG_ELIG_PRFL_ID number) is
988: select distinct dpnt_cvg_eligy_prfl_id
989: from BEN_APLD_DPNT_CVG_ELIG_PRFL_F

Line 993: -- END OF BEN_DPNT_CVG_ELIGY_PRFL_F ----------------------

989: from BEN_APLD_DPNT_CVG_ELIG_PRFL_F
990: where APLD_DPNT_CVG_ELIG_PRFL_ID = c_APLD_DPNT_CVG_ELIG_PRFL_ID ;
991: --
992: ---------------------------------------------------------------
993: -- END OF BEN_DPNT_CVG_ELIGY_PRFL_F ----------------------
994: ---------------------------------------------------------------
995:
996: l_mirror_src_entity_result_id number(15);
997: l_table_route_id number(15);

Line 12243: -- START OF BEN_DPNT_CVG_ELIGY_PRFL_F ----------------------

12239: -- trt.table_alias = c_parent_table_alias ;
12240: ---
12241:
12242: ---------------------------------------------------------------
12243: -- START OF BEN_DPNT_CVG_ELIGY_PRFL_F ----------------------
12244: ---------------------------------------------------------------
12245:
12246: cursor c_dce(c_dpnt_cvg_eligy_prfl_id number,c_mirror_src_entity_result_id number ,
12247: c_table_alias varchar2 ) is

Line 12249: from BEN_DPNT_CVG_ELIGY_PRFL_F dce

12245:
12246: cursor c_dce(c_dpnt_cvg_eligy_prfl_id number,c_mirror_src_entity_result_id number ,
12247: c_table_alias varchar2 ) is
12248: select dce.*
12249: from BEN_DPNT_CVG_ELIGY_PRFL_F dce
12250: where dce.dpnt_cvg_eligy_prfl_id = c_dpnt_cvg_eligy_prfl_id
12251: -- and dce.business_group_id = p_business_group_id
12252: and not exists (
12253: select /* */ null

Line 12260: -- and trt.where_clause = 'BEN_DPNT_CVG_ELIGY_PRFL_F'

12256: where copy_entity_txn_id = p_copy_entity_txn_id
12257: -- and trt.table_route_id = cpe.table_route_id
12258: and ( -- c_mirror_src_entity_result_id is null or
12259: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
12260: -- and trt.where_clause = 'BEN_DPNT_CVG_ELIGY_PRFL_F'
12261: and cpe.table_alias = c_table_alias
12262: and information1 = c_dpnt_cvg_eligy_prfl_id
12263: -- and information4 = dce.business_group_id
12264: and information2 = dce.effective_start_date

Line 12270: -- END OF BEN_DPNT_CVG_ELIGY_PRFL_F ----------------------

12266: );
12267: l_dpnt_cvg_eligy_prfl_id number(15);
12268: l_out_dce_result_id number(15);
12269: ---------------------------------------------------------------
12270: -- END OF BEN_DPNT_CVG_ELIGY_PRFL_F ----------------------
12271: ---------------------------------------------------------------
12272: ---------------------------------------------------------------
12273: -- START OF BEN_DPNT_CVG_RQD_RLSHP_F ----------------------
12274: ---------------------------------------------------------------

Line 12646: -- START OF BEN_DPNT_CVG_ELIGY_PRFL_F ----------------------

12642: l_mirror_src_entity_result_id := p_mirror_src_entity_result_id;
12643: l_dpnt_cvg_eligy_prfl_id := p_dpnt_cvg_eligy_prfl_id ;
12644:
12645: ---------------------------------------------------------------
12646: -- START OF BEN_DPNT_CVG_ELIGY_PRFL_F ----------------------
12647: ---------------------------------------------------------------
12648: --
12649: for l_dce_rec in c_dce(p_dpnt_cvg_eligy_prfl_id,l_mirror_src_entity_result_id,'DCE' ) loop
12650: --

Line 13882: -- END OF BEN_DPNT_CVG_ELIGY_PRFL_F ----------------------

13878: ---------------------------------------------------------------
13879: --
13880: end if;
13881: ---------------------------------------------------------------
13882: -- END OF BEN_DPNT_CVG_ELIGY_PRFL_F ----------------------
13883: ---------------------------------------------------------------
13884: --
13885: end create_dep_elig_prfl_results;
13886: