APPS.BEN_MAINTAIN_DESIGNEE_ELIG dependencies on BEN_PER_IN_LER

Line 640: ben_per_in_ler pil

636: cursor c_person is
637: Select distinct ecd.dpnt_person_id, pil.person_id
638: From ben_prtt_enrt_rslt_f pen,
639: ben_elig_cvrd_dpnt_f ecd,
640: ben_per_in_ler pil
641: Where pen.business_group_id = p_business_group_id
642: and pen.prtt_enrt_rslt_stat_cd is null
643: and ( p_pgm_id is null or pen.pgm_id=p_pgm_id)
644: and ( p_pl_id is null or pen.pl_id = p_pl_id)--3808703

Line 1233: ben_per_in_ler pil,

1229: -- CWB Changes.
1230: ecd.per_in_ler_id
1231: From ben_prtt_enrt_rslt_f pen,
1232: ben_elig_cvrd_dpnt_f ecd,
1233: ben_per_in_ler pil,
1234: per_contact_relationships ctr
1235: Where pen.business_group_id = p_business_group_id
1236: and pen.prtt_enrt_rslt_stat_cd is null
1237: and ecd.dpnt_person_id = p_person_id

Line 1288: ben_per_in_ler pil

1284: select pep.elig_per_id
1285: from ben_elig_per_f pep,
1286: ben_pl_f pln,
1287: ben_ptip_f ptip,
1288: ben_per_in_ler pil
1289: where pep.person_id = v_person_id
1290: and pep.pl_id = pln.pl_id
1291: and pln.pl_typ_id = ptip.pl_typ_id
1292: and ptip.ptip_id = v_ptip_id

Line 1308: ben_per_in_ler pil

1304: cursor c_pgm_elig(v_person_id in number,
1305: v_pgm_id in number) is
1306: select pep.elig_per_id
1307: from ben_elig_per_f pep,
1308: ben_per_in_ler pil
1309: where pep.person_id = v_person_id
1310: and pep.pgm_id = v_pgm_id
1311: and pep.pl_id is not null
1312: and p_effective_date between

Line 1323: ben_per_in_ler pil

1319: v_pl_id in number,
1320: v_pgm_id in number) is
1321: select pep.elig_per_id
1322: from ben_elig_per_f pep,
1323: ben_per_in_ler pil
1324: where pep.person_id = v_person_id
1325: and pep.pl_id = v_pl_id
1326: and ((v_pgm_id is null and pep.pgm_id is null) OR
1327: (pep.pgm_id = v_pgm_id))

Line 1337: ben_per_in_ler pil

1333: --
1334: cursor c_max_create_dt(v_elig_per_id in number) is
1335: select max(egd.create_dt)
1336: from ben_elig_dpnt egd,
1337: ben_per_in_ler pil
1338: where egd.elig_per_id = v_elig_per_id
1339: and egd.dpnt_person_id = p_person_id
1340: and egd.per_in_ler_id = pil.per_in_ler_id (+)
1341: and (pil.per_in_ler_stat_cd is null OR

Line 1348: ben_per_in_ler pil

1344: cursor c_egd(v_elig_per_id in number,
1345: v_create_dt in date) is
1346: select egd.*
1347: from ben_elig_dpnt egd,
1348: ben_per_in_ler pil
1349: where egd.elig_per_id = v_elig_per_id
1350: and egd.dpnt_person_id = p_person_id
1351: and egd.dpnt_inelig_flag = 'N'
1352: and egd.create_dt = v_create_dt