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_PL_PCP

Line 589: -- START OF BEN_PL_PCP ----------------------

585: ---------------------------------------------------------------
586: -- END OF BEN_LER_RQRS_ENRT_CTFN_F ----------------------
587: ---------------------------------------------------------------
588: ---------------------------------------------------------------
589: -- START OF BEN_PL_PCP ----------------------
590: ---------------------------------------------------------------
591: cursor c_pcp_from_parent(c_PL_ID number) is
592: select pl_pcp_id
593: from BEN_PL_PCP

Line 593: from BEN_PL_PCP

589: -- START OF BEN_PL_PCP ----------------------
590: ---------------------------------------------------------------
591: cursor c_pcp_from_parent(c_PL_ID number) is
592: select pl_pcp_id
593: from BEN_PL_PCP
594: where PL_ID = c_PL_ID ;
595: --
596: cursor c_pcp(c_pl_pcp_id number,c_mirror_src_entity_result_id number,
597: c_table_alias varchar2) is

Line 599: from BEN_PL_PCP pcp

595: --
596: cursor c_pcp(c_pl_pcp_id number,c_mirror_src_entity_result_id number,
597: c_table_alias varchar2) is
598: select pcp.*
599: from BEN_PL_PCP pcp
600: where pcp.pl_pcp_id = c_pl_pcp_id
601: -- and pcp.business_group_id = p_business_group_id
602: and not exists (
603: select /*+ */ null

Line 610: -- and trt.where_clause = 'BEN_PL_PCP'

606: where copy_entity_txn_id = p_copy_entity_txn_id
607: -- and trt.table_route_id = cpe.table_route_id
608: and ( -- c_mirror_src_entity_result_id is null or
609: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
610: -- and trt.where_clause = 'BEN_PL_PCP'
611: and cpe.table_alias = c_table_alias
612: and information1 = c_pl_pcp_id
613: -- and information4 = pcp.business_group_id
614: );

Line 618: -- END OF BEN_PL_PCP ----------------------

614: );
615:
616: l_out_pcp_result_id number(15);
617: ---------------------------------------------------------------
618: -- END OF BEN_PL_PCP ----------------------
619: ---------------------------------------------------------------
620: ---------------------------------------------------------------
621: -- START OF BEN_PL_PCP_TYP ----------------------
622: ---------------------------------------------------------------

Line 621: -- START OF BEN_PL_PCP_TYP ----------------------

617: ---------------------------------------------------------------
618: -- END OF BEN_PL_PCP ----------------------
619: ---------------------------------------------------------------
620: ---------------------------------------------------------------
621: -- START OF BEN_PL_PCP_TYP ----------------------
622: ---------------------------------------------------------------
623: cursor c_pty_from_parent(c_PL_PCP_ID number) is
624: select pl_pcp_typ_id
625: from BEN_PL_PCP_TYP

Line 625: from BEN_PL_PCP_TYP

621: -- START OF BEN_PL_PCP_TYP ----------------------
622: ---------------------------------------------------------------
623: cursor c_pty_from_parent(c_PL_PCP_ID number) is
624: select pl_pcp_typ_id
625: from BEN_PL_PCP_TYP
626: where PL_PCP_ID = c_PL_PCP_ID ;
627: --
628: cursor c_pty(c_pl_pcp_typ_id number,c_mirror_src_entity_result_id number,
629: c_table_alias varchar2) is

Line 631: from BEN_PL_PCP_TYP pty

627: --
628: cursor c_pty(c_pl_pcp_typ_id number,c_mirror_src_entity_result_id number,
629: c_table_alias varchar2) is
630: select pty.*
631: from BEN_PL_PCP_TYP pty
632: where pty.pl_pcp_typ_id = c_pl_pcp_typ_id
633: -- and pty.business_group_id = p_business_group_id
634: and not exists (
635: select /*+ */ null

Line 642: -- and trt.where_clause = 'BEN_PL_PCP_TYP'

638: where copy_entity_txn_id = p_copy_entity_txn_id
639: -- and trt.table_route_id = cpe.table_route_id
640: and ( -- c_mirror_src_entity_result_id is null or
641: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
642: -- and trt.where_clause = 'BEN_PL_PCP_TYP'
643: and cpe.table_alias = c_table_alias
644: and information1 = c_pl_pcp_typ_id
645: -- and information4 = pty.business_group_id
646: );

Line 650: -- END OF BEN_PL_PCP_TYP ----------------------

646: );
647: l_pl_pcp_typ_id number(15);
648: l_out_pty_result_id number(15);
649: ---------------------------------------------------------------
650: -- END OF BEN_PL_PCP_TYP ----------------------
651: ---------------------------------------------------------------
652: ---------------------------------------------------------------
653: -- START OF BEN_PL_BNF_CTFN_F ----------------------
654: ---------------------------------------------------------------

Line 4937: -- START OF BEN_PL_PCP ----------------------

4933: ---------------------------------------------------------------
4934: -- END OF BEN_LER_RQRS_ENRT_CTFN_F ----------------------
4935: ---------------------------------------------------------------
4936: ---------------------------------------------------------------
4937: -- START OF BEN_PL_PCP ----------------------
4938: ---------------------------------------------------------------
4939: --
4940: --
4941: for l_parent_rec in c_pcp_from_parent(l_PL_ID) loop

Line 5039: -- END OF BEN_PL_PCP ----------------------

5035: end loop;
5036: --
5037: end loop;
5038: ---------------------------------------------------------------
5039: -- END OF BEN_PL_PCP ----------------------
5040: ---------------------------------------------------------------
5041: ---------------------------------------------------------------
5042: -- START OF BEN_PL_PCP_TYP ----------------------
5043: ---------------------------------------------------------------

Line 5042: -- START OF BEN_PL_PCP_TYP ----------------------

5038: ---------------------------------------------------------------
5039: -- END OF BEN_PL_PCP ----------------------
5040: ---------------------------------------------------------------
5041: ---------------------------------------------------------------
5042: -- START OF BEN_PL_PCP_TYP ----------------------
5043: ---------------------------------------------------------------
5044: --
5045: for l_parent_rec in c_pty_from_parent(l_PL_PCP_ID) loop
5046: --

Line 5131: -- END OF BEN_PL_PCP_TYP ----------------------

5127: end loop;
5128: --
5129: end loop;
5130: ---------------------------------------------------------------
5131: -- END OF BEN_PL_PCP_TYP ----------------------
5132: ---------------------------------------------------------------
5133: ---------------------------------------------------------------
5134: -- START OF BEN_PL_BNF_CTFN_F ----------------------
5135: ---------------------------------------------------------------