APPS.BEN_DETERMINE_DPNT_ELIGIBILITY dependencies on BEN_ELIG_CVRD_DPNT_F

Line 522: ben_elig_cvrd_dpnt_f pdp,

518: 'N' contact_active_flag,
519: per.date_of_death /* Bug 7481099 */
520: from per_contact_relationships ctr,
521: per_all_people_f per,
522: ben_elig_cvrd_dpnt_f pdp,
523: ben_per_in_ler pil
524: where per.person_id = ctr.contact_person_id
525: -- and l_lf_evt_ocrd_dt <= nvl(per.DATE_OF_DEATH, l_lf_evt_ocrd_dt) /* Bug 4287999 */
526: and l_lf_evt_ocrd_dt between per.effective_start_date and per.effective_end_date

Line 615: from ben_elig_cvrd_dpnt_f pdp,

611: pdp.elig_cvrd_dpnt_id,
612: pdp.effective_start_date,
613: pdp.cvg_strt_dt,
614: pdp.effective_end_date
615: from ben_elig_cvrd_dpnt_f pdp,
616: ben_per_in_ler pil
617: where pdp.prtt_enrt_rslt_id = l_prtt_enrt_rslt_id
618: and pdp.business_group_id = p_business_group_id
619: and pdp.dpnt_person_id = l_contact.contact_person_id

Line 1516: p_base_table_name => 'BEN_ELIG_CVRD_DPNT_F',

1512: -- Check datetrack mode.
1513: --
1514: dt_api.find_dt_upd_modes
1515: (p_effective_date => l_effective_date,
1516: p_base_table_name => 'BEN_ELIG_CVRD_DPNT_F',
1517: p_base_key_column => 'elig_cvrd_dpnt_id',
1518: p_base_key_value => l_elig_cvrd_dpnt_id,
1519: p_correction => l_correction,
1520: p_update => l_update,