APPS.CSM_WF_PKG dependencies on JTF_TASK_TYPES_B

Line 166: FROM JTF_TASK_TYPES_B

162: OR jts.CLOSED_FLAG = 'Y');
163:
164: CURSOR c_task_type (b_type_id NUMBER) IS
165: SELECT 1
166: FROM JTF_TASK_TYPES_B
167: WHERE TASK_TYPE_ID = b_type_id
168: AND (RULE = 'DISPATCH' OR private_flag = 'Y');
169:
170: l_temp NUMBER := NULL;

Line 228: jtf_task_types_b jtt

224:
225: CURSOR l_task_csr (b_task_id NUMBER) IS
226: SELECT jt.CREATED_BY, jtt.private_flag, jt.source_object_type_code -- 22 means Escalation task
227: FROM JTF_TASKS_B jt,
228: jtf_task_types_b jtt
229: WHERE jt.TASK_ID = b_task_id
230: AND jtt.task_type_id = jt.task_type_id;
231:
232: l_task_rec l_task_csr%ROWTYPE;