APPS.ASP_ALERTS_SUBS dependencies on JTF_TASK_REFERENCES_VL
Line 78: jtf_task_references_vl r
74: CURSOR get_ref_sr(p_task_id in number) is
75: SELECT r.object_id,
76: t.escalation_level
77: FROM jtf_tasks_vl t, 78: jtf_task_references_vl r 79: WHERE t.task_id = p_task_id
80: and t.task_id = r.task_id
81: and r.object_type_code = 'SR'
82: and r.reference_code = 'ESC'