APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_PL_PCP_TYP

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 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: ---------------------------------------------------------------