APPS.BEN_MAINTAIN_DESIGNEE_ELIG dependencies on BEN_PER_IN_LER

Line 645: ben_per_in_ler pil

641: cursor c_person is
642: Select distinct ecd.dpnt_person_id, pil.person_id
643: From ben_prtt_enrt_rslt_f pen,
644: ben_elig_cvrd_dpnt_f ecd,
645: ben_per_in_ler pil
646: Where pen.business_group_id = p_business_group_id
647: and pen.prtt_enrt_rslt_stat_cd is null
648: and ( p_pgm_id is null or pen.pgm_id=p_pgm_id)
649: and ( p_pl_id is null or pen.pl_id = p_pl_id)--3808703

Line 1238: ben_per_in_ler pil,

1234: -- CWB Changes.
1235: ecd.per_in_ler_id
1236: From ben_prtt_enrt_rslt_f pen,
1237: ben_elig_cvrd_dpnt_f ecd,
1238: ben_per_in_ler pil,
1239: per_contact_relationships ctr
1240: Where pen.business_group_id = p_business_group_id
1241: and pen.prtt_enrt_rslt_stat_cd is null
1242: and ecd.dpnt_person_id = p_person_id

Line 1298: ben_per_in_ler pil

1294: select pep.elig_per_id
1295: from ben_elig_per_f pep,
1296: ben_pl_f pln,
1297: ben_ptip_f ptip,
1298: ben_per_in_ler pil
1299: where pep.person_id = v_person_id
1300: and pep.pl_id = pln.pl_id
1301: and pln.pl_typ_id = ptip.pl_typ_id
1302: and ptip.ptip_id = v_ptip_id

Line 1318: ben_per_in_ler pil

1314: cursor c_pgm_elig(v_person_id in number,
1315: v_pgm_id in number) is
1316: select pep.elig_per_id
1317: from ben_elig_per_f pep,
1318: ben_per_in_ler pil
1319: where pep.person_id = v_person_id
1320: and pep.pgm_id = v_pgm_id
1321: and pep.pl_id is not null
1322: and p_effective_date between

Line 1333: ben_per_in_ler pil

1329: v_pl_id in number,
1330: v_pgm_id in number) is
1331: select pep.elig_per_id
1332: from ben_elig_per_f pep,
1333: ben_per_in_ler pil
1334: where pep.person_id = v_person_id
1335: and pep.pl_id = v_pl_id
1336: and ((v_pgm_id is null and pep.pgm_id is null) OR
1337: (pep.pgm_id = v_pgm_id))

Line 1347: ben_per_in_ler pil

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 (+)
1351: and (pil.per_in_ler_stat_cd is null OR

Line 1358: ben_per_in_ler pil

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'
1362: and egd.create_dt = v_create_dt