DBA Data[Home] [Help]

APPS.PQP_PENSION_FUNCTIONS dependencies on FF_GLOBALS_F

Line 499: FROM ff_globals_f

495:
496: CURSOR c_get_global ( c_global_name IN VARCHAR2
497: ,c_effective_date IN DATE ) IS
498: SELECT fnd_number.canonical_to_number(global_value)
499: FROM ff_globals_f
500: WHERE global_name = c_global_name
501: AND trunc(c_effective_date) BETWEEN effective_start_date AND effective_end_date
502: AND legislation_code = 'NL';
503:

Line 2137: FROM ff_globals_f

2133: -- Cursor to get the holiday allowance global
2134: -- =======================================================================
2135: CURSOR c_global_cur(c_global_name IN VARCHAR2) IS
2136: SELECT fnd_number.canonical_to_number(global_value)
2137: FROM ff_globals_f
2138: WHERE global_name = c_global_name
2139: AND trunc (p_date_earned) BETWEEN effective_start_date
2140: AND effective_end_date;
2141: