APPS.JTF_TASK_WF_UTIL dependencies on DUAL

Line 228: -- expand into individual members

224: END IF;
225: ELSIF p_resource_type_code IN('RS_GROUP', 'RS_TEAM') THEN
226: -- group or team resource
227: IF l_members = 'Y' THEN
228: -- expand into individual members
229: IF p_resource_type_code = 'RS_GROUP' THEN
230: FOR l_group_rec IN c_group_members(p_resource_id) LOOP
231: IF l_group_rec.resource_type_code = 'RS_EMPLOYEE' THEN
232: -- employee resource

Line 550: FROM DUAL;

546: AND tp.language(+) = userenv('LANG');
547:
548: CURSOR c_wf_processs_id IS
549: SELECT jtf_task_workflow_process_s.NEXTVAL
550: FROM DUAL;
551:
552: CURSOR c_type_name(b_type jtf_tasks_b.task_type_id%TYPE) IS
553: SELECT NAME
554: FROM jtf_task_types_vl