DBA Data[Home] [Help]

APPS.CSM_WF_PKG dependencies on JTF_TASK_STATUSES_B

Line 110: FROM jtf_task_statuses_b jts

106: WHERE jt.task_id = p_task_id
107: AND (jt.source_object_type_code = 'TASK' OR jt.source_object_type_code IS NULL)
108: UNION
109: SELECT 1
110: FROM jtf_task_statuses_b jts
111: WHERE jts.task_status_id = b_status_id
112: AND ( jts.ASSIGNED_FLAG = 'Y'
113: OR jts.COMPLETED_FLAG = 'Y'
114: OR jts.CLOSED_FLAG = 'Y');

Line 158: FROM jtf_task_statuses_b jts

154: WHERE jt.task_id = p_task_id
155: AND (jt.source_object_type_code = 'TASK' OR jt.source_object_type_code IS NULL)
156: UNION
157: SELECT 1
158: FROM jtf_task_statuses_b jts
159: WHERE jts.task_status_id = b_status_id
160: AND ( jts.ASSIGNED_FLAG = 'Y'
161: OR jts.COMPLETED_FLAG = 'Y'
162: OR jts.CLOSED_FLAG = 'Y');