169: between pen.effective_start_date and pen.effective_end_date
170: and pen.effective_end_date = hr_api.g_eot
171: and -- start 4354929
172: ( EXISTS ( select null
173: from ben_ler_f ler,
174: ben_elig_per_elctbl_chc epe
175: where ler.ler_id = pen.ler_id
176: and (( ler.typ_cd = 'SCHEDDU'
177: and pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id
362: --
363: cursor c_unrestricted is
364: select 'Y'
365: from ben_per_in_ler pil,
366: ben_ler_f ler
367: where pil.per_in_ler_id = p_per_in_ler_id
368: and pil.ler_id = ler.ler_id
369: and ler.typ_cd = 'SCHEDDU'
370: and ler.business_group_id = p_business_group_id
919: between pen.effective_start_date and pen.effective_end_date
920: and pen.effective_end_date = hr_api.g_eot
921: and -- start 4354929
922: ( EXISTS ( select null
923: from ben_ler_f ler,
924: ben_elig_per_elctbl_chc epe
925: where ler.ler_id = pen.ler_id
926: and (
927: ( ler.typ_cd = 'SCHEDDU'
1020: --
1021: cursor c_unrestricted is
1022: select 'Y'
1023: from ben_per_in_ler pil,
1024: ben_ler_f ler
1025: where pil.per_in_ler_id = p_per_in_ler_id
1026: and pil.ler_id = ler.ler_id
1027: and ler.typ_cd = 'SCHEDDU'
1028: and ler.business_group_id = p_business_group_id
1309: --
1310: cursor c_unrestricted is
1311: select 'Y'
1312: from ben_per_in_ler pil,
1313: ben_ler_f ler
1314: where pil.per_in_ler_id = p_per_in_ler_id
1315: and pil.ler_id = ler.ler_id
1316: and ler.typ_cd = 'SCHEDDU'
1317: and ler.business_group_id = p_business_group_id