DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_ACTN_TYP

Line 6448: -- START OF BEN_ACTN_TYP ----------------------

6444: ---------------------------------------------------------------
6445: -- END OF BEN_ENRT_PERD_FOR_PL_F ----------------------
6446: ---------------------------------------------------------------
6447: ---------------------------------------------------------------
6448: -- START OF BEN_ACTN_TYP ----------------------
6449: ---------------------------------------------------------------
6450: cursor c_eat_from_parent(c_POPL_ACTN_TYP_ID number) is
6451: select actn_typ_id
6452: from BEN_POPL_ACTN_TYP_F

Line 6458: from BEN_ACTN_TYP eat

6454: --
6455: cursor c_eat(c_actn_typ_id number,c_mirror_src_entity_result_id number,
6456: c_table_alias varchar2) is
6457: select eat.*
6458: from BEN_ACTN_TYP eat
6459: where eat.actn_typ_id = c_actn_typ_id
6460: -- and eat.business_group_id = p_business_group_id
6461: and not exists (
6462: select /*+ */ null

Line 6469: -- and trt.where_clause = 'BEN_ACTN_TYP'

6465: where copy_entity_txn_id = p_copy_entity_txn_id
6466: -- and trt.table_route_id = cpe.table_route_id
6467: and ( -- c_mirror_src_entity_result_id is null or
6468: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6469: -- and trt.where_clause = 'BEN_ACTN_TYP'
6470: and cpe.table_alias = c_table_alias
6471: and information1 = c_actn_typ_id
6472: -- and information4 = eat.business_group_id
6473: );

Line 6476: -- END OF BEN_ACTN_TYP ----------------------

6472: -- and information4 = eat.business_group_id
6473: );
6474: l_out_eat_result_id number(15);
6475: ---------------------------------------------------------------
6476: -- END OF BEN_ACTN_TYP ----------------------
6477: ---------------------------------------------------------------
6478: ---------------------------------------------------------------
6479: -- START OF BEN_PL_REGN_F ----------------------
6480: ---------------------------------------------------------------

Line 6807: -- START OF BEN_ACTN_TYP ----------------------

6803: --
6804: end loop;
6805: --
6806: ---------------------------------------------------------------
6807: -- START OF BEN_ACTN_TYP ----------------------
6808: ---------------------------------------------------------------
6809: --
6810: for l_parent_rec in c_eat_from_parent(l_POPL_ACTN_TYP_ID) loop
6811: --

Line 6907: -- END OF BEN_ACTN_TYP ----------------------

6903: end loop;
6904: --
6905: end loop;
6906: ---------------------------------------------------------------
6907: -- END OF BEN_ACTN_TYP ----------------------
6908: ---------------------------------------------------------------
6909: end loop;
6910: ---------------------------------------------------------------
6911: -- END OF BEN_POPL_ACTN_TYP_F ----------------------