DBA Data[Home] [Help]

APPS.BEN_WHATIF_ELIG dependencies on BEN_ELIG_CVRD_DPNT_F

Line 3020: select * from ben_elig_cvrd_dpnt_f;

3016: ,p_effective_date in date
3017: ) is
3018: --
3019: cursor c_cvrd_dpnt is
3020: select * from ben_elig_cvrd_dpnt_f;
3021: /* where person_id = p_person_id and
3022: bnfts_bal_id = p_BNFTS_BAL_ID and
3023: business_group_id = p_business_group_id and
3024: p_effective_date between effective_start_date

Line 3032: cvrd_dpnt_rec ben_elig_cvrd_dpnt_f%rowtype;

3028: l_effective_end_date date;
3029: l_object_version_number number;
3030: l_upd_mode varchar2(50);
3031: --
3032: cvrd_dpnt_rec ben_elig_cvrd_dpnt_f%rowtype;
3033: --
3034: begin
3035: --
3036: hr_utility.set_location(' Entering: WATIF_ELIG_CVRD_DPNT_F_API' , 10);