DBA Data[Home] [Help]

APPS.BEN_MANAGE_LIFE_EVENTS dependencies on BEN_ELIG_CVRD_DPNT_F

Line 10131: from ben_elig_cvrd_dpnt_f pdp

10127: --
10128: cursor c_get_inelig_dpnt_info(p_per_in_ler_id in number) is
10129: -- RCHASE - wwBug1427383 - return correct date for creating dependent benefit assignment
10130: select pdp.dpnt_person_id, min(egd.elig_thru_dt) cvg_thru_dt--min(pdp.cvg_thru_dt) cvg_thru_dt
10131: from ben_elig_cvrd_dpnt_f pdp
10132: ,ben_elig_dpnt egd
10133: ,ben_prtt_enrt_rslt_f pen
10134: where pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
10135: and pen.person_id = p_person_id