DBA Data[Home] [Help]

APPS.BEN_GENERATE_COMMUNICATIONS dependencies on BEN_ELIG_DPNT

Line 1098: ben_elig_dpnt egd

1094: cv_effective_date date) is
1095: select 'x'
1096: FROM ben_elig_per_f pep,
1097: ben_per_in_ler pil,
1098: ben_elig_dpnt egd
1099: WHERE egd.dpnt_person_id = p_person_id
1100: and egd.business_group_id = p_business_group_id
1101: and egd.elig_per_id = pep.elig_per_id
1102: and (c_pl_id is null or nvl(c_pl_id,-1) = nvl(pep.pl_id,-1) )