DBA Data[Home] [Help]

APPS.BEN_ELIG_DPNT_API dependencies on BEN_ELIG_CVRD_DPNT_F

Line 1454: from ben_elig_cvrd_dpnt_f pdp

1450: select pdp.cvg_strt_dt,
1451: pdp.cvg_thru_dt,
1452: pdp.object_version_number,
1453: pdp.effective_start_date
1454: from ben_elig_cvrd_dpnt_f pdp
1455: where pdp.elig_cvrd_dpnt_id = l_egd_rec.elig_cvrd_dpnt_id
1456: and pdp.prtt_enrt_rslt_id = l_egd_rec.prtt_enrt_rslt_id
1457: and pdp.business_group_id = p_business_group_id
1458: and p_effective_date between

Line 2170: ben_elig_cvrd_dpnt_f pdp,

2166: --
2167: cursor c_pdp is
2168: select egd.*
2169: from ben_elig_dpnt egd,
2170: ben_elig_cvrd_dpnt_f pdp,
2171: ben_per_in_ler pil
2172: where pdp.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
2173: and pdp.per_in_ler_id = egd.per_in_ler_id
2174: and pdp.elig_cvrd_dpnt_id = egd.elig_cvrd_dpnt_id

Line 2219: ben_elig_cvrd_dpnt_f pdp,

2215: --
2216: cursor c_pen is
2217: select egd.*
2218: from ben_elig_dpnt egd,
2219: ben_elig_cvrd_dpnt_f pdp,
2220: ben_prtt_enrt_rslt_f pen,
2221: ben_per_in_ler pil
2222: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2223: and pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id