APPS.BEN_DETERMINE_DPNT_ELIG_SS dependencies on BEN_ELIG_TO_PRTE_RSN_F

Line 725: from ben_elig_to_prte_rsn_f etpr

721: cursor c_elig_to_prte_pgm(l_pgm_id number) is
722: select etpr.elig_to_prte_rsn_id,
723: etpr.vrfy_fmly_mmbr_cd,
724: etpr.vrfy_fmly_mmbr_rl
725: from ben_elig_to_prte_rsn_f etpr
726: where etpr.business_group_id = p_business_group_id
727: and etpr.pgm_id = l_pgm_id
728: and p_effective_date
729: between etpr.effective_start_date and etpr.effective_end_date;

Line 735: from ben_elig_to_prte_rsn_f etpr

731: cursor c_elig_to_prte_plip(l_plip_id number) is
732: select etpr.elig_to_prte_rsn_id,
733: etpr.vrfy_fmly_mmbr_cd,
734: etpr.vrfy_fmly_mmbr_rl
735: from ben_elig_to_prte_rsn_f etpr
736: where etpr.business_group_id = p_business_group_id
737: and etpr.plip_id = l_plip_id
738: and p_effective_date
739: between etpr.effective_start_date and etpr.effective_end_date;

Line 745: from ben_elig_to_prte_rsn_f etpr

741: cursor c_elig_to_prte_pl(l_pl_id number) is
742: select etpr.elig_to_prte_rsn_id,
743: etpr.vrfy_fmly_mmbr_cd,
744: etpr.vrfy_fmly_mmbr_rl
745: from ben_elig_to_prte_rsn_f etpr
746: where etpr.business_group_id = p_business_group_id
747: and etpr.pl_id = l_pl_id
748: and p_effective_date
749: between etpr.effective_start_date and etpr.effective_end_date;

Line 755: from ben_elig_to_prte_rsn_f etpr

751: cursor c_elig_to_prte_ptip(l_ptip_id number) is
752: select etpr.elig_to_prte_rsn_id,
753: etpr.vrfy_fmly_mmbr_cd,
754: etpr.vrfy_fmly_mmbr_rl
755: from ben_elig_to_prte_rsn_f etpr
756: where etpr.business_group_id = p_business_group_id
757: and etpr.ptip_id = l_ptip_id
758: and p_effective_date
759: between etpr.effective_start_date and etpr.effective_end_date;

Line 765: from ben_elig_to_prte_rsn_f etpr

761: cursor c_elig_to_prte_oipl(l_oipl_id number) is
762: select etpr.elig_to_prte_rsn_id,
763: etpr.vrfy_fmly_mmbr_cd,
764: etpr.vrfy_fmly_mmbr_rl
765: from ben_elig_to_prte_rsn_f etpr
766: where etpr.business_group_id = p_business_group_id
767: and etpr.oipl_id = l_oipl_id
768: and p_effective_date
769: between etpr.effective_start_date and etpr.effective_end_date;

Line 771: l_elig_to_prte_rsn_id ben_elig_to_prte_rsn_f.elig_to_prte_rsn_id%TYPE;

767: and etpr.oipl_id = l_oipl_id
768: and p_effective_date
769: between etpr.effective_start_date and etpr.effective_end_date;
770: --
771: l_elig_to_prte_rsn_id ben_elig_to_prte_rsn_f.elig_to_prte_rsn_id%TYPE;
772: l_vrfy_fmly_mmbr_cd ben_pgm_f.vrfy_fmly_mmbr_cd%TYPE;
773: l_vrfy_fmly_mmbr_rl ben_pgm_f.vrfy_fmly_mmbr_rl%TYPE;
774: l_per_cvrd_cd ben_pl_f.per_cvrd_cd%TYPE;
775: l_found boolean := false;