APPS.JTF_TASK_WF_UTIL dependencies on DUAL

Line 261: -- expand into individual members

257: END IF;
258: ELSIF p_resource_type_code IN('RS_GROUP', 'RS_TEAM') THEN
259: -- group or team resource
260: IF l_members = 'Y' THEN
261: -- expand into individual members
262: IF p_resource_type_code = 'RS_GROUP' THEN
263: FOR l_group_rec IN c_group_members(p_resource_id) LOOP
264: IF l_group_rec.resource_type_code = 'RS_EMPLOYEE' THEN
265: -- employee resource

Line 583: FROM DUAL;

579: AND tp.language(+) = userenv('LANG');
580:
581: CURSOR c_wf_processs_id IS
582: SELECT jtf_task_workflow_process_s.NEXTVAL
583: FROM DUAL;
584:
585: CURSOR c_type_name(b_type jtf_tasks_b.task_type_id%TYPE) IS
586: SELECT NAME
587: FROM jtf_task_types_vl