APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_LEE_RSN_F

Line 10105: l_dys_no_enrl_not_elig_num ben_lee_rsn_f.dys_no_enrl_not_elig_num%TYPE;

10101: l_dsbld BOOLEAN := FALSE;
10102: l_ok BOOLEAN;
10103: l_exists VARCHAR2(1);
10104: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
10105: l_dys_no_enrl_not_elig_num ben_lee_rsn_f.dys_no_enrl_not_elig_num%TYPE;
10106: l_rec ben_person_object.g_person_date_info_rec;
10107: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%TYPE;
10108: l_object_version_number ben_cbr_quald_bnf.object_version_number%TYPE;
10109: l_effective_date DATE;

Line 10179: FROM ben_lee_rsn_f len

10175: --
10176: CURSOR c_get_elig_days(
10177: p_lee_rsn_id NUMBER) IS
10178: SELECT len.dys_no_enrl_not_elig_num
10179: FROM ben_lee_rsn_f len
10180: WHERE len.lee_rsn_id = p_lee_rsn_id
10181: AND len.business_group_id = p_business_group_id
10182: AND NVL(p_lf_evt_ocrd_dt
10183: ,p_effective_date) BETWEEN len.effective_start_date