APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_LER_CHG_DPNT_CVG_CTFN_F

Line 378: -- ben_ler_chg_dpnt_cvg_ctfn_f table.

374: return boolean is
375: --
376: -- This function checks whether certifications have defined for a certain
377: -- contact type and sets the out parameter if the ctfn has been found at the
378: -- ben_ler_chg_dpnt_cvg_ctfn_f table.
379: -- Here the assumption is that if a certification is defined
380: -- without a contact type, then it is for all contact types. The function
381: -- returns TRUE if either a certification is found for the person's contact
382: -- type or a certification with a contact type of null is found.

Line 394: from ben_ler_chg_dpnt_cvg_ctfn_f lcc,

390: -- value only when P_CTFN_AT_LER_CHG is also true.
391: --
392: cursor c_ctfns_ler_chg is
393: select ldc.susp_if_ctfn_not_prvd_flag
394: from ben_ler_chg_dpnt_cvg_ctfn_f lcc,
395: ben_ler_chg_dpnt_cvg_f ldc,
396: ben_prtt_enrt_rslt_f pen
397: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
398: and pen.business_group_id = p_business_group_id

Line 3280: from ben_ler_chg_dpnt_cvg_ctfn_f lcc,

3276: lcc.rqd_flag,
3277: lcc.rlshp_typ_cd,
3278: ldc.susp_if_ctfn_not_prvd_flag,
3279: ldc.ctfn_determine_cd
3280: from ben_ler_chg_dpnt_cvg_ctfn_f lcc,
3281: ben_ler_chg_dpnt_cvg_f ldc,
3282: ben_prtt_enrt_rslt_f pen
3283: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3284: and pen.business_group_id = p_business_group_id