APPS.BEN_DETERMINE_DPNT_ELIG_SS dependencies on BEN_ELIG_TO_PRTE_RSN_F

Line 722: from ben_elig_to_prte_rsn_f etpr

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

Line 732: from ben_elig_to_prte_rsn_f etpr

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

Line 742: from ben_elig_to_prte_rsn_f etpr

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

Line 752: from ben_elig_to_prte_rsn_f etpr

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

Line 762: from ben_elig_to_prte_rsn_f etpr

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

Line 768: l_elig_to_prte_rsn_id ben_elig_to_prte_rsn_f.elig_to_prte_rsn_id%TYPE;

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