APPS.BEN_DETERMINE_COMMUNICATIONS dependencies on BEN_ELIG_PER_F

Line 3906: from ben_elig_per_f elig,

3902: --
3903: cursor c_elig(v_person_id number) is
3904: select elig.pgm_id,
3905: elig.pl_id
3906: from ben_elig_per_f elig,
3907: ben_per_in_ler pil
3908: where elig.person_id = v_person_id
3909: and (g_parm.pgm_id is null or
3910: elig.pgm_id = g_parm.pgm_id)

Line 4177: from ben_elig_per_f elig,

4173: and ((g_parm.elig_enrol_cd = 'ELIG' -- begin ELIG block
4174: and
4175: -- check if the person is eligible for the comp object
4176: exists (select 's'
4177: from ben_elig_per_f elig,
4178: ben_per_in_ler pil
4179: where elig.person_id = ppf.person_id
4180: and elig.pgm_id = g_parm.pgm_id
4181: and (g_parm.pl_nip_id is null and g_parm.plan_in_pgm_flag = 'Y' and elig.pgm_id is not null)

Line 4259: from ben_elig_per_f elig,

4255: and ((g_parm.elig_enrol_cd = 'ELIG' -- begin ELIG block
4256: and
4257: -- check if the person is eligible for the comp object
4258: exists (select 's'
4259: from ben_elig_per_f elig,
4260: ben_per_in_ler pil
4261: where elig.person_id = ppf.person_id
4262: and g_parm.pgm_id is null
4263: and (g_parm.pl_nip_id is not null and g_parm.plan_in_pgm_flag = 'N' and elig.pgm_id is null)