APPS.BEN_DETERMINE_DPNT_ELIGIBILITY dependencies on BEN_PER_IN_LER

Line 372: from ben_per_in_ler pil,

368: select pil.ler_id,
369: pil.person_id,
370: pil.lf_evt_ocrd_dt,
371: pil.per_in_ler_id
372: from ben_per_in_ler pil,
373: ben_ler_f ler
374: where pil.person_id = p_person_id
375: --and pil.business_group_id = p_business_group_id
376: and pil.per_in_ler_stat_cd = 'STRTD'

Line 523: ben_per_in_ler pil

519: per.date_of_death /* Bug 7481099 */
520: from per_contact_relationships ctr,
521: per_all_people_f per,
522: ben_elig_cvrd_dpnt_f pdp,
523: ben_per_in_ler pil
524: where per.person_id = ctr.contact_person_id
525: -- and l_lf_evt_ocrd_dt <= nvl(per.DATE_OF_DEATH, l_lf_evt_ocrd_dt) /* Bug 4287999 */
526: and l_lf_evt_ocrd_dt between per.effective_start_date and per.effective_end_date
527: and ctr.personal_flag = 'Y'

Line 616: ben_per_in_ler pil

612: pdp.effective_start_date,
613: pdp.cvg_strt_dt,
614: pdp.effective_end_date
615: from ben_elig_cvrd_dpnt_f pdp,
616: ben_per_in_ler pil
617: where pdp.prtt_enrt_rslt_id = l_prtt_enrt_rslt_id
618: and pdp.business_group_id = p_business_group_id
619: and pdp.dpnt_person_id = l_contact.contact_person_id
620: -- bug 3784375

Line 1679: from ben_per_in_ler pil

1675: cursor c_per_in_ler is
1676: select pil.ler_id,
1677: pil.person_id,
1678: pil.lf_evt_ocrd_dt
1679: from ben_per_in_ler pil
1680: where pil.per_in_ler_id = l_elctbl_chc.per_in_ler_id
1681: and pil.business_group_id = l_elctbl_chc.business_group_id
1682: and pil.per_in_ler_stat_cd = 'STRTD';
1683: --