DBA Data[Home] [Help]

APPS.HR_NO_UTILITY dependencies on FF_GLOBALS_F

Line 1163: FROM ff_globals_f

1159: FUNCTION get_global_value (l_global_name VARCHAR2 , l_date DATE ) RETURN VARCHAR2 IS
1160:
1161: CURSOR get_global_value(l_global_name VARCHAR2 , l_date date) IS
1162: SELECT GLOBAL_VALUE
1163: FROM ff_globals_f
1164: WHERE global_name = l_global_name
1165: AND LEGISLATION_CODE = 'NO'
1166: AND BUSINESS_GROUP_ID IS NULL
1167: AND l_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE ;

Line 1170: l_value ff_globals_f.global_value%TYPE;

1166: AND BUSINESS_GROUP_ID IS NULL
1167: AND l_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE ;
1168:
1169:
1170: l_value ff_globals_f.global_value%TYPE;
1171:
1172: BEGIN
1173:
1174: OPEN get_global_value(l_global_name , l_date);