APPS.BEN_MAINTAIN_DESIGNEE_ELIG dependencies on BEN_ELIG_PER_F

Line 1295: from ben_elig_per_f pep,

1291: --
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

Line 1317: from ben_elig_per_f pep,

1313: --
1314: cursor c_pgm_elig(v_person_id in number,
1315: v_pgm_id in number) is
1316: select pep.elig_per_id
1317: from ben_elig_per_f pep,
1318: ben_per_in_ler pil
1319: where pep.person_id = v_person_id
1320: and pep.pgm_id = v_pgm_id
1321: and pep.pl_id is not null

Line 1332: from ben_elig_per_f pep,

1328: cursor c_pl_elig(v_person_id in number,
1329: v_pl_id in number,
1330: v_pgm_id in number) is
1331: select pep.elig_per_id
1332: from ben_elig_per_f pep,
1333: ben_per_in_ler pil
1334: where pep.person_id = v_person_id
1335: and pep.pl_id = v_pl_id
1336: and ((v_pgm_id is null and pep.pgm_id is null) OR