APPS.BEN_DETERMINE_COMMUNICATIONS dependencies on BEN_ELIG_PER_F

Line 3848: from ben_elig_per_f elig,

3844: --
3845: cursor c_elig(v_person_id number) is
3846: select elig.pgm_id,
3847: elig.pl_id
3848: from ben_elig_per_f elig,
3849: ben_per_in_ler pil
3850: where elig.person_id = v_person_id
3851: and (g_parm.pgm_id is null or
3852: elig.pgm_id = g_parm.pgm_id)

Line 4116: from ben_elig_per_f elig,

4112: and ((g_parm.elig_enrol_cd = 'ELIG' -- begin ELIG block
4113: and
4114: -- check if the person is eligible for the comp object
4115: exists (select 's'
4116: from ben_elig_per_f elig,
4117: ben_per_in_ler pil
4118: where elig.person_id = ppf.person_id
4119: and elig.pgm_id = g_parm.pgm_id
4120: and (g_parm.pl_nip_id is null and g_parm.plan_in_pgm_flag = 'Y' and elig.pgm_id is not null)

Line 4198: from ben_elig_per_f elig,

4194: and ((g_parm.elig_enrol_cd = 'ELIG' -- begin ELIG block
4195: and
4196: -- check if the person is eligible for the comp object
4197: exists (select 's'
4198: from ben_elig_per_f elig,
4199: ben_per_in_ler pil
4200: where elig.person_id = ppf.person_id
4201: and g_parm.pgm_id is null
4202: and (g_parm.pl_nip_id is not null and g_parm.plan_in_pgm_flag = 'N' and elig.pgm_id is null)