APPS.BEN_MAINTAIN_DESIGNEE_ELIG dependencies on BEN_PGM_F

Line 144: pgm_id ben_pgm_f.pgm_id%type,

140: g_max_errors_allowed number(9) := 200;
141: type g_report_rec is record
142: (
143: person_id /*per_people_f */per_all_people_f.person_id%type,
144: pgm_id ben_pgm_f.pgm_id%type,
145: pl_id ben_pl_f.pl_id%type,
146: oipl_id ben_oipl_f.oipl_id%type,
147: dpnt_cvg_strt_dt date,
148: dpnt_cvg_thru_dt date,

Line 1276: from ben_pgm_f pgm

1272: l_opt c_opt%rowtype;
1273: --
1274: cursor c_dpnt_dsgn_lvl(v_pgm_id in number) is
1275: select pgm.dpnt_dsgn_lvl_cd
1276: from ben_pgm_f pgm
1277: where pgm.pgm_id = v_pgm_id
1278: and pgm.business_group_id = p_business_group_id
1279: and p_effective_date between
1280: pgm.effective_start_date and pgm.effective_end_date;