APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_LER_CHG_PTIP_ENRT_F

Line 411: -- START OF BEN_LER_CHG_PTIP_ENRT_F ----------------------

407: ---------------------------------------------------------------
408: -- END OF BEN_LER_CHG_DPNT_CVG_F ----------------------
409: ---------------------------------------------------------------
410: ---------------------------------------------------------------
411: -- START OF BEN_LER_CHG_PTIP_ENRT_F ----------------------
412: ---------------------------------------------------------------
413: cursor c_lct1_from_parent(c_PTIP_ID number) is
414: select distinct ler_chg_ptip_enrt_id
415: from BEN_LER_CHG_PTIP_ENRT_F

Line 415: from BEN_LER_CHG_PTIP_ENRT_F

411: -- START OF BEN_LER_CHG_PTIP_ENRT_F ----------------------
412: ---------------------------------------------------------------
413: cursor c_lct1_from_parent(c_PTIP_ID number) is
414: select distinct ler_chg_ptip_enrt_id
415: from BEN_LER_CHG_PTIP_ENRT_F
416: where PTIP_ID = c_PTIP_ID ;
417: --
418: cursor c_lct1(c_ler_chg_ptip_enrt_id number,c_mirror_src_entity_result_id number ,
419: c_table_alias varchar2) is

Line 421: from BEN_LER_CHG_PTIP_ENRT_F lct

417: --
418: cursor c_lct1(c_ler_chg_ptip_enrt_id number,c_mirror_src_entity_result_id number ,
419: c_table_alias varchar2) is
420: select lct.*
421: from BEN_LER_CHG_PTIP_ENRT_F lct
422: where lct.ler_chg_ptip_enrt_id = c_ler_chg_ptip_enrt_id
423: and not exists (
424: select /* */ null
425: from ben_copy_entity_results cpe

Line 450: -- END OF BEN_LER_CHG_PTIP_ENRT_F ----------------------

446: and information1 = c_ler_chg_ptip_enrt_id
447: ;
448: l_out_lct_result_id number(15);
449: ---------------------------------------------------------------
450: -- END OF BEN_LER_CHG_PTIP_ENRT_F ----------------------
451: ---------------------------------------------------------------
452: ---------------------------------------------------------------
453: -- START OF BEN_PTIP_DPNT_CVG_CTFN_F ----------------------
454: ---------------------------------------------------------------

Line 3417: -- START OF BEN_LER_CHG_PTIP_ENRT_F ----------------------

3413: ---------------------------------------------------------------
3414: -- END OF BEN_LER_CHG_DPNT_CVG_F ----------------------
3415: ---------------------------------------------------------------
3416: ---------------------------------------------------------------
3417: -- START OF BEN_LER_CHG_PTIP_ENRT_F ----------------------
3418: ---------------------------------------------------------------
3419: --
3420: for l_parent_rec in c_lct1_from_parent(l_PTIP_ID) loop
3421: --

Line 3575: -- END OF BEN_LER_CHG_PTIP_ENRT_F ----------------------

3571: end loop;
3572: --
3573: end loop;
3574: ---------------------------------------------------------------
3575: -- END OF BEN_LER_CHG_PTIP_ENRT_F ----------------------
3576: ---------------------------------------------------------------
3577: ---------------------------------------------------------------
3578: -- START OF BEN_PTIP_DPNT_CVG_CTFN_F ----------------------
3579: ---------------------------------------------------------------