eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_LER_CHG_DPNT_CVG_F

Line 386: -- Dependent Change Of Life Event (BEN_LER_CHG_DPNT_CVG_F). Whenever certifications

382: -- type or a certification with a contact type of null is found.
383: --
384: -- Bug# 3851427 : Defined out parameter P_SUSP_IF_CTFN_NOT_PRVD_FLAG. This
385: -- parameter holds the value of "Suspend Enrollment" flag defined for
386: -- Dependent Change Of Life Event (BEN_LER_CHG_DPNT_CVG_F). Whenever certifications
387: -- are considered at "Dependent Change Of Life Event" level and NOT at PLN, PTIP or PGM
388: -- level, suspension should also be considered based on "Suspension Enrollment" flag value
389: -- at the "Dependent Change Of Life Event" level. Hence this flag will return valid
390: -- value only when P_CTFN_AT_LER_CHG is also true.

Line 395: ben_ler_chg_dpnt_cvg_f ldc,

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
399: and p_effective_date between pen.effective_start_date

Line 2336: from BEN_LER_CHG_DPNT_CVG_f ldc,

2332: -- Cursor to retrieve Suspend Enrollment Flag at the various levels
2333: --
2334: cursor c_ldc (p_lvl_cd varchar) is
2335: select ldc.susp_if_ctfn_not_prvd_flag
2336: from BEN_LER_CHG_DPNT_CVG_f ldc,
2337: ben_prtt_enrt_rslt_f pen
2338: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2339: and pen.business_group_id = p_business_group_id
2340: and p_effective_date between pen.effective_start_date

Line 3281: ben_ler_chg_dpnt_cvg_f ldc,

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
3285: and p_effective_date between pen.effective_start_date