DBA Data[Home] [Help]

APPS.JTF_TASK_WORKFLOW_PKG dependencies on JTF_TASKS_VL

Line 229: FROM jtf_tasks_vl a

225: -- Added by SBARAT on 23/02/2006 for bug# 5045559
226: CURSOR c_task_details
227: IS
228: SELECT a.task_name, a.description, a.owner_type_code owner_code, a.owner_id, a.task_number
229: FROM jtf_tasks_vl a
230: WHERE a.task_id = p_task_id
231: AND (a.deleted_flag <> 'Y' OR a.deleted_flag is null)
232: AND a.task_type_id <> 22;
233:

Line 724: FROM jtf_tasks_vl

720: IS
721: CURSOR c_task_details
722: IS
723: SELECT task_name, description, owner_type_code owner_code, owner_id
724: FROM jtf_tasks_vl
725: WHERE task_id = p_task_id;
726:
727: l_api_version CONSTANT NUMBER := 1.0;
728: l_api_name CONSTANT VARCHAR2(30)