APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_WTHN_YR_PERD

Line 12574: -- START OF BEN_WTHN_YR_PERD ----------------------

12570: -- END OF BEN_YR_PERD ----------------------
12571: ---------------------------------------------------------------
12572: ---
12573: ---------------------------------------------------------------
12574: -- START OF BEN_WTHN_YR_PERD ----------------------
12575: ---------------------------------------------------------------
12576: cursor c_wyp_from_parent(c_YR_PERD_ID number) is
12577: select wthn_yr_perd_id
12578: from BEN_WTHN_YR_PERD

Line 12578: from BEN_WTHN_YR_PERD

12574: -- START OF BEN_WTHN_YR_PERD ----------------------
12575: ---------------------------------------------------------------
12576: cursor c_wyp_from_parent(c_YR_PERD_ID number) is
12577: select wthn_yr_perd_id
12578: from BEN_WTHN_YR_PERD
12579: where YR_PERD_ID = c_YR_PERD_ID ;
12580: --
12581: cursor c_wyp(c_wthn_yr_perd_id number,c_mirror_src_entity_result_id number,
12582: c_table_alias varchar2) is

Line 12584: from BEN_WTHN_YR_PERD wyp

12580: --
12581: cursor c_wyp(c_wthn_yr_perd_id number,c_mirror_src_entity_result_id number,
12582: c_table_alias varchar2) is
12583: select wyp.*
12584: from BEN_WTHN_YR_PERD wyp
12585: where wyp.wthn_yr_perd_id = c_wthn_yr_perd_id
12586: -- and wyp.business_group_id = p_business_group_id
12587: and not exists (
12588: select /*+ */ null

Line 12595: -- and trt.where_clause = 'BEN_WTHN_YR_PERD'

12591: where copy_entity_txn_id = p_copy_entity_txn_id
12592: -- and trt.table_route_id = cpe.table_route_id
12593: and ( -- c_mirror_src_entity_result_id is null or
12594: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
12595: -- and trt.where_clause = 'BEN_WTHN_YR_PERD'
12596: and cpe.table_alias = c_table_alias
12597: and information1 = c_wthn_yr_perd_id
12598: -- and information4 = wyp.business_group_id
12599: );

Line 12602: -- END OF BEN_WTHN_YR_PERD ----------------------

12598: -- and information4 = wyp.business_group_id
12599: );
12600: l_out_wyp_result_id number(15);
12601: ---------------------------------------------------------------
12602: -- END OF BEN_WTHN_YR_PERD ----------------------
12603: ---------------------------------------------------------------
12604:
12605: l_yr_perd_id number(15);
12606: l_wthn_yr_perd_id number(15);

Line 12741: -- START OF BEN_WTHN_YR_PERD ----------------------

12737:
12738: if l_out_yrp_result_id is not null then
12739: --
12740: ---------------------------------------------------------------
12741: -- START OF BEN_WTHN_YR_PERD ----------------------
12742: ---------------------------------------------------------------
12743: --
12744: for l_parent_rec in c_wyp_from_parent(l_YR_PERD_ID) loop
12745: --

Line 12832: -- END OF BEN_WTHN_YR_PERD ----------------------

12828: end loop;
12829: --
12830: end loop;
12831: ---------------------------------------------------------------
12832: -- END OF BEN_WTHN_YR_PERD ----------------------
12833: ---------------------------------------------------------------
12834: end if;
12835: ---------------------------------------------------------------
12836: -- END OF BEN_YR_PERD ----------------------