APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_LEE_RSN_RL_F

Line 6376: -- START OF BEN_LEE_RSN_RL_F ----------------------

6372: ---------------------------------------------------------------
6373: -- END OF BEN_SCHEDD_ENRT_RL_F ----------------------
6374: ---------------------------------------------------------------
6375: ---------------------------------------------------------------
6376: -- START OF BEN_LEE_RSN_RL_F ----------------------
6377: ---------------------------------------------------------------
6378: cursor c_lrr_from_parent(c_LEE_RSN_ID number) is
6379: select lee_rsn_rl_id
6380: from BEN_LEE_RSN_RL_F

Line 6380: from BEN_LEE_RSN_RL_F

6376: -- START OF BEN_LEE_RSN_RL_F ----------------------
6377: ---------------------------------------------------------------
6378: cursor c_lrr_from_parent(c_LEE_RSN_ID number) is
6379: select lee_rsn_rl_id
6380: from BEN_LEE_RSN_RL_F
6381: where LEE_RSN_ID = c_LEE_RSN_ID ;
6382: --
6383: cursor c_lrr(c_lee_rsn_rl_id number,c_mirror_src_entity_result_id number,
6384: c_table_alias varchar2) is

Line 6386: from BEN_LEE_RSN_RL_F lrr

6382: --
6383: cursor c_lrr(c_lee_rsn_rl_id number,c_mirror_src_entity_result_id number,
6384: c_table_alias varchar2) is
6385: select lrr.*
6386: from BEN_LEE_RSN_RL_F lrr
6387: where lrr.lee_rsn_rl_id = c_lee_rsn_rl_id
6388: -- and lrr.business_group_id = p_business_group_id
6389: and not exists (
6390: select /*+ */ null

Line 6397: -- and trt.where_clause = 'BEN_LEE_RSN_RL_F'

6393: where copy_entity_txn_id = p_copy_entity_txn_id
6394: -- and trt.table_route_id = cpe.table_route_id
6395: and ( -- c_mirror_src_entity_result_id is null or
6396: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6397: -- and trt.where_clause = 'BEN_LEE_RSN_RL_F'
6398: and cpe.table_alias = c_table_alias
6399: and information1 = c_lee_rsn_rl_id
6400: -- and information4 = lrr.business_group_id
6401: and information2 = lrr.effective_start_date

Line 6406: -- END OF BEN_LEE_RSN_RL_F ----------------------

6402: and information3 = lrr.effective_end_date
6403: );
6404: l_out_lrr_result_id number(15);
6405: ---------------------------------------------------------------
6406: -- END OF BEN_LEE_RSN_RL_F ----------------------
6407: ---------------------------------------------------------------
6408: ---------------------------------------------------------------
6409: -- START OF BEN_ENRT_PERD_FOR_PL_F ----------------------
6410: ---------------------------------------------------------------

Line 7862: -- START OF BEN_LEE_RSN_RL_F ----------------------

7858: ---------------------------------------------------------------
7859: -- END OF BEN_ENRT_PERD_FOR_PL_F ----------------------
7860: ---------------------------------------------------------------
7861: ---------------------------------------------------------------
7862: -- START OF BEN_LEE_RSN_RL_F ----------------------
7863: ---------------------------------------------------------------
7864: --
7865: for l_parent_rec in c_lrr_from_parent(l_LEE_RSN_ID) loop
7866: --

Line 7970: -- END OF BEN_LEE_RSN_RL_F ----------------------

7966: end loop;
7967: --
7968: end loop;
7969: ---------------------------------------------------------------
7970: -- END OF BEN_LEE_RSN_RL_F ----------------------
7971: ---------------------------------------------------------------
7972: end loop;
7973: ---------------------------------------------------------------
7974: -- END OF BEN_LEE_RSN_F ----------------------