7188: -- from Global (NO_NATIONAL_INSURANCE_BASE_RATE) and not user table (NATIONAL_INSURANCE_BASE_RATE).
7189:
7190: select fnd_number.canonical_to_number(GLOBAL_VALUE)
7191: into l_g_rate 7192: from ff_globals_f 7193: where global_name = 'NO_NATIONAL_INSURANCE_BASE_RATE'
7194: and LEGISLATION_CODE = 'NO'
7195: and BUSINESS_GROUP_ID IS NULL
7196: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE ;