368:
369: -- Cursor for fetching global value
370: Cursor csr_global_value(c_global_name VARCHAR2,c_date_earned DATE) IS
371: SELECT global_value 372: FROM ff_globals_f 373: WHERE global_name = c_global_name
374: AND legislation_code = 'FR'
375: AND c_date_earned BETWEEN effective_start_date AND effective_end_date;
376: