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
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
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
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: ---------------------------------------------------------------
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
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
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
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: ---------------------------------------------------------------
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: --
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 ----------------------
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: --
3405: end loop;
3406: --
3407: end loop;
3408: ---------------------------------------------------------------
3409: -- END OF BEN_LER_CHG_DPNT_CVG_CTFN_F ----------------------
3410: ---------------------------------------------------------------
3411: --
3412: end loop;
3413: ---------------------------------------------------------------