APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_LER_CHG_DPNT_CVG_CTFN_F

Line 391: -- ben_ler_chg_dpnt_cvg_ctfn_f table.

387: return boolean is
388: --
389: -- This function checks whether certifications have defined for a certain
390: -- contact type and sets the out parameter if the ctfn has been found at the
391: -- ben_ler_chg_dpnt_cvg_ctfn_f table.
392: -- Here the assumption is that if a certification is defined
393: -- without a contact type, then it is for all contact types. The function
394: -- returns TRUE if either a certification is found for the person's contact
395: -- type or a certification with a contact type of null is found.

Line 407: from ben_ler_chg_dpnt_cvg_ctfn_f lcc,

403: -- value only when P_CTFN_AT_LER_CHG is also true.
404: --
405: cursor c_ctfns_ler_chg is
406: select ldc.susp_if_ctfn_not_prvd_flag
407: from ben_ler_chg_dpnt_cvg_ctfn_f lcc,
408: ben_ler_chg_dpnt_cvg_f ldc,
409: ben_prtt_enrt_rslt_f pen
410: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
411: and pen.business_group_id = p_business_group_id

Line 3293: from ben_ler_chg_dpnt_cvg_ctfn_f lcc,

3289: lcc.rqd_flag,
3290: lcc.rlshp_typ_cd,
3291: ldc.susp_if_ctfn_not_prvd_flag,
3292: ldc.ctfn_determine_cd
3293: from ben_ler_chg_dpnt_cvg_ctfn_f lcc,
3294: ben_ler_chg_dpnt_cvg_f ldc,
3295: ben_prtt_enrt_rslt_f pen
3296: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3297: and pen.business_group_id = p_business_group_id