DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_PL_DPNT_CVG_CTFN_F

Line 687: -- START OF BEN_PL_DPNT_CVG_CTFN_F ----------------------

683: ---------------------------------------------------------------
684: -- END OF BEN_PL_BNF_CTFN_F ----------------------
685: ---------------------------------------------------------------
686: ---------------------------------------------------------------
687: -- START OF BEN_PL_DPNT_CVG_CTFN_F ----------------------
688: ---------------------------------------------------------------
689: cursor c_pnd_from_parent(c_PL_ID number) is
690: select pl_dpnt_cvg_ctfn_id
691: from BEN_PL_DPNT_CVG_CTFN_F

Line 691: from BEN_PL_DPNT_CVG_CTFN_F

687: -- START OF BEN_PL_DPNT_CVG_CTFN_F ----------------------
688: ---------------------------------------------------------------
689: cursor c_pnd_from_parent(c_PL_ID number) is
690: select pl_dpnt_cvg_ctfn_id
691: from BEN_PL_DPNT_CVG_CTFN_F
692: where PL_ID = c_PL_ID ;
693: --
694: cursor c_pnd(c_pl_dpnt_cvg_ctfn_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
695: select pnd.*

Line 696: from BEN_PL_DPNT_CVG_CTFN_F pnd

692: where PL_ID = c_PL_ID ;
693: --
694: cursor c_pnd(c_pl_dpnt_cvg_ctfn_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
695: select pnd.*
696: from BEN_PL_DPNT_CVG_CTFN_F pnd
697: where pnd.pl_dpnt_cvg_ctfn_id = c_pl_dpnt_cvg_ctfn_id
698: -- and pnd.business_group_id = p_business_group_id
699: and not exists (
700: select /*+ */ null

Line 707: -- and trt.where_clause = 'BEN_PL_DPNT_CVG_CTFN_F'

703: where copy_entity_txn_id = p_copy_entity_txn_id
704: -- and trt.table_route_id = cpe.table_route_id
705: and ( -- c_mirror_src_entity_result_id is null or
706: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
707: -- and trt.where_clause = 'BEN_PL_DPNT_CVG_CTFN_F'
708: and cpe.table_alias = c_table_alias
709: and information1 = c_pl_dpnt_cvg_ctfn_id
710: -- and information4 = pnd.business_group_id
711: and information2 = pnd.effective_start_date

Line 717: -- END OF BEN_PL_DPNT_CVG_CTFN_F ----------------------

713: );
714:
715: l_out_pnd_result_id number(15);
716: ---------------------------------------------------------------
717: -- END OF BEN_PL_DPNT_CVG_CTFN_F ----------------------
718: ---------------------------------------------------------------
719: ---------------------------------------------------------------
720: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
721: ---------------------------------------------------------------

Line 5249: -- START OF BEN_PL_DPNT_CVG_CTFN_F ----------------------

5245: ---------------------------------------------------------------
5246: -- END OF BEN_PL_BNF_CTFN_F ----------------------
5247: ---------------------------------------------------------------
5248: ---------------------------------------------------------------
5249: -- START OF BEN_PL_DPNT_CVG_CTFN_F ----------------------
5250: ---------------------------------------------------------------
5251: --
5252: --
5253: for l_parent_rec in c_pnd_from_parent(l_PL_ID) loop

Line 5361: -- END OF BEN_PL_DPNT_CVG_CTFN_F ----------------------

5357: end loop;
5358: --
5359: end loop;
5360: ---------------------------------------------------------------
5361: -- END OF BEN_PL_DPNT_CVG_CTFN_F ----------------------
5362: ---------------------------------------------------------------
5363: ---------------------------------------------------------------
5364: ---------------------------------------------------------------
5365: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------