APPS.PQP_NL_PGGM_FUNCTIONS dependencies on FF_GLOBALS_F

Line 10: FROM ff_globals_f

6: --the threshold is constant,from global values
7: --
8: CURSOR c_get_global_value(c_global_name IN VARCHAR2,c_date_earned IN DATE) IS
9: SELECT nvl(fnd_number.canonical_to_number(global_value),0)
10: FROM ff_globals_f
11: WHERE global_name = c_global_name
12: AND legislation_code = 'NL'
13: AND (c_date_earned between effective_start_date and effective_end_date);
14:

Line 30: FROM ff_globals_f

26:
27: --9975522
28: CURSOR c_get_global_value_custom(c_global_name IN VARCHAR2, c_date_earned IN DATE, c_business_group_id IN NUMBER) IS
29: SELECT nvl(fnd_number.canonical_to_number(global_value),0)
30: FROM ff_globals_f
31: WHERE global_name = c_global_name
32: AND legislation_code IS NULL
33: AND business_group_id = c_business_group_id
34: AND (c_date_earned between effective_start_date and effective_end_date);

Line 1254: FROM ff_globals_f

1250: -- Cursor to get the holiday allowance global
1251: --
1252: CURSOR c_global_cur(c_global_name IN VARCHAR2) IS
1253: SELECT fnd_number.canonical_to_number(global_value)
1254: FROM ff_globals_f
1255: WHERE global_name = c_global_name
1256: AND trunc (p_date_earned) BETWEEN effective_start_date
1257: AND effective_end_date;
1258: