DBA Data[Home] [Help]

APPS.BEN_GENERATE_COMMUNICATIONS dependencies on BEN_ELIG_DPNT

Line 1320: ben_elig_dpnt egd

1316: cv_effective_date date) is
1317: select 'x'
1318: FROM ben_elig_per_f pep,
1319: ben_per_in_ler pil,
1320: ben_elig_dpnt egd
1321: WHERE egd.dpnt_person_id = p_person_id
1322: and egd.business_group_id = p_business_group_id
1323: and egd.elig_per_id = pep.elig_per_id
1324: and (c_pl_id is null or nvl(c_pl_id,-1) = nvl(pep.pl_id,-1) )