DBA Data[Home] [Help]

APPS.BEN_MAINTAIN_DESIGNEE_ELIG dependencies on BEN_PL_F

Line 150: pl_id ben_pl_f.pl_id%type,

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

Line 1296: ben_pl_f pln,

1292: cursor c_ptip_elig(v_person_id in number,
1293: v_ptip_id in number) is
1294: select pep.elig_per_id
1295: from ben_elig_per_f pep,
1296: ben_pl_f pln,
1297: ben_ptip_f ptip,
1298: ben_per_in_ler pil
1299: where pep.person_id = v_person_id
1300: and pep.pl_id = pln.pl_id