APPS.BEN_ELIG_DPNT_API dependencies on BEN_ELIG_CVRD_DPNT_F

Line 1455: from ben_elig_cvrd_dpnt_f pdp

1451: pdp.cvg_thru_dt,
1452: pdp.object_version_number,
1453: pdp.effective_end_date, -------Bug 9051021
1454: pdp.effective_start_date
1455: from ben_elig_cvrd_dpnt_f pdp
1456: where pdp.elig_cvrd_dpnt_id = l_egd_rec.elig_cvrd_dpnt_id
1457: and pdp.prtt_enrt_rslt_id = l_egd_rec.prtt_enrt_rslt_id
1458: and pdp.business_group_id = p_business_group_id
1459: and p_effective_date between

Line 2177: ben_elig_cvrd_dpnt_f pdp,

2173: --
2174: cursor c_pdp is
2175: select egd.*
2176: from ben_elig_dpnt egd,
2177: ben_elig_cvrd_dpnt_f pdp,
2178: ben_per_in_ler pil
2179: where pdp.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
2180: and pdp.per_in_ler_id = egd.per_in_ler_id
2181: and pdp.elig_cvrd_dpnt_id = egd.elig_cvrd_dpnt_id

Line 2226: ben_elig_cvrd_dpnt_f pdp,

2222: --
2223: cursor c_pen is
2224: select egd.*
2225: from ben_elig_dpnt egd,
2226: ben_elig_cvrd_dpnt_f pdp,
2227: ben_prtt_enrt_rslt_f pen,
2228: ben_per_in_ler pil
2229: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2230: and pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id

Line 2672: select 'Y' from ben_elig_cvrd_dpnt_f ecd,

2668: ,p_business_group_id in number
2669: ) is
2670:
2671: cursor c_chk_enrt (c_rltp_start_date date,c_rltp_end_date date) is
2672: select 'Y' from ben_elig_cvrd_dpnt_f ecd,
2673: ben_prtt_enrt_rslt_f pen,
2674: ben_per_in_ler pil
2675: where ecd.dpnt_person_id = p_dpnt_person_id
2676: and ecd.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id