eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_KW_GENERAL dependencies on FND_NUMBER

Line 160: SELECT MIN(fnd_number.canonical_to_number(row_low_range_or_name))

156: FROM pay_user_tables
157: WHERE legislation_code='KW'
158: AND UPPER(user_table_name) = UPPER(l_table_name);
159: CURSOR csr_get_min_low (l_user_table_id NUMBER, l_effective_date DATE) IS
160: SELECT MIN(fnd_number.canonical_to_number(row_low_range_or_name))
161: FROM pay_user_rows_f
162: WHERE user_table_id = l_user_table_id
163: AND legislation_code = 'KW'
164: AND l_effective_date BETWEEN effective_start_date AND effective_end_date;

Line 166: SELECT MIN(fnd_number.canonical_to_number(row_high_range))

162: WHERE user_table_id = l_user_table_id
163: AND legislation_code = 'KW'
164: AND l_effective_date BETWEEN effective_start_date AND effective_end_date;
165: CURSOR csr_get_min_high (l_user_table_id number ,l_effective_date DATE ) IS
166: SELECT MIN(fnd_number.canonical_to_number(row_high_range))
167: FROM pay_user_rows_f
168: WHERE user_table_id = l_user_table_id
169: AND legislation_code = 'KW'
170: AND l_effective_date BETWEEN effective_start_date AND effective_end_date;

Line 172: SELECT MAX(fnd_number.canonical_to_number(row_high_range))

168: WHERE user_table_id = l_user_table_id
169: AND legislation_code = 'KW'
170: AND l_effective_date BETWEEN effective_start_date AND effective_end_date;
171: CURSOR csr_get_max_high (l_user_table_id number, l_effective_date DATE) IS
172: SELECT MAX(fnd_number.canonical_to_number(row_high_range))
173: FROM pay_user_rows_f
174: WHERE user_table_id = l_user_table_id
175: AND legislation_code = 'KW'
176: AND l_effective_date BETWEEN effective_start_date AND effective_end_date;