DBA Data[Home] [Help]

APPS.BEN_ELEMENT_ENTRY dependencies on BEN_OIPL_F

Line 105: ben_oipl_f opt

101: pen.effective_start_date,
102: pen.effective_end_date,
103: pen.uom
104: from ben_prtt_enrt_rslt_f pen,
105: ben_oipl_f opt
106: where pen.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
107: and pen.prtt_enrt_rslt_stat_cd is null
108: and opt.oipl_id(+)=pen.oipl_id
109: and pen.enrt_cvg_strt_dt between opt.effective_start_date(+)

Line 1795: ,ben_oipl_f oipl

1791: cursor c_get_epe
1792: is
1793: select epe.elig_per_elctbl_chc_id
1794: from ben_elig_per_elctbl_chc epe
1795: ,ben_oipl_f oipl
1796: ,ben_per_in_ler pil
1797: where epe.per_in_ler_id = pil.per_in_ler_id
1798: and nvl(epe.pgm_id, -1) = nvl(p_pgm_id, -1)
1799: and epe.pl_id = p_pl_id