APPS.CS_SR_CHILD_AUDIT_PKG dependencies on JTF_TASKS_VL

Line 48: FROM jtf_tasks_vl

44: creation_date ,
45: last_updated_by,
46: source_object_type_code ,
47: source_object_id
48: FROM jtf_tasks_vl
49: WHERE task_id = p_task_id ;
50:
51: -- Cursor to get Task Assignment Details
52:

Line 63: jtf_tasks_vl t

59: ta.last_update_date,
60: ta.creation_date,
61: ta.last_updated_by
62: FROM jtf_task_all_assignments ta,
63: jtf_tasks_vl t
64: WHERE ta.task_id = t.task_id
65: AND ta.task_assignment_id = p_task_assignment_id ;
66:
67: -- Cursor to get Note details

Line 93: FROM jtf_tasks_vl t,

89: r.reference_code ,
90: r.object_type_code ref_object_type_code,
91: r.object_id ref_object_id ,
92: r.task_reference_id
93: FROM jtf_tasks_vl t,
94: jtf_task_references_vl r
95: WHERE t.task_id = p_task_id
96: AND t.task_id = r.task_id ;
97:

Line 108: FROM jtf_tasks_vl t

104: t.escalation_level,
105: t.creation_date,
106: t.last_update_date,
107: t.last_updated_by
108: FROM jtf_tasks_vl t
109: WHERE t.task_id = p_task_id ;
110: --Added by bkanimoz
111: CURSOR get_inc_details (p_incident_id IN NUMBER) IS
112: SELECT incident_number ,