APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_LER_F

Line 9049: -- START OF BEN_LER_F ----------------------

9045: -- and trt.where_clause = upper(c_parent_table_name) ;
9046: and cpe.table_alias = c_parent_table_alias;
9047: ---
9048: ---------------------------------------------------------------
9049: -- START OF BEN_LER_F ----------------------
9050: ---------------------------------------------------------------
9051: cursor c_ler(c_ler_id number,c_mirror_src_entity_result_id number,
9052: c_table_alias varchar2) is
9053: select ler.*

Line 9054: from BEN_LER_F ler

9050: ---------------------------------------------------------------
9051: cursor c_ler(c_ler_id number,c_mirror_src_entity_result_id number,
9052: c_table_alias varchar2) is
9053: select ler.*
9054: from BEN_LER_F ler
9055: where ler.ler_id = c_ler_id
9056: -- and ler.business_group_id = p_business_group_id
9057: and not exists (
9058: select /*+ */ null

Line 9065: -- and trt.where_clause = 'BEN_LER_F'

9061: where copy_entity_txn_id = p_copy_entity_txn_id
9062: -- and trt.table_route_id = cpe.table_route_id
9063: and ( -- c_mirror_src_entity_result_id is null or
9064: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
9065: -- and trt.where_clause = 'BEN_LER_F'
9066: and cpe.table_alias = c_table_alias
9067: and information1 = c_ler_id
9068: -- and information4 = ler.business_group_id
9069: and information2 = ler.effective_start_date

Line 9073: -- END OF BEN_LER_F ----------------------

9069: and information2 = ler.effective_start_date
9070: and information3 = ler.effective_end_date
9071: );
9072: ---------------------------------------------------------------
9073: -- END OF BEN_LER_F ----------------------
9074: ---------------------------------------------------------------
9075: ---------------------------------------------------------------
9076: -- START OF BEN_CSS_RLTD_PER_PER_IN_LER_F ----------------------
9077: ---------------------------------------------------------------

Line 9115: from ben_ler_f

9111: select ler_per_info_cs_ler_id
9112: from BEN_LER_PER_INFO_CS_LER_F
9113: where LER_ID = c_LER_ID
9114: and ( exists ( select 'x'
9115: from ben_ler_f
9116: where LER_ID = c_LER_ID
9117: and typ_cd = 'ABS') OR
9118: nvl(p_no_dup_rslt, 'X') = 'Y'); -- For plan design wizard copy lpl also
9119: --

Line 9310: -- START OF BEN_LER_F ----------------------

9306: l_number_of_copies := p_number_of_copies ;
9307:
9308: --
9309: ---------------------------------------------------------------
9310: -- START OF BEN_LER_F ----------------------
9311: ---------------------------------------------------------------
9312: --
9313: l_mirror_src_entity_result_id := p_copy_entity_result_id;
9314: --

Line 9444: -- END OF BEN_LER_F ----------------------

9440:
9441: --
9442: end loop;
9443: ---------------------------------------------------------------
9444: -- END OF BEN_LER_F ----------------------
9445: ---------------------------------------------------------------
9446: /* -- START NOTIMPLEMENTED
9447: ---------------------------------------------------------------
9448: -- START OF BEN_CSS_RLTD_PER_PER_IN_LER_F ----------------------