DBA Data[Home] [Help]

APPS.BEN_PRTT_ENRT_RESULT_API dependencies on BEN_OIPL_F

Line 6343: ,ben_oipl_f oipl

6339: from ben_prtt_enrt_rslt_f pen
6340: ,ben_elig_per_elctbl_chc epe
6341: ,ben_per_in_ler pil
6342: ,ben_enrt_bnft enb
6343: ,ben_oipl_f oipl
6344: ,ben_pl_f pl
6345: ,ben_opt_f opt
6346: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6347: and pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id (+)

Line 11595: ben_oipl_f oipl,

11591: ,oipl.opt_id
11592: ,r.ptip_id
11593: ,r.enrt_mthd_cd --Bug 2200139
11594: From ben_prtt_enrt_rslt_f r,
11595: ben_oipl_f oipl,
11596: ben_elig_per_elctbl_chc c
11597: Where c.per_in_ler_id = p_per_in_ler_id
11598: and r.prtt_enrt_rslt_id = c.prtt_enrt_rslt_id
11599: and r.per_in_ler_id <> c.per_in_ler_id

Line 11637: ben_oipl_f oipl

11633: ,oipl.opt_id
11634: ,r.ptip_id
11635: ,r.enrt_mthd_cd
11636: From ben_prtt_enrt_rslt_f r,
11637: ben_oipl_f oipl
11638: Where r.per_in_ler_id <> p_per_in_ler_id
11639: and r.person_id = p_person_id
11640: and nvl(r.pgm_id,-1) = p_pgm_id
11641: and r.effective_end_date = hr_api.g_eot

Line 11698: ,ben_oipl_f oipl

11694: ,r.ptip_id
11695: ,r.enrt_mthd_cd
11696: From ben_prtt_enrt_rslt_f r
11697: ,ben_elig_per_elctbl_chc c
11698: ,ben_oipl_f oipl
11699: ,ben_pil_elctbl_chc_popl pel
11700: Where c.per_in_ler_id = p_per_in_ler_id
11701: and r.prtt_enrt_rslt_id = c.prtt_enrt_rslt_id
11702: and r.per_in_ler_id <> c.per_in_ler_id