APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_LEE_RSN_F

Line 10106: l_dys_no_enrl_not_elig_num ben_lee_rsn_f.dys_no_enrl_not_elig_num%TYPE;

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

Line 10180: FROM ben_lee_rsn_f len

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