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_ENRT_CTFN_F

Line 418: -- START OF BEN_ENRT_CTFN_F ----------------------

414: -- END OF BEN_LER_BNFT_RSTRN_F ----------------------
415: ---------------------------------------------------------------
416: ---
417: ---------------------------------------------------------------
418: -- START OF BEN_ENRT_CTFN_F ----------------------
419: ---------------------------------------------------------------
420: cursor c_ecf_from_parent(c_PL_ID number) is
421: select enrt_ctfn_id
422: from BEN_ENRT_CTFN_F

Line 422: from BEN_ENRT_CTFN_F

418: -- START OF BEN_ENRT_CTFN_F ----------------------
419: ---------------------------------------------------------------
420: cursor c_ecf_from_parent(c_PL_ID number) is
421: select enrt_ctfn_id
422: from BEN_ENRT_CTFN_F
423: where PL_ID = c_PL_ID ;
424: --
425: cursor c_ecf(c_enrt_ctfn_id number,c_mirror_src_entity_result_id number,
426: c_table_alias varchar2) is

Line 428: from BEN_ENRT_CTFN_F ecf

424: --
425: cursor c_ecf(c_enrt_ctfn_id number,c_mirror_src_entity_result_id number,
426: c_table_alias varchar2) is
427: select ecf.*
428: from BEN_ENRT_CTFN_F ecf
429: where ecf.enrt_ctfn_id = c_enrt_ctfn_id
430: -- and ecf.business_group_id = p_business_group_id
431: and not exists (
432: select /*+ */ null

Line 439: -- and trt.where_clause = 'BEN_ENRT_CTFN_F'

435: where copy_entity_txn_id = p_copy_entity_txn_id
436: -- and trt.table_route_id = cpe.table_route_id
437: and ( -- c_mirror_src_entity_result_id is null or
438: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
439: -- and trt.where_clause = 'BEN_ENRT_CTFN_F'
440: and cpe.table_alias = c_table_alias
441: and information1 = c_enrt_ctfn_id
442: -- and information4 = ecf.business_group_id
443: and information2 = ecf.effective_start_date

Line 449: -- END OF BEN_ENRT_CTFN_F ----------------------

445: );
446:
447: l_out_ecf_result_id number(15);
448: ---------------------------------------------------------------
449: -- END OF BEN_ENRT_CTFN_F ----------------------
450: ---------------------------------------------------------------
451: ---------------------------------------------------------------
452: -- START OF BEN_LER_CHG_DPNT_CVG_F ----------------------
453: ---------------------------------------------------------------

Line 4155: -- START OF BEN_ENRT_CTFN_F ----------------------

4151: -- END OF BEN_LER_BNFT_RSTRN_F ----------------------
4152: ---------------------------------------------------------------
4153:
4154: ---------------------------------------------------------------
4155: -- START OF BEN_ENRT_CTFN_F ----------------------
4156: ---------------------------------------------------------------
4157: --
4158: --
4159: for l_parent_rec in c_ecf_from_parent(l_PL_ID) loop

Line 4267: -- END OF BEN_ENRT_CTFN_F ----------------------

4263: end loop;
4264: --
4265: end loop;
4266: ---------------------------------------------------------------
4267: -- END OF BEN_ENRT_CTFN_F ----------------------
4268: ---------------------------------------------------------------
4269:
4270: ---------------------------------------------------------------
4271: -- START OF BEN_LER_CHG_DPNT_CVG_F ----------------------

Line 10266: -- START OF BEN_ENRT_CTFN_F ----------------------

10262: ---------------------------------------------------------------
10263: -- END OF BEN_LER_CHG_OIPL_ENRT_F ----------------------
10264: ---------------------------------------------------------------
10265: ---------------------------------------------------------------
10266: -- START OF BEN_ENRT_CTFN_F ----------------------
10267: ---------------------------------------------------------------
10268: cursor c_ecf1_from_parent(c_OIPL_ID number) is
10269: select enrt_ctfn_id
10270: from BEN_ENRT_CTFN_F

Line 10270: from BEN_ENRT_CTFN_F

10266: -- START OF BEN_ENRT_CTFN_F ----------------------
10267: ---------------------------------------------------------------
10268: cursor c_ecf1_from_parent(c_OIPL_ID number) is
10269: select enrt_ctfn_id
10270: from BEN_ENRT_CTFN_F
10271: where OIPL_ID = c_OIPL_ID ;
10272: --
10273: cursor c_ecf1(c_enrt_ctfn_id number,c_mirror_src_entity_result_id number,
10274: c_table_alias varchar2) is

Line 10276: from BEN_ENRT_CTFN_F ecf

10272: --
10273: cursor c_ecf1(c_enrt_ctfn_id number,c_mirror_src_entity_result_id number,
10274: c_table_alias varchar2) is
10275: select ecf.*
10276: from BEN_ENRT_CTFN_F ecf
10277: where ecf.enrt_ctfn_id = c_enrt_ctfn_id
10278: -- and ecf.business_group_id = p_business_group_id
10279: and not exists (
10280: select /*+ */ null

Line 10287: -- and trt.where_clause = 'BEN_ENRT_CTFN_F'

10283: where copy_entity_txn_id = p_copy_entity_txn_id
10284: -- and trt.table_route_id = cpe.table_route_id
10285: and ( -- c_mirror_src_entity_result_id is null or
10286: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
10287: -- and trt.where_clause = 'BEN_ENRT_CTFN_F'
10288: and cpe.table_alias = c_table_alias
10289: and information1 = c_enrt_ctfn_id
10290: -- and information4 = ecf.business_group_id
10291: and information2 = ecf.effective_start_date

Line 10296: -- END OF BEN_ENRT_CTFN_F ----------------------

10292: and information3 = ecf.effective_end_date
10293: );
10294: l_out_ecf_result_id number(15);
10295: ---------------------------------------------------------------
10296: -- END OF BEN_ENRT_CTFN_F ----------------------
10297: ---------------------------------------------------------------
10298: ---------------------------------------------------------------
10299: -- START OF BEN_LER_RQRS_ENRT_CTFN_F ----------------------
10300: ---------------------------------------------------------------

Line 11204: -- START OF BEN_ENRT_CTFN_F ----------------------

11200: ---------------------------------------------------------------
11201: -- END OF BEN_LER_CHG_OIPL_ENRT_F ----------------------
11202: ---------------------------------------------------------------
11203: ---------------------------------------------------------------
11204: -- START OF BEN_ENRT_CTFN_F ----------------------
11205: ---------------------------------------------------------------
11206: --
11207: for l_parent_rec in c_ecf1_from_parent(l_OIPL_ID) loop
11208: --

Line 11301: -- END OF BEN_ENRT_CTFN_F ----------------------

11297: end loop;
11298: --
11299: end loop;
11300: ---------------------------------------------------------------
11301: -- END OF BEN_ENRT_CTFN_F ----------------------
11302: ---------------------------------------------------------------
11303: ---------------------------------------------------------------
11304: -- START OF BEN_LER_RQRS_ENRT_CTFN_F ----------------------
11305: ---------------------------------------------------------------