APPS.CS_WF_EVENT_SUBSCRIPTIONS_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 241: FROM jtf_task_assignments a, jtf_rs_resource_extns b

237:
238: /* The following 2 cursors will get the task resource information required to send WF notifications */
239: CURSOR cs_sr_get_task_assignee_id_csr IS
240: SELECT b.source_id
241: FROM jtf_task_assignments a, jtf_rs_resource_extns b
242: WHERE a.resource_id = b.resource_id(+) AND
243: a.task_id = l_task_id;
244:
245: CURSOR cs_sr_get_task_owner_id_csr IS

Line 247: FROM jtf_tasks_b a, jtf_rs_resource_extns b

243: a.task_id = l_task_id;
244:
245: CURSOR cs_sr_get_task_owner_id_csr IS
246: SELECT b.source_id
247: FROM jtf_tasks_b a, jtf_rs_resource_extns b
248: WHERE a.owner_id = b.resource_id(+) AND
249: a.task_id = l_task_id;
250:
251: BEGIN