DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_LER_RLTD_PER_CS_LER_F

Line 9145: -- START OF BEN_LER_RLTD_PER_CS_LER_F ----------------------

9141: ---------------------------------------------------------------
9142: -- END OF BEN_LER_PER_INFO_CS_LER_F ----------------------
9143: ---------------------------------------------------------------
9144: ---------------------------------------------------------------
9145: -- START OF BEN_LER_RLTD_PER_CS_LER_F ----------------------
9146: ---------------------------------------------------------------
9147: cursor c_lrc_from_parent(c_LER_ID number) is
9148: select ler_rltd_per_cs_ler_id
9149: from BEN_LER_RLTD_PER_CS_LER_F

Line 9149: from BEN_LER_RLTD_PER_CS_LER_F

9145: -- START OF BEN_LER_RLTD_PER_CS_LER_F ----------------------
9146: ---------------------------------------------------------------
9147: cursor c_lrc_from_parent(c_LER_ID number) is
9148: select ler_rltd_per_cs_ler_id
9149: from BEN_LER_RLTD_PER_CS_LER_F
9150: where LER_ID = c_LER_ID ;
9151: --
9152: cursor c_lrc(c_ler_rltd_per_cs_ler_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
9153: select lrc.*

Line 9154: from BEN_LER_RLTD_PER_CS_LER_F lrc

9150: where LER_ID = c_LER_ID ;
9151: --
9152: cursor c_lrc(c_ler_rltd_per_cs_ler_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
9153: select lrc.*
9154: from BEN_LER_RLTD_PER_CS_LER_F lrc
9155: where lrc.ler_rltd_per_cs_ler_id = c_ler_rltd_per_cs_ler_id
9156: -- and lrc.business_group_id = p_business_group_id
9157: and not exists (
9158: select /*+ */ null

Line 9165: -- and trt.where_clause = 'BEN_LER_RLTD_PER_CS_LER_F'

9161: where copy_entity_txn_id = p_copy_entity_txn_id
9162: -- and trt.table_route_id = cpe.table_route_id
9163: and ( -- c_mirror_src_entity_result_id is null or
9164: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
9165: -- and trt.where_clause = 'BEN_LER_RLTD_PER_CS_LER_F'
9166: and cpe.table_alias = c_table_alias
9167: and information1 = c_ler_rltd_per_cs_ler_id
9168: -- and information4 = lrc.business_group_id
9169: and information2 = lrc.effective_start_date

Line 9174: -- END OF BEN_LER_RLTD_PER_CS_LER_F ----------------------

9170: and information3 = lrc.effective_end_date
9171: );
9172: l_out_lrc_result_id number(15);
9173: ---------------------------------------------------------------
9174: -- END OF BEN_LER_RLTD_PER_CS_LER_F ----------------------
9175: ---------------------------------------------------------------
9176: ---------------------------------------------------------------
9177: -- START OF BEN_PER_INFO_CHG_CS_LER_F ----------------------
9178: ---------------------------------------------------------------

Line 9237: from BEN_LER_RLTD_PER_CS_LER_F

9233: -- START OF BEN_RLTD_PER_CHG_CS_LER_F ----------------------
9234: ---------------------------------------------------------------
9235: cursor c_rcl_from_parent(c_LER_RLTD_PER_CS_LER_ID number) is
9236: select rltd_per_chg_cs_ler_id
9237: from BEN_LER_RLTD_PER_CS_LER_F
9238: where LER_RLTD_PER_CS_LER_ID = c_LER_RLTD_PER_CS_LER_ID ;
9239: --
9240: cursor c_rcl(c_rltd_per_chg_cs_ler_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
9241: select rcl.*

Line 9818: -- START OF BEN_LER_RLTD_PER_CS_LER_F ----------------------

9814: -- END OF BEN_LER_PER_INFO_CS_LER_F ----------------------
9815: ---------------------------------------------------------------
9816: /* -- NOTIMPLEMENTED
9817: ---------------------------------------------------------------
9818: -- START OF BEN_LER_RLTD_PER_CS_LER_F ----------------------
9819: ---------------------------------------------------------------
9820: --
9821: for l_parent_rec in c_lrc_from_parent(l_LER_ID) loop
9822: --

Line 10047: -- END OF BEN_LER_RLTD_PER_CS_LER_F ----------------------

10043: -- END OF BEN_RLTD_PER_CHG_CS_LER_F ----------------------
10044: ---------------------------------------------------------------
10045: end loop;
10046: ---------------------------------------------------------------
10047: -- END OF BEN_LER_RLTD_PER_CS_LER_F ----------------------
10048: ---------------------------------------------------------------
10049: -- End NOTIMPLEMENTED
10050: */
10051: end;