APPS.BEN_PRTT_ENRT_RESULT_API dependencies on BEN_ELIG_DPNT

Line 3119: ben_elig_dpnt egd,

3115: pdp.effective_start_date,
3116: pdp.object_version_number,
3117: pdp.cvg_thru_dt --9881657
3118: from ben_elig_per_elctbl_chc epe,
3119: ben_elig_dpnt egd,
3120: ben_elig_cvrd_dpnt_f pdp,
3121: ben_per_in_ler egd_pil,
3122: ben_per_in_ler pdp_pil
3123: where epe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id

Line 3194: ------Check if the elig_cvrd_dpnt_id is set in ben_elig_dpnt table,Bug 8919376

3190: from ben_elig_cvrd_dpnt_f pdp
3191: where pdp.elig_cvrd_dpnt_id = p_pdp_id;
3192: /* Bug 9748558 */
3193:
3194: ------Check if the elig_cvrd_dpnt_id is set in ben_elig_dpnt table,Bug 8919376
3195: cursor c_check_cvrd_dpnt(p_dpnt_cvg_thru_dt date) is --9881657
3196: select egd.*,pdp.elig_cvrd_dpnt_id cvrd_dpnt_id
3197: from ben_elig_per_elctbl_chc epe,
3198: ben_elig_dpnt egd,

Line 3198: ben_elig_dpnt egd,

3194: ------Check if the elig_cvrd_dpnt_id is set in ben_elig_dpnt table,Bug 8919376
3195: cursor c_check_cvrd_dpnt(p_dpnt_cvg_thru_dt date) is --9881657
3196: select egd.*,pdp.elig_cvrd_dpnt_id cvrd_dpnt_id
3197: from ben_elig_per_elctbl_chc epe,
3198: ben_elig_dpnt egd,
3199: ben_elig_cvrd_dpnt_f pdp,
3200: ben_per_in_ler egd_pil,
3201: ben_per_in_ler pdp_pil
3202: where epe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id

Line 4228: ben_elig_dpnt_api.update_perf_elig_dpnt

4224: --9881657
4225:
4226: --------Bug 8919376
4227: for l_chk_cvrd_dpnt in c_check_cvrd_dpnt(l_dpnt_cvg_thru_dt) loop --9881657
4228: ben_elig_dpnt_api.update_perf_elig_dpnt
4229: (p_elig_dpnt_id => l_chk_cvrd_dpnt.elig_dpnt_id
4230: ,p_per_in_ler_id => l_chk_cvrd_dpnt.per_in_ler_id
4231: ,p_elig_thru_dt => l_chk_cvrd_dpnt.elig_thru_dt
4232: ,p_elig_cvrd_dpnt_id => l_chk_cvrd_dpnt.cvrd_dpnt_id