[Home] [Help]
1361: --
1362: cursor c_unrestricted is
1363: select null
1364: from ben_per_in_ler pil,
1365: ben_ler_f ler
1366: where pil.per_in_ler_id = p_per_in_ler_id
1367: and pil.ler_id = ler.ler_id
1368: and ler.typ_cd = 'SCHEDDU'
1369: and ler.business_group_id = p_business_group_id
1374: -- Bug 8374859
1375: cursor c_ler_id is
1376: select ler.ler_id
1377: from ben_per_in_ler pil,
1378: ben_ler_f ler
1379: where pil.per_in_ler_id = p_per_in_ler_id
1380: and pil.ler_id = ler.ler_id
1381: and ler.business_group_id = p_business_group_id
1382: and p_effective_date between ler.effective_start_date
1588: cursor c_prev_per_in_ler is
1589: select pil.per_in_ler_id
1590: from ben_per_in_ler pil,
1591: ben_per_in_ler pil1,
1592: ben_ler_f ler
1593: where pil1.per_in_ler_id = p_per_in_ler_id
1594: and pil1.person_id = pil.person_id
1595: and pil1.per_in_ler_id <> pil.per_in_ler_id
1596: and pil.ler_id = ler.ler_id
4938:
4939: -- Bug 14803995
4940: cursor c_unrest(c_per_in_ler_id number) is
4941: select ler.typ_cd from
4942: ben_per_in_ler pil,ben_ler_f ler
4943: where pil.ler_id=ler.ler_id
4944: and p_effective_date between ler.effective_start_date
4945: and ler.effective_end_date
4946: and pil.per_in_ler_id=c_per_in_ler_id;
5145:
5146: ------Bug 7374973
5147: cursor c_unrestricted(p_ler_id number) is
5148: select ler.typ_cd
5149: from ben_ler_f ler
5150: where ler_id = p_ler_id
5151: and ler.business_group_id = p_business_group_id;
5152: l_unrestricted c_unrestricted%rowtype;
5153:
5158: cursor c_prev_per_in_ler is
5159: select pil.per_in_ler_id
5160: from ben_per_in_ler pil,
5161: ben_per_in_ler pil1,
5162: ben_ler_f ler,
5163: ben_elig_per_elctbl_chc epe
5164: where pil1.per_in_ler_id = epe.per_in_ler_id
5165: and epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
5166: and pil1.person_id = pil.person_id