APPS.BEN_MAINTAIN_DESIGNEE_ELIG dependencies on BEN_ELIG_PER_F

Line 1285: from ben_elig_per_f pep,

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

Line 1307: from ben_elig_per_f pep,

1303: --
1304: cursor c_pgm_elig(v_person_id in number,
1305: v_pgm_id in number) is
1306: select pep.elig_per_id
1307: from ben_elig_per_f pep,
1308: ben_per_in_ler pil
1309: where pep.person_id = v_person_id
1310: and pep.pgm_id = v_pgm_id
1311: and pep.pl_id is not null

Line 1322: from ben_elig_per_f pep,

1318: cursor c_pl_elig(v_person_id in number,
1319: v_pl_id in number,
1320: v_pgm_id in number) is
1321: select pep.elig_per_id
1322: from ben_elig_per_f pep,
1323: ben_per_in_ler pil
1324: where pep.person_id = v_person_id
1325: and pep.pl_id = v_pl_id
1326: and ((v_pgm_id is null and pep.pgm_id is null) OR