APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_RLTD_PER_CHG_CS_LER_F

Line 9233: -- START OF BEN_RLTD_PER_CHG_CS_LER_F ----------------------

9229: ---------------------------------------------------------------
9230: -- END OF BEN_PER_INFO_CHG_CS_LER_F ----------------------
9231: ---------------------------------------------------------------
9232: ---------------------------------------------------------------
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

Line 9242: from BEN_RLTD_PER_CHG_CS_LER_F rcl

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.*
9242: from BEN_RLTD_PER_CHG_CS_LER_F rcl
9243: where rcl.rltd_per_chg_cs_ler_id = c_rltd_per_chg_cs_ler_id
9244: -- and rcl.business_group_id = p_business_group_id
9245: and not exists (
9246: select /*+ */ null

Line 9253: -- and trt.where_clause = 'BEN_RLTD_PER_CHG_CS_LER_F'

9249: where copy_entity_txn_id = p_copy_entity_txn_id
9250: -- and trt.table_route_id = cpe.table_route_id
9251: and ( -- c_mirror_src_entity_result_id is null or
9252: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
9253: -- and trt.where_clause = 'BEN_RLTD_PER_CHG_CS_LER_F'
9254: and cpe.table_alias = c_table_alias
9255: and information1 = c_rltd_per_chg_cs_ler_id
9256: -- and information4 = rcl.business_group_id
9257: and information2 = rcl.effective_start_date

Line 9262: -- END OF BEN_RLTD_PER_CHG_CS_LER_F ----------------------

9258: and information3 = rcl.effective_end_date
9259: );
9260: l_out_rcl_result_id number(15);
9261: ---------------------------------------------------------------
9262: -- END OF BEN_RLTD_PER_CHG_CS_LER_F ----------------------
9263: ---------------------------------------------------------------
9264:
9265: cursor c_object_exists(c_pk_id number,
9266: c_table_alias varchar2) is

Line 9928: -- START OF BEN_RLTD_PER_CHG_CS_LER_F ----------------------

9924: --
9925: end loop;
9926: --
9927: ---------------------------------------------------------------
9928: -- START OF BEN_RLTD_PER_CHG_CS_LER_F ----------------------
9929: ---------------------------------------------------------------
9930: --
9931: for l_parent_rec in c_rcl_from_parent(l_LER_RLTD_PER_CS_LER_ID) loop
9932: --

Line 10043: -- END OF BEN_RLTD_PER_CHG_CS_LER_F ----------------------

10039: end loop;
10040: --
10041: end loop;
10042: ---------------------------------------------------------------
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 ----------------------