APPS.BEN_MAINTAIN_DESIGNEE_ELIG dependencies on BEN_PGM_F

Line 149: pgm_id ben_pgm_f.pgm_id%type,

145: g_max_errors_allowed number(9) := 200;
146: type g_report_rec is record
147: (
148: person_id /*per_people_f */per_all_people_f.person_id%type,
149: pgm_id ben_pgm_f.pgm_id%type,
150: pl_id ben_pl_f.pl_id%type,
151: oipl_id ben_oipl_f.oipl_id%type,
152: dpnt_cvg_strt_dt date,
153: dpnt_cvg_thru_dt date,

Line 1286: from ben_pgm_f pgm

1282: l_opt c_opt%rowtype;
1283: --
1284: cursor c_dpnt_dsgn_lvl(v_pgm_id in number) is
1285: select pgm.dpnt_dsgn_lvl_cd
1286: from ben_pgm_f pgm
1287: where pgm.pgm_id = v_pgm_id
1288: and pgm.business_group_id = p_business_group_id
1289: and p_effective_date between
1290: pgm.effective_start_date and pgm.effective_end_date;