APPS.BEN_DETERMINE_DPNT_ELIGIBILITY dependencies on BEN_ELIG_CVRD_DPNT_F

Line 518: ben_elig_cvrd_dpnt_f pdp,

514: ctr.date_end, -- 4697057 Added this
515: 'N' contact_active_flag
516: from per_contact_relationships ctr,
517: per_all_people_f per,
518: ben_elig_cvrd_dpnt_f pdp,
519: ben_per_in_ler pil
520: where per.person_id = ctr.contact_person_id
521: and l_lf_evt_ocrd_dt <= nvl(per.DATE_OF_DEATH, l_lf_evt_ocrd_dt) /* Bug 4287999 */
522: and l_lf_evt_ocrd_dt between per.effective_start_date and per.effective_end_date

Line 611: from ben_elig_cvrd_dpnt_f pdp,

607: pdp.elig_cvrd_dpnt_id,
608: pdp.effective_start_date,
609: pdp.cvg_strt_dt,
610: pdp.effective_end_date
611: from ben_elig_cvrd_dpnt_f pdp,
612: ben_per_in_ler pil
613: where pdp.prtt_enrt_rslt_id = l_prtt_enrt_rslt_id
614: and pdp.business_group_id = p_business_group_id
615: and pdp.dpnt_person_id = l_contact.contact_person_id

Line 1500: p_base_table_name => 'BEN_ELIG_CVRD_DPNT_F',

1496: -- Check datetrack mode.
1497: --
1498: dt_api.find_dt_upd_modes
1499: (p_effective_date => l_effective_date,
1500: p_base_table_name => 'BEN_ELIG_CVRD_DPNT_F',
1501: p_base_key_column => 'elig_cvrd_dpnt_id',
1502: p_base_key_value => l_elig_cvrd_dpnt_id,
1503: p_correction => l_correction,
1504: p_update => l_update,