DBA Data[Home] [Help]

APPS.BEN_EFC_FUNCTIONS dependencies on BEN_PER_IN_LER

Line 327: ben_per_in_ler pil,

323: pil.business_group_id,
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

Line 350: ben_per_in_ler pil,

346: pil.per_in_ler_stat_cd,
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