APPS.BEN_EXT_ELIG dependencies on BEN_EXTRACT

Line 1804: if ben_extract.g_chcrt_csr = 'Y' then

1800: close c_pl_elig;
1801: --
1802: -- Addition rate informations
1803: --
1804: if ben_extract.g_chcrt_csr = 'Y' then
1805: --
1806: get_rt_info( p_elig_per_elctbl_chc_id => l_elig_per_elctbl_chc_id_va(i));
1807: --
1808: end if;

Line 1813: if ben_extract.g_eprem_csr = 'Y' then

1809: --
1810: -- Premium informations
1811: --
1812:
1813: if ben_extract.g_eprem_csr = 'Y' then
1814: --
1815: open c_prem_tot(l_elig_per_elctbl_chc_id_va(i));
1816: --
1817: fetch c_prem_tot into ben_ext_person.g_elig_total_premium_amt

Line 1827: if ben_extract.g_ergrp_csr = 'Y' then

1823: --
1824: --
1825: -- Reporting group informations
1826: --
1827: if ben_extract.g_ergrp_csr = 'Y' then
1828: --
1829: open c_rpt_grp(l_elig_per_elctbl_chc_id_va(i));
1830: --
1831: fetch c_rpt_grp into ben_ext_person.g_elig_rpt_group_id,

Line 1841: if ben_extract.g_eplyr_csr = 'Y' then

1837: --
1838: --
1839: -- Plan Year informations
1840: --
1841: if ben_extract.g_eplyr_csr = 'Y' then
1842: --
1843: open c_pl_yr(l_elig_per_elctbl_chc_id_va(i));
1844: --
1845: fetch c_pl_yr into ben_ext_person.g_elig_pl_yr_strdt,

Line 1854: if ben_extract.g_eler_csr = 'Y' then

1850: end if;
1851: --
1852: -- Life Event informations
1853: --
1854: if ben_extract.g_eler_csr = 'Y' then
1855: --
1856: open c_ler(l_elig_per_in_ler_id_va(i)) ;
1857: --
1858: fetch c_ler into ben_ext_person.g_elig_ler_id,

Line 1870: hr_utility.set_location(' cobra cursor ' || ben_Extract.g_cbradm_csr ,160);

1866: end if;
1867:
1868: --
1869: -- cobra admin information
1870: hr_utility.set_location(' cobra cursor ' || ben_Extract.g_cbradm_csr ,160);
1871: if ben_Extract.g_cbradm_csr = 'Y' then
1872:
1873: hr_utility.set_location('getting cobra admin ' ,160);
1874: open c_cbradm_pl(l_elig_pl_id_va(i));

Line 1871: if ben_Extract.g_cbradm_csr = 'Y' then

1867:
1868: --
1869: -- cobra admin information
1870: hr_utility.set_location(' cobra cursor ' || ben_Extract.g_cbradm_csr ,160);
1871: if ben_Extract.g_cbradm_csr = 'Y' then
1872:
1873: hr_utility.set_location('getting cobra admin ' ,160);
1874: open c_cbradm_pl(l_elig_pl_id_va(i));
1875: fetch c_cbradm_pl into ben_ext_person.g_elig_cobra_admin_name ,

Line 1922: if ben_extract.g_eligdpnt_lvl = 'Y' then

1918: p_effective_date => p_effective_date);
1919: --
1920: -- Call Eligible Dependents routine
1921: --
1922: if ben_extract.g_eligdpnt_lvl = 'Y' then
1923: --
1924: ben_ext_elig_dpnt.main
1925: (p_person_id => p_person_id,
1926: p_elig_per_elctbl_chc_id => l_elig_per_elctbl_chc_id_va(i),