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_PLAN_MODULE dependencies on BEN_LER_CHG_DPNT_CVG_F

Line 452: -- START OF BEN_LER_CHG_DPNT_CVG_F ----------------------

448: ---------------------------------------------------------------
449: -- END OF BEN_ENRT_CTFN_F ----------------------
450: ---------------------------------------------------------------
451: ---------------------------------------------------------------
452: -- START OF BEN_LER_CHG_DPNT_CVG_F ----------------------
453: ---------------------------------------------------------------
454: cursor c_ldc_from_parent(c_PL_ID number) is
455: select distinct ler_chg_dpnt_cvg_id
456: from BEN_LER_CHG_DPNT_CVG_F

Line 456: from BEN_LER_CHG_DPNT_CVG_F

452: -- START OF BEN_LER_CHG_DPNT_CVG_F ----------------------
453: ---------------------------------------------------------------
454: cursor c_ldc_from_parent(c_PL_ID number) is
455: select distinct ler_chg_dpnt_cvg_id
456: from BEN_LER_CHG_DPNT_CVG_F
457: where PL_ID = c_PL_ID ;
458: --
459: cursor c_ldc(c_ler_chg_dpnt_cvg_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
460: select ldc.*

Line 461: from BEN_LER_CHG_DPNT_CVG_F ldc

457: where PL_ID = c_PL_ID ;
458: --
459: cursor c_ldc(c_ler_chg_dpnt_cvg_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
460: select ldc.*
461: from BEN_LER_CHG_DPNT_CVG_F ldc
462: where ldc.ler_chg_dpnt_cvg_id = c_ler_chg_dpnt_cvg_id
463: -- and ldc.business_group_id = p_business_group_id
464: and not exists (
465: select /*+ */ null

Line 472: -- and trt.where_clause = 'BEN_LER_CHG_DPNT_CVG_F'

468: where copy_entity_txn_id = p_copy_entity_txn_id
469: -- and trt.table_route_id = cpe.table_route_id
470: and ( -- c_mirror_src_entity_result_id is null or
471: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
472: -- and trt.where_clause = 'BEN_LER_CHG_DPNT_CVG_F'
473: and cpe.table_alias = c_table_alias
474: and information1 = c_ler_chg_dpnt_cvg_id
475: -- and information4 = ldc.business_group_id
476: and information2 = ldc.effective_start_date

Line 486: -- and trt.where_clause = 'BEN_LER_CHG_DPNT_CVG_F'

482: -- ,pqh_table_route trt
483: where copy_entity_txn_id = p_copy_entity_txn_id
484: -- and trt.table_route_id = cpe.table_route_id
485: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
486: -- and trt.where_clause = 'BEN_LER_CHG_DPNT_CVG_F'
487: and cpe.table_alias = c_table_alias
488: and information1 = c_ler_chg_dpnt_cvg_id
489: -- and information4 = p_business_group_id
490: ;

Line 494: -- END OF BEN_LER_CHG_DPNT_CVG_F ----------------------

490: ;
491:
492: l_out_ldc_result_id number(15);
493: ---------------------------------------------------------------
494: -- END OF BEN_LER_CHG_DPNT_CVG_F ----------------------
495: ---------------------------------------------------------------
496: ---
497: ---------------------------------------------------------------
498: -- START OF BEN_LER_CHG_PL_NIP_ENRT_F ----------------------

Line 4271: -- START OF BEN_LER_CHG_DPNT_CVG_F ----------------------

4267: -- END OF BEN_ENRT_CTFN_F ----------------------
4268: ---------------------------------------------------------------
4269:
4270: ---------------------------------------------------------------
4271: -- START OF BEN_LER_CHG_DPNT_CVG_F ----------------------
4272: ---------------------------------------------------------------
4273: --
4274: --
4275: for l_parent_rec in c_ldc_from_parent(l_PL_ID) loop

Line 4540: -- END OF BEN_LER_CHG_DPNT_CVG_F ----------------------

4536: -- END OF BEN_LER_CHG_DPNT_CVG_CTFN_F ----------------------
4537: ---------------------------------------------------------------
4538: end loop;
4539: ---------------------------------------------------------------
4540: -- END OF BEN_LER_CHG_DPNT_CVG_F ----------------------
4541: ---------------------------------------------------------------
4542: ---------------------------------------------------------------
4543: -- START OF BEN_LER_CHG_PL_NIP_ENRT_F ----------------------
4544: ---------------------------------------------------------------