DBA Data[Home] [Help]

APPS.BEN_EXT_ELIG dependencies on BEN_PER_IN_LER

Line 946: from ben_per_in_ler pler,

942: opt.opt_attribute8 opt_flex_08,
943: opt.opt_attribute9 opt_flex_09,
944: opt.opt_attribute10 opt_flex_10,
945: pl.cobra_pymt_due_dy_num
946: from ben_per_in_ler pler,
947: ben_elig_per_elctbl_chc echc,
948: ben_pil_elctbl_chc_popl ppopl,
949: ben_enrt_bnft enb,
950: ben_opt_f opt,

Line 1101: from ben_per_in_ler pler,

1097: enb.bnft_typ_cd bnft_typ_cd,
1098: enb.entr_val_at_enrt_flag entr_val_at_enrt_flag,
1099: enb.cvg_mlt_cd cvg_mlt_cd,
1100: enb.ordr_num ordr_num
1101: from ben_per_in_ler pler,
1102: ben_elig_per_elctbl_chc echc,
1103: ben_pil_elctbl_chc_popl ppopl,
1104: ben_enrt_bnft enb
1105: where pler.person_id = p_person_id

Line 1335: from ben_per_in_ler pler

1331: ,ler.name
1332: ,pler.per_in_ler_stat_cd
1333: ,pler.ntfn_dt
1334: ,pler.lf_evt_ocrd_dt
1335: from ben_per_in_ler pler
1336: ,ben_ler_f ler
1337: where pler.person_id = p_person_id
1338: and pler.per_in_ler_id = cp_per_in_ler_id
1339: and pler.ler_id = ler.ler_id