DBA Data[Home] [Help]

APPS.PAY_NO_EMP_CONT_2007 dependencies on FF_GLOBALS_F

Line 1897: from ff_globals_f

1893: cursor csr_get_ni_base_rates (p_date_earned date ) IS
1894: select EFFECTIVE_START_DATE
1895: , EFFECTIVE_END_DATE
1896: , to_number(global_value) VALUE
1897: from ff_globals_f
1898: where legislation_code = 'NO'
1899: and global_name = 'NO_NATIONAL_INSURANCE_BASE_RATE'
1900: and BUSINESS_GROUP_ID IS NULL
1901: and effective_start_date <= (trunc(add_months(p_date_earned,12),'Y')-1)

Line 1909: from ff_globals_f

1905: cursor csr_get_ni_base_rates (p_date_earned date ) IS
1906: select EFFECTIVE_START_DATE
1907: , EFFECTIVE_END_DATE
1908: , fnd_number.canonical_to_number(global_value) VALUE
1909: from ff_globals_f
1910: where legislation_code = 'NO'
1911: and global_name = 'NO_NATIONAL_INSURANCE_BASE_RATE'
1912: and BUSINESS_GROUP_ID IS NULL
1913: and effective_start_date <= (trunc(add_months(p_date_earned,12),'Y')-1)