DBA Data[Home] [Help]

APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_ELCTBL_CHC_CTFN

Line 6193: from ben_elctbl_chc_ctfn ecc

6189: select ecc.rqd_flag,
6190: ecc.enrt_ctfn_typ_cd,
6191: ecc.SUSP_IF_CTFN_NOT_PRVD_FLAG,
6192: ecc.ctfn_determine_cd
6193: from ben_elctbl_chc_ctfn ecc
6194: where ecc.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id
6195: -- jcarpent added line below for bug 1488666
6196: and ecc.enrt_bnft_id is null
6197: and ecc.business_group_id = p_business_group_id;

Line 6216: from ben_elctbl_chc_ctfn ecc

6212: select ecc.rqd_flag,
6213: ecc.enrt_ctfn_typ_cd,
6214: ecc.SUSP_IF_CTFN_NOT_PRVD_FLAG,
6215: ecc.ctfn_determine_cd
6216: from ben_elctbl_chc_ctfn ecc
6217: where ecc.enrt_bnft_id = v_enrt_bnft_id
6218: and ecc.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id
6219: and ecc.business_group_id = p_business_group_id;
6220: --