DBA Data[Home] [Help]

APPS.ASP_ALERTS_SUBS dependencies on JTF_TASKS_VL

Line 77: FROM jtf_tasks_vl t,

73:
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'