DBA Data[Home] [Help]

APPS.PAY_NO_EMP_CONT_2007 dependencies on FF_GLOBALS_F

Line 2134: from ff_globals_f

2130: cursor csr_get_ni_base_rates (p_date_earned date ) IS
2131: select EFFECTIVE_START_DATE
2132: , EFFECTIVE_END_DATE
2133: , to_number(global_value) VALUE
2134: from ff_globals_f
2135: where legislation_code = 'NO'
2136: and global_name = 'NO_NATIONAL_INSURANCE_BASE_RATE'
2137: and BUSINESS_GROUP_ID IS NULL
2138: and effective_start_date <= (trunc(add_months(p_date_earned,12),'Y')-1)

Line 2146: from ff_globals_f

2142: cursor csr_get_ni_base_rates (p_date_earned date ) IS
2143: select EFFECTIVE_START_DATE
2144: , EFFECTIVE_END_DATE
2145: , fnd_number.canonical_to_number(global_value) VALUE
2146: from ff_globals_f
2147: where legislation_code = 'NO'
2148: and global_name = 'NO_NATIONAL_INSURANCE_BASE_RATE'
2149: and BUSINESS_GROUP_ID IS NULL
2150: and effective_start_date <= (trunc(add_months(p_date_earned,12),'Y')-1)