APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_LEE_RSN_F

Line 6191: -- START OF BEN_LEE_RSN_F ----------------------

6187: ---------------------------------------------------------------
6188: -- END OF BEN_RPTG_GRP ----------------------
6189: ---------------------------------------------------------------
6190: ---------------------------------------------------------------
6191: -- START OF BEN_LEE_RSN_F ----------------------
6192: ---------------------------------------------------------------
6193: cursor c_len_from_parent(c_POPL_ENRT_TYP_CYCL_ID number) is
6194: select distinct lee_rsn_id
6195: from BEN_LEE_RSN_F

Line 6195: from BEN_LEE_RSN_F

6191: -- START OF BEN_LEE_RSN_F ----------------------
6192: ---------------------------------------------------------------
6193: cursor c_len_from_parent(c_POPL_ENRT_TYP_CYCL_ID number) is
6194: select distinct lee_rsn_id
6195: from BEN_LEE_RSN_F
6196: where POPL_ENRT_TYP_CYCL_ID = c_POPL_ENRT_TYP_CYCL_ID ;
6197: --
6198: cursor c_len(c_lee_rsn_id number,c_mirror_src_entity_result_id number,
6199: c_table_alias varchar2) is

Line 6201: from BEN_LEE_RSN_F len

6197: --
6198: cursor c_len(c_lee_rsn_id number,c_mirror_src_entity_result_id number,
6199: c_table_alias varchar2) is
6200: select len.*
6201: from BEN_LEE_RSN_F len
6202: where len.lee_rsn_id = c_lee_rsn_id
6203: -- and len.business_group_id = p_business_group_id
6204: and not exists (
6205: select /*+ */ null

Line 6212: -- and trt.where_clause = 'BEN_LEE_RSN_F'

6208: where copy_entity_txn_id = p_copy_entity_txn_id
6209: -- and trt.table_route_id = cpe.table_route_id
6210: and ( -- c_mirror_src_entity_result_id is null or
6211: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6212: -- and trt.where_clause = 'BEN_LEE_RSN_F'
6213: and cpe.table_alias = c_table_alias
6214: and information1 = c_lee_rsn_id
6215: -- and information4 = len.business_group_id
6216: and information2 = len.effective_start_date

Line 6227: -- and trt.where_clause = 'BEN_LEE_RSN_F'

6223: pqh_table_route trt
6224: where copy_entity_txn_id = p_copy_entity_txn_id
6225: and trt.table_route_id = cpe.table_route_id
6226: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
6227: -- and trt.where_clause = 'BEN_LEE_RSN_F'
6228: and trt.table_alias = c_table_alias
6229: and information1 = c_lee_rsn_id
6230: -- and information4 = p_business_group_id
6231: ;

Line 6234: -- END OF BEN_LEE_RSN_F ----------------------

6230: -- and information4 = p_business_group_id
6231: ;
6232: l_out_len_result_id number(15);
6233: ---------------------------------------------------------------
6234: -- END OF BEN_LEE_RSN_F ----------------------
6235: ---------------------------------------------------------------
6236: ---------------------------------------------------------------
6237: -- START OF BEN_ENRT_PERD ----------------------
6238: ---------------------------------------------------------------

Line 7554: -- START OF BEN_LEE_RSN_F ----------------------

7550: ---------------------------------------------------------------
7551: -- END OF BEN_ENRT_PERD ----------------------
7552: ---------------------------------------------------------------
7553: ---------------------------------------------------------------
7554: -- START OF BEN_LEE_RSN_F ----------------------
7555: ---------------------------------------------------------------
7556: --
7557: for l_parent_rec in c_len_from_parent(l_POPL_ENRT_TYP_CYCL_ID) loop
7558: --

Line 7974: -- END OF BEN_LEE_RSN_F ----------------------

7970: -- END OF BEN_LEE_RSN_RL_F ----------------------
7971: ---------------------------------------------------------------
7972: end loop;
7973: ---------------------------------------------------------------
7974: -- END OF BEN_LEE_RSN_F ----------------------
7975: ---------------------------------------------------------------
7976: --
7977: end loop;
7978: ---------------------------------------------------------------