1653: --
1654: l_elctbl_chc c_elctbl_chc%rowtype;
1655: */
1656: --
1657: l_elctbl_chc ben_epe_cache.g_pilepe_inst_row;
1658: --
1659: cursor c_per_in_ler is
1660: select pil.ler_id,
1661: pil.person_id,
1684: l_chc_id := p_elig_per_elctbl_chc_id;
1685: --
1686: -- Check that current comp object loop EPE row is set
1687: --
1688: if ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id is not null then
1689: --
1690: l_elctbl_chc.elig_per_elctbl_chc_id := ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id;
1691: l_elctbl_chc.pl_id := ben_epe_cache.g_currcobjepe_row.pl_id;
1692: l_elctbl_chc.plip_id := ben_epe_cache.g_currcobjepe_row.plip_id;
1686: -- Check that current comp object loop EPE row is set
1687: --
1688: if ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id is not null then
1689: --
1690: l_elctbl_chc.elig_per_elctbl_chc_id := ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id;
1691: l_elctbl_chc.pl_id := ben_epe_cache.g_currcobjepe_row.pl_id;
1692: l_elctbl_chc.plip_id := ben_epe_cache.g_currcobjepe_row.plip_id;
1693: l_elctbl_chc.oipl_id := ben_epe_cache.g_currcobjepe_row.oipl_id;
1694: l_elctbl_chc.elctbl_flag := ben_epe_cache.g_currcobjepe_row.elctbl_flag;
1687: --
1688: if ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id is not null then
1689: --
1690: l_elctbl_chc.elig_per_elctbl_chc_id := ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id;
1691: l_elctbl_chc.pl_id := ben_epe_cache.g_currcobjepe_row.pl_id;
1692: l_elctbl_chc.plip_id := ben_epe_cache.g_currcobjepe_row.plip_id;
1693: l_elctbl_chc.oipl_id := ben_epe_cache.g_currcobjepe_row.oipl_id;
1694: l_elctbl_chc.elctbl_flag := ben_epe_cache.g_currcobjepe_row.elctbl_flag;
1695: l_elctbl_chc.per_in_ler_id := ben_epe_cache.g_currcobjepe_row.per_in_ler_id;
1688: if ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id is not null then
1689: --
1690: l_elctbl_chc.elig_per_elctbl_chc_id := ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id;
1691: l_elctbl_chc.pl_id := ben_epe_cache.g_currcobjepe_row.pl_id;
1692: l_elctbl_chc.plip_id := ben_epe_cache.g_currcobjepe_row.plip_id;
1693: l_elctbl_chc.oipl_id := ben_epe_cache.g_currcobjepe_row.oipl_id;
1694: l_elctbl_chc.elctbl_flag := ben_epe_cache.g_currcobjepe_row.elctbl_flag;
1695: l_elctbl_chc.per_in_ler_id := ben_epe_cache.g_currcobjepe_row.per_in_ler_id;
1696: l_elctbl_chc.business_group_id := ben_epe_cache.g_currcobjepe_row.business_group_id;
1689: --
1690: l_elctbl_chc.elig_per_elctbl_chc_id := ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id;
1691: l_elctbl_chc.pl_id := ben_epe_cache.g_currcobjepe_row.pl_id;
1692: l_elctbl_chc.plip_id := ben_epe_cache.g_currcobjepe_row.plip_id;
1693: l_elctbl_chc.oipl_id := ben_epe_cache.g_currcobjepe_row.oipl_id;
1694: l_elctbl_chc.elctbl_flag := ben_epe_cache.g_currcobjepe_row.elctbl_flag;
1695: l_elctbl_chc.per_in_ler_id := ben_epe_cache.g_currcobjepe_row.per_in_ler_id;
1696: l_elctbl_chc.business_group_id := ben_epe_cache.g_currcobjepe_row.business_group_id;
1697: l_elctbl_chc.object_version_number := ben_epe_cache.g_currcobjepe_row.object_version_number;
1690: l_elctbl_chc.elig_per_elctbl_chc_id := ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id;
1691: l_elctbl_chc.pl_id := ben_epe_cache.g_currcobjepe_row.pl_id;
1692: l_elctbl_chc.plip_id := ben_epe_cache.g_currcobjepe_row.plip_id;
1693: l_elctbl_chc.oipl_id := ben_epe_cache.g_currcobjepe_row.oipl_id;
1694: l_elctbl_chc.elctbl_flag := ben_epe_cache.g_currcobjepe_row.elctbl_flag;
1695: l_elctbl_chc.per_in_ler_id := ben_epe_cache.g_currcobjepe_row.per_in_ler_id;
1696: l_elctbl_chc.business_group_id := ben_epe_cache.g_currcobjepe_row.business_group_id;
1697: l_elctbl_chc.object_version_number := ben_epe_cache.g_currcobjepe_row.object_version_number;
1698: --
1691: l_elctbl_chc.pl_id := ben_epe_cache.g_currcobjepe_row.pl_id;
1692: l_elctbl_chc.plip_id := ben_epe_cache.g_currcobjepe_row.plip_id;
1693: l_elctbl_chc.oipl_id := ben_epe_cache.g_currcobjepe_row.oipl_id;
1694: l_elctbl_chc.elctbl_flag := ben_epe_cache.g_currcobjepe_row.elctbl_flag;
1695: l_elctbl_chc.per_in_ler_id := ben_epe_cache.g_currcobjepe_row.per_in_ler_id;
1696: l_elctbl_chc.business_group_id := ben_epe_cache.g_currcobjepe_row.business_group_id;
1697: l_elctbl_chc.object_version_number := ben_epe_cache.g_currcobjepe_row.object_version_number;
1698: --
1699: else
1692: l_elctbl_chc.plip_id := ben_epe_cache.g_currcobjepe_row.plip_id;
1693: l_elctbl_chc.oipl_id := ben_epe_cache.g_currcobjepe_row.oipl_id;
1694: l_elctbl_chc.elctbl_flag := ben_epe_cache.g_currcobjepe_row.elctbl_flag;
1695: l_elctbl_chc.per_in_ler_id := ben_epe_cache.g_currcobjepe_row.per_in_ler_id;
1696: l_elctbl_chc.business_group_id := ben_epe_cache.g_currcobjepe_row.business_group_id;
1697: l_elctbl_chc.object_version_number := ben_epe_cache.g_currcobjepe_row.object_version_number;
1698: --
1699: else
1700: --
1693: l_elctbl_chc.oipl_id := ben_epe_cache.g_currcobjepe_row.oipl_id;
1694: l_elctbl_chc.elctbl_flag := ben_epe_cache.g_currcobjepe_row.elctbl_flag;
1695: l_elctbl_chc.per_in_ler_id := ben_epe_cache.g_currcobjepe_row.per_in_ler_id;
1696: l_elctbl_chc.business_group_id := ben_epe_cache.g_currcobjepe_row.business_group_id;
1697: l_elctbl_chc.object_version_number := ben_epe_cache.g_currcobjepe_row.object_version_number;
1698: --
1699: else
1700: --
1701: return;