DBA Data[Home] [Help]

APPS.BEN_MAINTAIN_DESIGNEE_ELIG dependencies on BEN_PL_F

Line 145: pl_id ben_pl_f.pl_id%type,

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,
149: contact_type hr_lookups.lookup_code%type,

Line 1286: ben_pl_f pln,

1282: cursor c_ptip_elig(v_person_id in number,
1283: v_ptip_id in number) is
1284: select pep.elig_per_id
1285: from ben_elig_per_f pep,
1286: ben_pl_f pln,
1287: ben_ptip_f ptip,
1288: ben_per_in_ler pil
1289: where pep.person_id = v_person_id
1290: and pep.pl_id = pln.pl_id