APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_WV_PRTN_RSN_PTIP_F

Line 483: -- START OF BEN_WV_PRTN_RSN_PTIP_F ----------------------

479: ---------------------------------------------------------------
480: -- END OF BEN_PTIP_DPNT_CVG_CTFN_F ----------------------
481: ---------------------------------------------------------------
482: ---------------------------------------------------------------
483: -- START OF BEN_WV_PRTN_RSN_PTIP_F ----------------------
484: ---------------------------------------------------------------
485: cursor c_wpt1_from_parent(c_PTIP_ID number) is
486: select wv_prtn_rsn_ptip_id
487: from BEN_WV_PRTN_RSN_PTIP_F

Line 487: from BEN_WV_PRTN_RSN_PTIP_F

483: -- START OF BEN_WV_PRTN_RSN_PTIP_F ----------------------
484: ---------------------------------------------------------------
485: cursor c_wpt1_from_parent(c_PTIP_ID number) is
486: select wv_prtn_rsn_ptip_id
487: from BEN_WV_PRTN_RSN_PTIP_F
488: where PTIP_ID = c_PTIP_ID ;
489: --
490: cursor c_wpt1(c_wv_prtn_rsn_ptip_id number,c_mirror_src_entity_result_id number ,
491: c_table_alias varchar2) is

Line 493: from BEN_WV_PRTN_RSN_PTIP_F wpt

489: --
490: cursor c_wpt1(c_wv_prtn_rsn_ptip_id number,c_mirror_src_entity_result_id number ,
491: c_table_alias varchar2) is
492: select wpt.*
493: from BEN_WV_PRTN_RSN_PTIP_F wpt
494: where wpt.wv_prtn_rsn_ptip_id = c_wv_prtn_rsn_ptip_id
495: and not exists (
496: select /* */ null
497: from ben_copy_entity_results cpe

Line 510: -- END OF BEN_WV_PRTN_RSN_PTIP_F ----------------------

506: );
507: l_wv_prtn_rsn_ptip_id number(15);
508: l_out_wpt_result_id number(15);
509: ---------------------------------------------------------------
510: -- END OF BEN_WV_PRTN_RSN_PTIP_F ----------------------
511: ---------------------------------------------------------------
512: ---------------------------------------------------------------
513: -- START OF BEN_WV_PRTN_RSN_CTFN_PTIP_F ----------------------
514: ---------------------------------------------------------------

Line 3703: -- START OF BEN_WV_PRTN_RSN_PTIP_F ----------------------

3699: ---------------------------------------------------------------
3700: -- END OF BEN_PTIP_DPNT_CVG_CTFN_F ----------------------
3701: ---------------------------------------------------------------
3702: ---------------------------------------------------------------
3703: -- START OF BEN_WV_PRTN_RSN_PTIP_F ----------------------
3704: ---------------------------------------------------------------
3705: --
3706: for l_parent_rec in c_wpt1_from_parent(l_PTIP_ID) loop
3707: --

Line 3923: -- END OF BEN_WV_PRTN_RSN_PTIP_F ----------------------

3919: ---------------------------------------------------------------
3920: --
3921: end loop;
3922: ---------------------------------------------------------------
3923: -- END OF BEN_WV_PRTN_RSN_PTIP_F ----------------------
3924: ---------------------------------------------------------------
3925: --
3926: end loop;
3927: ---------------------------------------------------------------