DBA Data[Home] [Help]

APPS.BEN_EFC_FUNCTIONS dependencies on PER_ALL_PEOPLE_F

Line 328: per_all_people_f per

324: pil.ler_id,
325: pil.per_in_ler_stat_cd
326: from BEN_ELIG_PER_ELCTBL_CHC epe,
327: ben_per_in_ler pil,
328: per_all_people_f per
329: where pil.per_in_ler_id = epe.per_in_ler_id
330: and epe.ELIG_PER_ELCTBL_CHC_id = c_epe_id
331: and per.person_id = pil.person_id
332: and pil.lf_evt_ocrd_dt

Line 351: per_all_people_f per

347: enb.val
348: from ben_enrt_bnft enb,
349: BEN_ELIG_PER_ELCTBL_CHC epe,
350: ben_per_in_ler pil,
351: per_all_people_f per
352: where enb.ELIG_PER_ELCTBL_CHC_id = epe.ELIG_PER_ELCTBL_CHC_id
353: and pil.per_in_ler_id = epe.per_in_ler_id
354: and enb.enrt_bnft_id = c_enb_id
355: and per.person_id = pil.person_id