DBA Data[Home] [Help]

APPS.BEN_DETERMINE_CHC_CTFN dependencies on BEN_OIPL_F

Line 564: ben_oipl_f oipl

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

Line 609: ben_oipl_f cop

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