eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_YR_PERD

Line 6116: -- START OF BEN_YR_PERD ----------------------

6112: -- END OF BEN_POPL_RPTG_GRP_F ----------------------
6113: ---------------------------------------------------------------
6114: ---
6115: ---------------------------------------------------------------
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

Line 6124: -- END OF BEN_YR_PERD ----------------------

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 ----------------------
6125: ---------------------------------------------------------------
6126: ---------------------------------------------------------------
6127: -- START OF BEN_POPL_ORG_ROLE_F ----------------------
6128: ---------------------------------------------------------------

Line 6294: -- START OF BEN_YR_PERD ----------------------

6290: ---------------------------------------------------------------
6291: -- END OF BEN_ENRT_PERD ----------------------
6292: ---------------------------------------------------------------
6293: ---------------------------------------------------------------
6294: -- START OF BEN_YR_PERD ----------------------
6295: ---------------------------------------------------------------
6296: cursor c_yrp1_from_parent(c_ENRT_PERD_ID number) is
6297: select distinct yr_perd_id
6298: from BEN_ENRT_PERD

Line 6302: -- END OF BEN_YR_PERD ----------------------

6298: from BEN_ENRT_PERD
6299: where ENRT_PERD_ID = c_ENRT_PERD_ID ;
6300: --
6301: ---------------------------------------------------------------
6302: -- END OF BEN_YR_PERD ----------------------
6303: ---------------------------------------------------------------
6304: ---------------------------------------------------------------
6305: -- START OF BEN_ENRT_PERD_FOR_PL_F ----------------------
6306: ---------------------------------------------------------------

Line 7264: -- START OF BEN_YR_PERD ----------------------

7260: --
7261: end loop;
7262: --
7263: ---------------------------------------------------------------
7264: -- START OF BEN_YR_PERD ----------------------
7265: ---------------------------------------------------------------
7266: --
7267: for l_parent_rec in c_yrp1_from_parent(l_ENRT_PERD_ID) loop
7268: --

Line 7283: -- END OF BEN_YR_PERD ----------------------

7279: );
7280: end loop;
7281: --
7282: ---------------------------------------------------------------
7283: -- END OF BEN_YR_PERD ----------------------
7284: ---------------------------------------------------------------
7285: ---------------------------------------------------------------
7286: -- START OF BEN_ENRT_PERD_FOR_PL_F ----------------------
7287: ---------------------------------------------------------------

Line 8318: -- START OF BEN_YR_PERD ----------------------

8314:
8315: end loop ;
8316:
8317: ---------------------------------------------------------------
8318: -- START OF BEN_YR_PERD ----------------------
8319: ---------------------------------------------------------------
8320: --
8321: --
8322: for l_parent_rec in c_yrp_from_parent(l_POPL_YR_PERD_ID) loop

Line 8337: -- END OF BEN_YR_PERD ----------------------

8333: ,p_parent_entity_result_id => l_out_cpy_result_id
8334: );
8335: end loop;
8336: ---------------------------------------------------------------
8337: -- END OF BEN_YR_PERD ----------------------
8338: ---------------------------------------------------------------
8339: --
8340: end loop;
8341: ---------------------------------------------------------------

Line 12546: -- START OF BEN_YR_PERD ----------------------

12542: -- from pqh_table_route trt
12543: -- where trt.table_alias = c_parent_table_alias;
12544: --
12545: ---------------------------------------------------------------
12546: -- START OF BEN_YR_PERD ----------------------
12547: ---------------------------------------------------------------
12548:
12549: cursor c_yrp(c_yr_perd_id number,c_mirror_src_entity_result_id number,
12550: c_table_alias varchar2) is

Line 12552: from BEN_YR_PERD yrp

12548:
12549: cursor c_yrp(c_yr_perd_id number,c_mirror_src_entity_result_id number,
12550: c_table_alias varchar2) is
12551: select yrp.*
12552: from BEN_YR_PERD yrp
12553: where yrp.yr_perd_id = c_yr_perd_id
12554: -- and yrp.business_group_id = p_business_group_id
12555: and not exists (
12556: select /*+ */ null

Line 12563: -- and trt.where_clause = 'BEN_YR_PERD'

12559: where copy_entity_txn_id = p_copy_entity_txn_id
12560: -- and trt.table_route_id = cpe.table_route_id
12561: and ( -- c_mirror_src_entity_result_id is null or
12562: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
12563: -- and trt.where_clause = 'BEN_YR_PERD'
12564: and cpe.table_alias = c_table_alias
12565: and information1 = c_yr_perd_id
12566: -- and information4 = yrp.business_group_id
12567: );

Line 12570: -- END OF BEN_YR_PERD ----------------------

12566: -- and information4 = yrp.business_group_id
12567: );
12568: l_out_yrp_result_id number(15);
12569: ---------------------------------------------------------------
12570: -- END OF BEN_YR_PERD ----------------------
12571: ---------------------------------------------------------------
12572: ---
12573: ---------------------------------------------------------------
12574: -- START OF BEN_WTHN_YR_PERD ----------------------

Line 12630: -- START OF BEN_YR_PERD ----------------------

12626:
12627: begin
12628: --
12629: ---------------------------------------------------------------
12630: -- START OF BEN_YR_PERD ----------------------
12631: ---------------------------------------------------------------
12632:
12633: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
12634: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;

Line 12836: -- END OF BEN_YR_PERD ----------------------

12832: -- END OF BEN_WTHN_YR_PERD ----------------------
12833: ---------------------------------------------------------------
12834: end if;
12835: ---------------------------------------------------------------
12836: -- END OF BEN_YR_PERD ----------------------
12837: ---------------------------------------------------------------
12838:
12839: --
12840: end create_yr_perd_result ;