DBA Data[Home] [Help]

APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_PGM_DPNT_CVG_CTFN_F

Line 438: from ben_pgm_dpnt_cvg_ctfn_f

434:
435: --
436: cursor c_ctfns_pgm is
437: select 'x'
438: from ben_pgm_dpnt_cvg_ctfn_f
439: where pgm_id = p_pgm_id
440: and business_group_id = p_business_group_id
441: and p_effective_date between effective_start_date
442: and effective_end_date

Line 3353: from ben_pgm_dpnt_cvg_ctfn_f pgm

3349: pgm.ctfn_rqd_when_rl ctrrl,
3350: pgm.rqd_flag,
3351: pgm.rlshp_typ_cd ctrlshcd,
3352: pgm.pgm_id
3353: from ben_pgm_dpnt_cvg_ctfn_f pgm
3354: where pgm.pgm_id = v_pgm_id
3355: and pgm.business_group_id = p_business_group_id
3356: and p_effective_date between pgm.effective_start_date
3357: and pgm.effective_end_date