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_GB_NICAR_06042002 dependencies on PAY_USER_TABLES

Line 185: pay_user_tables put

181:
182: cursor csr_min_qual_level is
183: select min(pur.row_low_range_or_name)
184: from pay_user_rows_f pur,
185: pay_user_tables put
186: where put.user_table_id = pur.user_table_id
187: and put.user_table_name = 'GB_CO2_EMISSIONS'
188: and p_session_date between
189: pur.effective_start_date and pur.effective_end_date;

Line 194: pay_user_tables put

190:
191: cursor csr_max_level is
192: select max(pur.row_low_range_or_name)
193: from pay_user_rows_f pur,
194: pay_user_tables put
195: where put.user_table_id = pur.user_table_id
196: and put.user_table_name = 'GB_CO2_EMISSIONS'
197: and p_session_date between
198: pur.effective_start_date and pur.effective_end_date;

Line 208: from pay_user_tables

204: pay_user_columns puc
205: where puc.user_column_id = puci.user_column_id
206: and puc.user_table_id =
207: (select user_table_id
208: from pay_user_tables
209: where user_table_name = 'GB_CO2_EMISSIONS')
210: and p_session_date between
211: puci.effective_start_date and puci.effective_end_date;
212:

Line 221: from pay_user_tables

217: pay_user_columns puc
218: where puc.user_column_id = puci.user_column_id
219: and puc.user_table_id =
220: (select user_table_id
221: from pay_user_tables
222: where user_table_name = 'GB_CO2_EMISSIONS')
223: and p_session_date between
224: puci.effective_start_date and puci.effective_end_date;
225: