DBA Data[Home] [Help]

APPS.HR_NO_UTILITY dependencies on FF_GLOBALS_F

Line 1239: FROM ff_globals_f

1235: FUNCTION get_global_value (l_global_name VARCHAR2 , l_date DATE ) RETURN VARCHAR2 IS
1236:
1237: CURSOR get_global_value(l_global_name VARCHAR2 , l_date date) IS
1238: SELECT GLOBAL_VALUE
1239: FROM ff_globals_f
1240: WHERE global_name = l_global_name
1241: AND LEGISLATION_CODE = 'NO'
1242: AND BUSINESS_GROUP_ID IS NULL
1243: AND l_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE ;

Line 1246: l_value ff_globals_f.global_value%TYPE;

1242: AND BUSINESS_GROUP_ID IS NULL
1243: AND l_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE ;
1244:
1245:
1246: l_value ff_globals_f.global_value%TYPE;
1247:
1248: BEGIN
1249:
1250: OPEN get_global_value(l_global_name , l_date);