APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_POPL_YR_PERD

Line 6047: -- START OF BEN_POPL_YR_PERD ----------------------

6043: ---------------------------------------------------------------
6044: -- END OF BEN_POPL_ORG_F ----------------------
6045: ---------------------------------------------------------------
6046: ---------------------------------------------------------------
6047: -- START OF BEN_POPL_YR_PERD ----------------------
6048: ---------------------------------------------------------------
6049: cursor c_cpy_from_parent(c_PL_ID number, c_PGM_ID number ) is
6050: select popl_yr_perd_id
6051: from BEN_POPL_YR_PERD

Line 6051: from BEN_POPL_YR_PERD

6047: -- START OF BEN_POPL_YR_PERD ----------------------
6048: ---------------------------------------------------------------
6049: cursor c_cpy_from_parent(c_PL_ID number, c_PGM_ID number ) is
6050: select popl_yr_perd_id
6051: from BEN_POPL_YR_PERD
6052: --where PL_ID = c_PL_ID ;
6053: where ( c_PL_ID is not null and c_PL_ID = PL_ID ) or
6054: ( c_PGM_ID is not null and c_PGM_ID = PGM_ID);
6055: --

Line 6059: from BEN_POPL_YR_PERD cpy

6055: --
6056: cursor c_cpy(c_popl_yr_perd_id number,c_mirror_src_entity_result_id number,
6057: c_table_alias varchar2) is
6058: select cpy.*
6059: from BEN_POPL_YR_PERD cpy
6060: where cpy.popl_yr_perd_id = c_popl_yr_perd_id
6061: -- and cpy.business_group_id = p_business_group_id
6062: and not exists (
6063: select /*+ */ null

Line 6070: -- and trt.where_clause = 'BEN_POPL_YR_PERD'

6066: where copy_entity_txn_id = p_copy_entity_txn_id
6067: -- and trt.table_route_id = cpe.table_route_id
6068: and ( -- c_mirror_src_entity_result_id is null or
6069: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6070: -- and trt.where_clause = 'BEN_POPL_YR_PERD'
6071: and cpe.table_alias = c_table_alias
6072: and information1 = c_popl_yr_perd_id
6073: -- and information4 = cpy.business_group_id
6074: );

Line 6077: -- END OF BEN_POPL_YR_PERD ----------------------

6073: -- and information4 = cpy.business_group_id
6074: );
6075: l_out_cpy_result_id number(15);
6076: ---------------------------------------------------------------
6077: -- END OF BEN_POPL_YR_PERD ----------------------
6078: ---------------------------------------------------------------
6079: ---------------------------------------------------------------
6080: -- START OF BEN_POPL_RPTG_GRP_F ----------------------
6081: ---------------------------------------------------------------

Line 6120: from BEN_POPL_YR_PERD

6116: -- START OF BEN_YR_PERD ----------------------
6117: ---------------------------------------------------------------
6118: cursor c_yrp_from_parent(c_POPL_YR_PERD_ID number) is
6119: select distinct yr_perd_id
6120: from BEN_POPL_YR_PERD
6121: where POPL_YR_PERD_ID = c_POPL_YR_PERD_ID ;
6122: --
6123: ---------------------------------------------------------------
6124: -- END OF BEN_YR_PERD ----------------------

Line 8227: -- START OF BEN_POPL_YR_PERD ----------------------

8223: ---------------------------------------------------------------
8224: -- END OF BEN_POPL_ORG_F ----------------------
8225: ---------------------------------------------------------------
8226: ---------------------------------------------------------------
8227: -- START OF BEN_POPL_YR_PERD ----------------------
8228: ---------------------------------------------------------------
8229: --
8230: for l_parent_rec in c_cpy_from_parent(p_pl_id,p_pgm_id) loop
8231: --

Line 8342: -- END OF BEN_POPL_YR_PERD ----------------------

8338: ---------------------------------------------------------------
8339: --
8340: end loop;
8341: ---------------------------------------------------------------
8342: -- END OF BEN_POPL_YR_PERD ----------------------
8343: ---------------------------------------------------------------
8344: ---------------------------------------------------------------
8345: ---------------------------------------------------------------
8346: -- START OF BEN_POPL_RPTG_GRP_F ----------------------