DBA Data[Home] [Help]

APPS.BEN_DETERMINE_DPNT_ELIGIBILITY dependencies on BEN_PRTT_ENRT_RSLT_F

Line 452: from ben_prtt_enrt_rslt_f pen

448: -- Gets the enrolment information for this plan
449: --
450: cursor c_plan_enrolment_info is
451: select prtt_enrt_rslt_id
452: from ben_prtt_enrt_rslt_f pen
453: where pen.person_id=p_person_id and
454: pen.business_group_id =p_business_group_id and
455: --pen.sspndd_flag='N' and --5127698
456: pen.prtt_enrt_rslt_stat_cd is null and

Line 468: from ben_prtt_enrt_rslt_f pen

464: -- Gets the enrolment information for this oipl
465: --
466: cursor c_oipl_enrolment_info is
467: select prtt_enrt_rslt_id
468: from ben_prtt_enrt_rslt_f pen
469: where pen.person_id=p_person_id and
470: pen.business_group_id =p_business_group_id and
471: --pen.sspndd_flag='N' and --5127698
472: pen.prtt_enrt_rslt_stat_cd is null and