DBA Data[Home] [Help]

APPS.BEN_DETERMINE_CHC_CTFN dependencies on BEN_OIPL_F

Line 566: ben_oipl_f oipl

562: pil.person_id,
563: pil.ler_id
564: from ben_elig_per_elctbl_chc epe,
565: ben_per_in_ler pil,
566: ben_oipl_f oipl
567: where pil.per_in_ler_id = epe.per_in_ler_id
568: and epe.crntly_enrd_flag = 'N'
569: and epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
570: and epe.oipl_id = oipl.oipl_id(+)

Line 611: ben_oipl_f cop

607: ecf.ctfn_rqd_when_rl,
608: cop.susp_if_ctfn_not_prvd_flag,
609: cop.ctfn_determine_cd
610: from ben_enrt_ctfn_f ecf,
611: ben_oipl_f cop
612: where ecf.oipl_id = l_oipl_id
613: and cop.oipl_id = ecf.oipl_id
614: and ecf.business_group_id = l_business_group_id
615: and p_effective_date