APPS.BEN_PRTT_ENRT_RESULT_API dependencies on BEN_OIPL_F

Line 6054: ,ben_oipl_f oipl

6050: from ben_prtt_enrt_rslt_f pen
6051: ,ben_elig_per_elctbl_chc epe
6052: ,ben_per_in_ler pil
6053: ,ben_enrt_bnft enb
6054: ,ben_oipl_f oipl
6055: ,ben_pl_f pl
6056: ,ben_opt_f opt
6057: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6058: and pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id (+)

Line 9997: ben_oipl_f oipl,

9993: ,oipl.opt_id
9994: ,r.ptip_id
9995: ,r.enrt_mthd_cd --Bug 2200139
9996: From ben_prtt_enrt_rslt_f r,
9997: ben_oipl_f oipl,
9998: ben_elig_per_elctbl_chc c
9999: Where c.per_in_ler_id = p_per_in_ler_id
10000: and r.prtt_enrt_rslt_id = c.prtt_enrt_rslt_id
10001: and r.per_in_ler_id <> c.per_in_ler_id

Line 10039: ben_oipl_f oipl

10035: ,oipl.opt_id
10036: ,r.ptip_id
10037: ,r.enrt_mthd_cd
10038: From ben_prtt_enrt_rslt_f r,
10039: ben_oipl_f oipl
10040: Where r.per_in_ler_id <> p_per_in_ler_id
10041: and r.person_id = p_person_id
10042: and nvl(r.pgm_id,-1) = p_pgm_id
10043: and r.effective_end_date = hr_api.g_eot

Line 10100: ,ben_oipl_f oipl

10096: ,r.ptip_id
10097: ,r.enrt_mthd_cd
10098: From ben_prtt_enrt_rslt_f r
10099: ,ben_elig_per_elctbl_chc c
10100: ,ben_oipl_f oipl
10101: ,ben_pil_elctbl_chc_popl pel
10102: Where c.per_in_ler_id = p_per_in_ler_id
10103: and r.prtt_enrt_rslt_id = c.prtt_enrt_rslt_id
10104: and r.per_in_ler_id <> c.per_in_ler_id