APPS.BEN_DETERMINE_DPNT_ELIG_SS dependencies on BEN_PGM_F

Line 186: from ben_pgm_f pgm

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

Line 194: l_level ben_pgm_f.dpnt_dsgn_lvl_cd%type;

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

Line 665: from ben_pgm_f pgm

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

Line 769: l_vrfy_fmly_mmbr_cd ben_pgm_f.vrfy_fmly_mmbr_cd%TYPE;

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

Line 770: l_vrfy_fmly_mmbr_rl ben_pgm_f.vrfy_fmly_mmbr_rl%TYPE;

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