APPS.BEN_DETERMINE_DPNT_ELIG_SS dependencies on BEN_PGM_F

Line 189: from ben_pgm_f pgm

185: pgm.dpnt_cvg_strt_dt_cd,
186: pgm.dpnt_cvg_strt_dt_rl,
187: pgm.dpnt_cvg_end_dt_cd,
188: pgm.dpnt_cvg_end_dt_rl
189: from ben_pgm_f pgm
190: where pgm.pgm_id = p_pgm_id
191: and pgm.business_group_id = l_business_group_id
192: and nvl(l_per_in_ler.lf_evt_ocrd_dt,p_effective_date)
193: between nvl(pgm.effective_start_date,p_effective_date)

Line 197: l_level ben_pgm_f.dpnt_dsgn_lvl_cd%type;

193: between nvl(pgm.effective_start_date,p_effective_date)
194: and nvl(pgm.effective_end_date,p_effective_date);
195: --
196: l_pgm c_pgm%rowtype;
197: l_level ben_pgm_f.dpnt_dsgn_lvl_cd%type;
198:
199: cursor c_ptip(l_ptip_id number) is
200: select ptip.dpnt_dsgn_cd,
201: ptip.dpnt_cvg_strt_dt_cd,

Line 668: from ben_pgm_f pgm

664: cursor c_pgm is
665: select pgm.pgm_id,
666: pgm.vrfy_fmly_mmbr_cd,
667: pgm.vrfy_fmly_mmbr_rl
668: from ben_pgm_f pgm
669: where pgm.business_group_id = p_business_group_id
670: and pgm.pgm_stat_cd = 'A'
671: and p_effective_date
672: between pgm.effective_start_date and pgm.effective_end_date;

Line 772: l_vrfy_fmly_mmbr_cd ben_pgm_f.vrfy_fmly_mmbr_cd%TYPE;

768: and p_effective_date
769: between etpr.effective_start_date and etpr.effective_end_date;
770: --
771: l_elig_to_prte_rsn_id ben_elig_to_prte_rsn_f.elig_to_prte_rsn_id%TYPE;
772: l_vrfy_fmly_mmbr_cd ben_pgm_f.vrfy_fmly_mmbr_cd%TYPE;
773: l_vrfy_fmly_mmbr_rl ben_pgm_f.vrfy_fmly_mmbr_rl%TYPE;
774: l_per_cvrd_cd ben_pl_f.per_cvrd_cd%TYPE;
775: l_found boolean := false;
776: --

Line 773: l_vrfy_fmly_mmbr_rl ben_pgm_f.vrfy_fmly_mmbr_rl%TYPE;

769: between etpr.effective_start_date and etpr.effective_end_date;
770: --
771: l_elig_to_prte_rsn_id ben_elig_to_prte_rsn_f.elig_to_prte_rsn_id%TYPE;
772: l_vrfy_fmly_mmbr_cd ben_pgm_f.vrfy_fmly_mmbr_cd%TYPE;
773: l_vrfy_fmly_mmbr_rl ben_pgm_f.vrfy_fmly_mmbr_rl%TYPE;
774: l_per_cvrd_cd ben_pl_f.per_cvrd_cd%TYPE;
775: l_found boolean := false;
776: --
777: begin