DBA Data[Home] [Help]

APPS.PQP_PENSION_FUNCTIONS dependencies on FF_GLOBALS_F

Line 457: FROM ff_globals_f

453:
454: CURSOR c_get_global ( c_global_name IN VARCHAR2
455: ,c_effective_date IN DATE ) IS
456: SELECT fnd_number.canonical_to_number(global_value)
457: FROM ff_globals_f
458: WHERE global_name = c_global_name
459: AND trunc(c_effective_date) BETWEEN effective_start_date AND effective_end_date
460: AND legislation_code = 'NL';
461:

Line 2072: FROM ff_globals_f

2068: -- Cursor to get the holiday allowance global
2069: -- =======================================================================
2070: CURSOR c_global_cur(c_global_name IN VARCHAR2) IS
2071: SELECT fnd_number.canonical_to_number(global_value)
2072: FROM ff_globals_f
2073: WHERE global_name = c_global_name
2074: AND trunc (p_date_earned) BETWEEN effective_start_date
2075: AND effective_end_date;
2076: