APPS.BEN_MAINTAIN_DESIGNEE_ELIG dependencies on BEN_ELIG_DPNT

Line 1346: from ben_elig_dpnt egd,

1342: pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT'));
1343: --
1344: cursor c_max_create_dt(v_elig_per_id in number) is
1345: select max(egd.create_dt)
1346: from ben_elig_dpnt egd,
1347: ben_per_in_ler pil
1348: where egd.elig_per_id = v_elig_per_id
1349: and egd.dpnt_person_id = p_person_id
1350: and egd.per_in_ler_id = pil.per_in_ler_id (+)

Line 1357: from ben_elig_dpnt egd,

1353: --
1354: cursor c_egd(v_elig_per_id in number,
1355: v_create_dt in date) is
1356: select egd.*
1357: from ben_elig_dpnt egd,
1358: ben_per_in_ler pil
1359: where egd.elig_per_id = v_elig_per_id
1360: and egd.dpnt_person_id = p_person_id
1361: and egd.dpnt_inelig_flag = 'N'

Line 1397: l_egd_rec ben_elig_dpnt%rowtype;

1393: l_id number;
1394: l_ovn1 number;
1395: l_cache_cnt number:=0;
1396: l_found boolean := false;
1397: l_egd_rec ben_elig_dpnt%rowtype;
1398: l_dummy varchar2(1);
1399: l_comp_ineligible boolean := FALSE;
1400: l_temp_person_id number;
1401: l_min_returned_end_dt date;

Line 1615: l_found := ben_ELIG_DPNT_api.get_elig_dpnt_rec(

1611: ,p_multi_row_actn => false
1612: );
1613: end if;
1614: --
1615: l_found := ben_ELIG_DPNT_api.get_elig_dpnt_rec(
1616: p_elig_cvrd_dpnt_id => l_rec.elig_cvrd_dpnt_id
1617: ,p_effective_date => p_effective_date
1618: ,p_elig_dpnt_rec => l_egd_rec);
1619: --

Line 1622: ben_elig_dpnt_api.update_elig_dpnt(

1618: ,p_elig_dpnt_rec => l_egd_rec);
1619: --
1620: if l_found and l_egd_rec.dpnt_inelig_flag = 'N' then
1621: --
1622: ben_elig_dpnt_api.update_elig_dpnt(
1623: p_elig_dpnt_id => l_egd_rec.elig_dpnt_id
1624: ,p_object_version_number => l_egd_rec.object_version_number
1625: ,p_effective_date => p_effective_date
1626: ,p_elig_thru_dt => l_egd_elig_thru_dt --l_returned_end_dt 5100008

Line 1695: ben_elig_dpnt_api.update_elig_dpnt(

1691: close c_max_create_dt;
1692: --
1693: for l_egd in c_egd(l_elig_per_id, l_max_create_dt) loop
1694: --
1695: ben_elig_dpnt_api.update_elig_dpnt(
1696: p_elig_dpnt_id => l_egd.elig_dpnt_id
1697: ,p_object_version_number => l_egd.object_version_number
1698: ,p_effective_date => p_effective_date
1699: ,p_elig_thru_dt => l_egd_elig_thru_dt --l_returned_end_dt