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_OIPL_ENRT_F

Line 10221: -- START OF BEN_LER_CHG_OIPL_ENRT_F ----------------------

10217: ---------------------------------------------------------------
10218: -- END OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
10219: ---------------------------------------------------------------
10220: ---------------------------------------------------------------
10221: -- START OF BEN_LER_CHG_OIPL_ENRT_F ----------------------
10222: ---------------------------------------------------------------
10223: cursor c_lop_from_parent(c_OIPL_ID number) is
10224: select distinct ler_chg_oipl_enrt_id
10225: from BEN_LER_CHG_OIPL_ENRT_F

Line 10225: from BEN_LER_CHG_OIPL_ENRT_F

10221: -- START OF BEN_LER_CHG_OIPL_ENRT_F ----------------------
10222: ---------------------------------------------------------------
10223: cursor c_lop_from_parent(c_OIPL_ID number) is
10224: select distinct ler_chg_oipl_enrt_id
10225: from BEN_LER_CHG_OIPL_ENRT_F
10226: where OIPL_ID = c_OIPL_ID ;
10227: --
10228: cursor c_lop(c_ler_chg_oipl_enrt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
10229: select lop.*

Line 10230: from BEN_LER_CHG_OIPL_ENRT_F lop

10226: where OIPL_ID = c_OIPL_ID ;
10227: --
10228: cursor c_lop(c_ler_chg_oipl_enrt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
10229: select lop.*
10230: from BEN_LER_CHG_OIPL_ENRT_F lop
10231: where lop.ler_chg_oipl_enrt_id = c_ler_chg_oipl_enrt_id
10232: -- and lop.business_group_id = p_business_group_id
10233: and not exists (
10234: select /*+ */ null

Line 10241: -- and trt.where_clause = 'BEN_LER_CHG_OIPL_ENRT_F'

10237: where copy_entity_txn_id = p_copy_entity_txn_id
10238: -- and trt.table_route_id = cpe.table_route_id
10239: and ( -- c_mirror_src_entity_result_id is null or
10240: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
10241: -- and trt.where_clause = 'BEN_LER_CHG_OIPL_ENRT_F'
10242: and cpe.table_alias = c_table_alias
10243: and information1 = c_ler_chg_oipl_enrt_id
10244: -- and information4 = lop.business_group_id
10245: and information2 = lop.effective_start_date

Line 10257: -- and trt.where_clause = 'BEN_LER_CHG_OIPL_ENRT_F'

10253: -- pqh_table_route trt
10254: where copy_entity_txn_id = p_copy_entity_txn_id
10255: -- and trt.table_route_id = cpe.table_route_id
10256: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
10257: -- and trt.where_clause = 'BEN_LER_CHG_OIPL_ENRT_F'
10258: and cpe.table_alias = c_table_alias
10259: and information1 = c_ler_chg_oipl_enrt_id
10260: -- and information4 = p_business_group_id
10261: ;

Line 10263: -- END OF BEN_LER_CHG_OIPL_ENRT_F ----------------------

10259: and information1 = c_ler_chg_oipl_enrt_id
10260: -- and information4 = p_business_group_id
10261: ;
10262: ---------------------------------------------------------------
10263: -- END OF BEN_LER_CHG_OIPL_ENRT_F ----------------------
10264: ---------------------------------------------------------------
10265: ---------------------------------------------------------------
10266: -- START OF BEN_ENRT_CTFN_F ----------------------
10267: ---------------------------------------------------------------

Line 11027: -- START OF BEN_LER_CHG_OIPL_ENRT_F ----------------------

11023: ---------------------------------------------------------------
11024: -- END OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
11025: ---------------------------------------------------------------
11026: ---------------------------------------------------------------
11027: -- START OF BEN_LER_CHG_OIPL_ENRT_F ----------------------
11028: ---------------------------------------------------------------
11029: --
11030: for l_parent_rec in c_lop_from_parent(l_OIPL_ID) loop
11031: --

Line 11201: -- END OF BEN_LER_CHG_OIPL_ENRT_F ----------------------

11197: );
11198: end loop;
11199: end loop;
11200: ---------------------------------------------------------------
11201: -- END OF BEN_LER_CHG_OIPL_ENRT_F ----------------------
11202: ---------------------------------------------------------------
11203: ---------------------------------------------------------------
11204: -- START OF BEN_ENRT_CTFN_F ----------------------
11205: ---------------------------------------------------------------