DBA Data[Home] [Help]

APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_PGM_DPNT_CVG_CTFN_F

Line 425: from ben_pgm_dpnt_cvg_ctfn_f

421:
422: --
423: cursor c_ctfns_pgm is
424: select 'x'
425: from ben_pgm_dpnt_cvg_ctfn_f
426: where pgm_id = p_pgm_id
427: and business_group_id = p_business_group_id
428: and p_effective_date between effective_start_date
429: and effective_end_date

Line 3340: from ben_pgm_dpnt_cvg_ctfn_f pgm

3336: pgm.ctfn_rqd_when_rl ctrrl,
3337: pgm.rqd_flag,
3338: pgm.rlshp_typ_cd ctrlshcd,
3339: pgm.pgm_id
3340: from ben_pgm_dpnt_cvg_ctfn_f pgm
3341: where pgm.pgm_id = v_pgm_id
3342: and pgm.business_group_id = p_business_group_id
3343: and p_effective_date between pgm.effective_start_date
3344: and pgm.effective_end_date