APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_PL_BNF_CTFN_F

Line 653: -- START OF BEN_PL_BNF_CTFN_F ----------------------

649: ---------------------------------------------------------------
650: -- END OF BEN_PL_PCP_TYP ----------------------
651: ---------------------------------------------------------------
652: ---------------------------------------------------------------
653: -- START OF BEN_PL_BNF_CTFN_F ----------------------
654: ---------------------------------------------------------------
655: cursor c_pcx_from_parent(c_PL_ID number) is
656: select pl_bnf_ctfn_id
657: from BEN_PL_BNF_CTFN_F

Line 657: from BEN_PL_BNF_CTFN_F

653: -- START OF BEN_PL_BNF_CTFN_F ----------------------
654: ---------------------------------------------------------------
655: cursor c_pcx_from_parent(c_PL_ID number) is
656: select pl_bnf_ctfn_id
657: from BEN_PL_BNF_CTFN_F
658: where PL_ID = c_PL_ID ;
659: --
660: cursor c_pcx(c_pl_bnf_ctfn_id number,c_mirror_src_entity_result_id number,
661: c_table_alias varchar2) is

Line 663: from BEN_PL_BNF_CTFN_F pcx

659: --
660: cursor c_pcx(c_pl_bnf_ctfn_id number,c_mirror_src_entity_result_id number,
661: c_table_alias varchar2) is
662: select pcx.*
663: from BEN_PL_BNF_CTFN_F pcx
664: where pcx.pl_bnf_ctfn_id = c_pl_bnf_ctfn_id
665: -- and pcx.business_group_id = p_business_group_id
666: and not exists (
667: select /*+ */ null

Line 674: -- and trt.where_clause = 'BEN_PL_BNF_CTFN_F'

670: where copy_entity_txn_id = p_copy_entity_txn_id
671: -- and trt.table_route_id = cpe.table_route_id
672: and ( -- c_mirror_src_entity_result_id is null or
673: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
674: -- and trt.where_clause = 'BEN_PL_BNF_CTFN_F'
675: and cpe.table_alias = c_table_alias
676: and information1 = c_pl_bnf_ctfn_id
677: -- and information4 = pcx.business_group_id
678: and information2 = pcx.effective_start_date

Line 684: -- END OF BEN_PL_BNF_CTFN_F ----------------------

680: );
681:
682: l_out_pcx_result_id number(15);
683: ---------------------------------------------------------------
684: -- END OF BEN_PL_BNF_CTFN_F ----------------------
685: ---------------------------------------------------------------
686: ---------------------------------------------------------------
687: -- START OF BEN_PL_DPNT_CVG_CTFN_F ----------------------
688: ---------------------------------------------------------------

Line 5134: -- START OF BEN_PL_BNF_CTFN_F ----------------------

5130: ---------------------------------------------------------------
5131: -- END OF BEN_PL_PCP_TYP ----------------------
5132: ---------------------------------------------------------------
5133: ---------------------------------------------------------------
5134: -- START OF BEN_PL_BNF_CTFN_F ----------------------
5135: ---------------------------------------------------------------
5136: --
5137: --
5138: for l_parent_rec in c_pcx_from_parent(l_PL_ID) loop

Line 5246: -- END OF BEN_PL_BNF_CTFN_F ----------------------

5242: end loop;
5243: --
5244: end loop;
5245: ---------------------------------------------------------------
5246: -- END OF BEN_PL_BNF_CTFN_F ----------------------
5247: ---------------------------------------------------------------
5248: ---------------------------------------------------------------
5249: -- START OF BEN_PL_DPNT_CVG_CTFN_F ----------------------
5250: ---------------------------------------------------------------