APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_WV_PRTN_RSN_CTFN_PTIP_F

Line 513: -- START OF BEN_WV_PRTN_RSN_CTFN_PTIP_F ----------------------

509: ---------------------------------------------------------------
510: -- END OF BEN_WV_PRTN_RSN_PTIP_F ----------------------
511: ---------------------------------------------------------------
512: ---------------------------------------------------------------
513: -- START OF BEN_WV_PRTN_RSN_CTFN_PTIP_F ----------------------
514: ---------------------------------------------------------------
515: cursor c_wct1_from_parent(c_WV_PRTN_RSN_PTIP_ID number) is
516: select wv_prtn_rsn_ctfn_ptip_id
517: from BEN_WV_PRTN_RSN_CTFN_PTIP_F

Line 517: from BEN_WV_PRTN_RSN_CTFN_PTIP_F

513: -- START OF BEN_WV_PRTN_RSN_CTFN_PTIP_F ----------------------
514: ---------------------------------------------------------------
515: cursor c_wct1_from_parent(c_WV_PRTN_RSN_PTIP_ID number) is
516: select wv_prtn_rsn_ctfn_ptip_id
517: from BEN_WV_PRTN_RSN_CTFN_PTIP_F
518: where WV_PRTN_RSN_PTIP_ID = c_WV_PRTN_RSN_PTIP_ID ;
519: --
520: cursor c_wct1(c_wv_prtn_rsn_ctfn_ptip_id number,c_mirror_src_entity_result_id number ,
521: c_table_alias varchar2) is

Line 523: from BEN_WV_PRTN_RSN_CTFN_PTIP_F wct

519: --
520: cursor c_wct1(c_wv_prtn_rsn_ctfn_ptip_id number,c_mirror_src_entity_result_id number ,
521: c_table_alias varchar2) is
522: select wct.*
523: from BEN_WV_PRTN_RSN_CTFN_PTIP_F wct
524: where wct.wv_prtn_rsn_ctfn_ptip_id = c_wv_prtn_rsn_ctfn_ptip_id
525: and not exists (
526: select /* */ null
527: from ben_copy_entity_results cpe

Line 540: -- END OF BEN_WV_PRTN_RSN_CTFN_PTIP_F ----------------------

536: );
537: l_wv_prtn_rsn_ctfn_ptip_id number(15);
538: l_out_wct_result_id number(15);
539: ---------------------------------------------------------------
540: -- END OF BEN_WV_PRTN_RSN_CTFN_PTIP_F ----------------------
541: ---------------------------------------------------------------
542: ---------------------------------------------------------------
543: -- START OF BEN_LER_CHG_DPNT_CVG_CTFN_F ----------------------
544: ---------------------------------------------------------------

Line 3796: -- START OF BEN_WV_PRTN_RSN_CTFN_PTIP_F ----------------------

3792: end if;
3793: --
3794: end loop;
3795: ---------------------------------------------------------------
3796: -- START OF BEN_WV_PRTN_RSN_CTFN_PTIP_F ----------------------
3797: ---------------------------------------------------------------
3798: --
3799: for l_parent_rec in c_wct1_from_parent(l_WV_PRTN_RSN_PTIP_ID) loop
3800: --

Line 3918: -- END OF BEN_WV_PRTN_RSN_CTFN_PTIP_F ----------------------

3914: end loop;
3915: --
3916: end loop;
3917: ---------------------------------------------------------------
3918: -- END OF BEN_WV_PRTN_RSN_CTFN_PTIP_F ----------------------
3919: ---------------------------------------------------------------
3920: --
3921: end loop;
3922: ---------------------------------------------------------------