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 137: select 'TRUE' from dual where v_old_status_id in (select

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

Line 215: from dual;

211: and jtb.source_object_type_code = 'SR'
212: and jtb.task_id = jtab.task_id
213: and jtab.task_audit_id = v_task_audit_id
214: and jtab.new_task_priority_id <> jtab.old_task_priority_id) as is_priority
215: from dual;
216:
217: cursor c_get_all_assignments (v_task_id number) is
218: select
219: task_assignment_Id