DBA Data[Home] [Help]

APPS.PAY_NL_TAX_PKG dependencies on FND_NUMBER

Line 228: SELECT fnd_number.canonical_to_number(gbl.global_value)

224: --
225:
226: -- Global to get pension age limit
227: CURSOR get_pension_age_limit(v_period_end_date DATE) IS
228: SELECT fnd_number.canonical_to_number(gbl.global_value)
229: FROM ff_globals_f gbl
230: WHERE gbl.LEGISLATION_CODE = 'NL'
231: AND gbl.GLOBAL_NAME = 'NL_TAX_SENIOR_AGE_MONTHS'
232: AND v_period_end_date between gbl.effective_start_date and gbl.effective_end_date;

Line 361: SELECT fnd_number.canonical_to_number(gbl.global_value)

357: AND p_date_earned BETWEEN per.effective_start_date AND per.effective_end_date;
358:
359: -- Global to get pension age limit
360: CURSOR get_pension_age_limit IS
361: SELECT fnd_number.canonical_to_number(gbl.global_value)
362: FROM ff_globals_f gbl
363: WHERE gbl.LEGISLATION_CODE = 'NL'
364: AND gbl.GLOBAL_NAME = 'NL_TAX_SENIOR_AGE_MONTHS'
365: AND p_date_earned between gbl.effective_start_date and gbl.effective_end_date;