DBA Data[Home] [Help]

APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_ELCTBL_CHC_CTFN

Line 6115: from ben_elctbl_chc_ctfn ecc

6111: select ecc.rqd_flag,
6112: ecc.enrt_ctfn_typ_cd,
6113: ecc.SUSP_IF_CTFN_NOT_PRVD_FLAG,
6114: ecc.ctfn_determine_cd
6115: from ben_elctbl_chc_ctfn ecc
6116: where ecc.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id
6117: -- jcarpent added line below for bug 1488666
6118: and ecc.enrt_bnft_id is null
6119: and ecc.business_group_id = p_business_group_id;

Line 6138: from ben_elctbl_chc_ctfn ecc

6134: select ecc.rqd_flag,
6135: ecc.enrt_ctfn_typ_cd,
6136: ecc.SUSP_IF_CTFN_NOT_PRVD_FLAG,
6137: ecc.ctfn_determine_cd
6138: from ben_elctbl_chc_ctfn ecc
6139: where ecc.enrt_bnft_id = v_enrt_bnft_id
6140: and ecc.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id
6141: and ecc.business_group_id = p_business_group_id;
6142: --