APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_LER_CHG_DPNT_CVG_CTFN_F

Line 250: -- START OF BEN_LER_CHG_DPNT_CVG_CTFN_F ----------------------

246: ---------------------------------------------------------------
247: -- END OF BEN_PGM_DPNT_CVG_CTFN_F ----------------------
248: ---------------------------------------------------------------
249: ---------------------------------------------------------------
250: -- START OF BEN_LER_CHG_DPNT_CVG_CTFN_F ----------------------
251: ---------------------------------------------------------------
252: cursor c_lcc_from_parent(c_LER_CHG_DPNT_CVG_ID number) is
253: select ler_chg_dpnt_cvg_ctfn_id
254: from BEN_LER_CHG_DPNT_CVG_CTFN_F

Line 254: from BEN_LER_CHG_DPNT_CVG_CTFN_F

250: -- START OF BEN_LER_CHG_DPNT_CVG_CTFN_F ----------------------
251: ---------------------------------------------------------------
252: cursor c_lcc_from_parent(c_LER_CHG_DPNT_CVG_ID number) is
253: select ler_chg_dpnt_cvg_ctfn_id
254: from BEN_LER_CHG_DPNT_CVG_CTFN_F
255: where LER_CHG_DPNT_CVG_ID = c_LER_CHG_DPNT_CVG_ID ;
256: --
257: cursor c_lcc(c_ler_chg_dpnt_cvg_ctfn_id number ,c_mirror_src_entity_result_id number,
258: c_table_alias varchar2) is

Line 260: from BEN_LER_CHG_DPNT_CVG_CTFN_F lcc

256: --
257: cursor c_lcc(c_ler_chg_dpnt_cvg_ctfn_id number ,c_mirror_src_entity_result_id number,
258: c_table_alias varchar2) is
259: select lcc.*
260: from BEN_LER_CHG_DPNT_CVG_CTFN_F lcc
261: where lcc.ler_chg_dpnt_cvg_ctfn_id = c_ler_chg_dpnt_cvg_ctfn_id
262: and not exists (
263: select /* */ null
264: from ben_copy_entity_results cpe

Line 277: -- END OF BEN_LER_CHG_DPNT_CVG_CTFN_F ----------------------

273: );
274: l_ler_chg_dpnt_cvg_ctfn_id number(15);
275: l_out_lcc_result_id number(15);
276: ---------------------------------------------------------------
277: -- END OF BEN_LER_CHG_DPNT_CVG_CTFN_F ----------------------
278: ---------------------------------------------------------------
279: ---------------------------------------------------------------
280: -- START OF BEN_PLIP_F ----------------------
281: ---------------------------------------------------------------

Line 543: -- START OF BEN_LER_CHG_DPNT_CVG_CTFN_F ----------------------

539: ---------------------------------------------------------------
540: -- END OF BEN_WV_PRTN_RSN_CTFN_PTIP_F ----------------------
541: ---------------------------------------------------------------
542: ---------------------------------------------------------------
543: -- START OF BEN_LER_CHG_DPNT_CVG_CTFN_F ----------------------
544: ---------------------------------------------------------------
545: cursor c_lcc1_from_parent(c_LER_CHG_DPNT_CVG_ID number) is
546: select ler_chg_dpnt_cvg_ctfn_id
547: from BEN_LER_CHG_DPNT_CVG_CTFN_F

Line 547: from BEN_LER_CHG_DPNT_CVG_CTFN_F

543: -- START OF BEN_LER_CHG_DPNT_CVG_CTFN_F ----------------------
544: ---------------------------------------------------------------
545: cursor c_lcc1_from_parent(c_LER_CHG_DPNT_CVG_ID number) is
546: select ler_chg_dpnt_cvg_ctfn_id
547: from BEN_LER_CHG_DPNT_CVG_CTFN_F
548: where LER_CHG_DPNT_CVG_ID = c_LER_CHG_DPNT_CVG_ID ;
549: --
550: cursor c_lcc1(c_ler_chg_dpnt_cvg_ctfn_id number,c_mirror_src_entity_result_id number ,
551: c_table_alias varchar2) is

Line 553: from BEN_LER_CHG_DPNT_CVG_CTFN_F lcc

549: --
550: cursor c_lcc1(c_ler_chg_dpnt_cvg_ctfn_id number,c_mirror_src_entity_result_id number ,
551: c_table_alias varchar2) is
552: select lcc.*
553: from BEN_LER_CHG_DPNT_CVG_CTFN_F lcc
554: where lcc.ler_chg_dpnt_cvg_ctfn_id = c_ler_chg_dpnt_cvg_ctfn_id
555: and not exists (
556: select /* */ null
557: from ben_copy_entity_results cpe

Line 571: -- END OF BEN_LER_CHG_DPNT_CVG_CTFN_F ----------------------

567:
568: l_ler_chg_dpnt_cvg_ctfn_id1 number;
569: l_out_lcc1_result_id number(15);
570: ---------------------------------------------------------------
571: -- END OF BEN_LER_CHG_DPNT_CVG_CTFN_F ----------------------
572: ---------------------------------------------------------------
573: ---------------------------------------------------------------
574: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
575: ---------------------------------------------------------------

Line 1636: -- START OF BEN_LER_CHG_DPNT_CVG_CTFN_F ----------------------

1632: ,p_effective_date => p_effective_date
1633: );
1634: end loop ;
1635: ---------------------------------------------------------------
1636: -- START OF BEN_LER_CHG_DPNT_CVG_CTFN_F ----------------------
1637: ---------------------------------------------------------------
1638: --
1639: for l_parent_rec in c_lcc_from_parent(l_LER_CHG_DPNT_CVG_ID) loop
1640: --

Line 1756: -- END OF BEN_LER_CHG_DPNT_CVG_CTFN_F ----------------------

1752: end loop;
1753: --
1754: end loop;
1755: ---------------------------------------------------------------
1756: -- END OF BEN_LER_CHG_DPNT_CVG_CTFN_F ----------------------
1757: ---------------------------------------------------------------
1758: end loop;
1759: ---------------------------------------------------------------
1760: -- END OF BEN_LER_CHG_DPNT_CVG_F ----------------------

Line 3311: -- START OF BEN_LER_CHG_DPNT_CVG_CTFN_F ----------------------

3307: ,p_effective_date => p_effective_date
3308: );
3309: end loop;
3310: ---------------------------------------------------------------
3311: -- START OF BEN_LER_CHG_DPNT_CVG_CTFN_F ----------------------
3312: ---------------------------------------------------------------
3313: --
3314: for l_parent_rec in c_lcc1_from_parent(l_LER_CHG_DPNT_CVG_ID1) loop
3315: --

Line 3409: -- END OF BEN_LER_CHG_DPNT_CVG_CTFN_F ----------------------

3405: end loop;
3406: --
3407: end loop;
3408: ---------------------------------------------------------------
3409: -- END OF BEN_LER_CHG_DPNT_CVG_CTFN_F ----------------------
3410: ---------------------------------------------------------------
3411: --
3412: end loop;
3413: ---------------------------------------------------------------