DBA Data[Home] [Help]

APPS.BEN_EXT_CHLG dependencies on BEN_ELIG_CVRD_DPNT_F

Line 4950: from ben_elig_cvrd_dpnt_f ecd

4946:
4947: cursor c_elig_cvrd_person_id
4948: is
4949: select ecd.dpnt_person_id
4950: from ben_elig_cvrd_dpnt_f ecd
4951: where ecd.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
4952: and ecd.business_group_id = p_business_group_id
4953: and p_effective_date between ecd.effective_start_date and ecd.effective_end_date;
4954: