APPS.BEN_DETERMINE_DPNT_ELIGIBILITY dependencies on BEN_PER_IN_LER

Line 370: from ben_per_in_ler pil,

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

Line 519: ben_per_in_ler pil

515: 'N' contact_active_flag
516: from per_contact_relationships ctr,
517: per_all_people_f per,
518: ben_elig_cvrd_dpnt_f pdp,
519: ben_per_in_ler pil
520: where per.person_id = ctr.contact_person_id
521: and l_lf_evt_ocrd_dt <= nvl(per.DATE_OF_DEATH, l_lf_evt_ocrd_dt) /* Bug 4287999 */
522: and l_lf_evt_ocrd_dt between per.effective_start_date and per.effective_end_date
523: and ctr.personal_flag = 'Y'

Line 612: ben_per_in_ler pil

608: pdp.effective_start_date,
609: pdp.cvg_strt_dt,
610: pdp.effective_end_date
611: from ben_elig_cvrd_dpnt_f pdp,
612: ben_per_in_ler pil
613: where pdp.prtt_enrt_rslt_id = l_prtt_enrt_rslt_id
614: and pdp.business_group_id = p_business_group_id
615: and pdp.dpnt_person_id = l_contact.contact_person_id
616: -- bug 3784375

Line 1663: from ben_per_in_ler pil

1659: cursor c_per_in_ler is
1660: select pil.ler_id,
1661: pil.person_id,
1662: pil.lf_evt_ocrd_dt
1663: from ben_per_in_ler pil
1664: where pil.per_in_ler_id = l_elctbl_chc.per_in_ler_id
1665: and pil.business_group_id = l_elctbl_chc.business_group_id
1666: and pil.per_in_ler_stat_cd = 'STRTD';
1667: --