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.CSF_ALERTS_PUB dependencies on DUAL

Line 135: select 'TRUE' from dual where v_old_status_id in (select

131: null,
132: null);
133:
134: cursor c_check_task_status_id (v_new_status_id number, v_old_status_id number) is
135: select 'TRUE' from dual where v_old_status_id in (select
136: task_status_id
137: from
138: jtf_task_statuses_b
139: where

Line 206: from dual;

202: where
203: task_id = v_task_id
204: and task_audit_id = v_task_audit_id
205: and new_task_priority_id <> old_task_priority_id) as is_priority
206: from dual;
207:
208: cursor c_get_all_assignments (v_task_id number) is
209: select
210: task_assignment_Id