3: -- Cursor to fetch global values
4: CURSOR GLB_VALUE(GLB_NAME VARCHAR2, ABS_DATE DATE)
5: IS
6: SELECT TRIM(GLOBAL_VALUE) 7: FROM FF_GLOBALS_F GLB 8: WHERE ABS_DATE BETWEEN GLB.EFFECTIVE_START_DATE AND GLB.EFFECTIVE_END_DATE
9: AND GLB.GLOBAL_NAME = GLB_NAME
10: AND GLB.LEGISLATION_CODE = 'NO';
11: