APPS.IEU_WR_PUB dependencies on JTF_TASKS_B

Line 1995: from jtf_tasks_b tb, jtf_tasks_tl tt, jtf_task_priorities_vl tp, ieu_uwqm_priorities_b ip

1991: -- 'A', tb.actual_end_date, 'S', tb.scheduled_end_date, null, tb.scheduled_end_date) due_date,
1992: tb.planned_start_date, tb.planned_end_date, tb.actual_start_date, tb.actual_end_date,
1993: tb.scheduled_start_date, tb.scheduled_end_date,tb.task_type_id,
1994: tb.task_status_id, tt.task_name, tp.importance_level, ip.priority_code, tb.task_priority_id
1995: from jtf_tasks_b tb, jtf_tasks_tl tt, jtf_task_priorities_vl tp, ieu_uwqm_priorities_b ip
1996: where tb.entity = 'TASK' and nvl(tb.deleted_flag, 'N') = 'N' and tb.task_id = tt.task_id
1997: and tt.language = userenv('LANG') and tp.task_priority_id = nvl(tb.task_priority_id, 4)
1998: and least(tp.importance_level, 4) = ip.priority_level
1999: and tb.open_flag = 'Y'

Line 2005: FROM JTF_TASKS_B

2001:
2002: CURSOR c_task_status(p_source_object_type_code in varchar2) IS
2003: SELECT TASK_ID,
2004: DECODE(DELETED_FLAG, 'Y', 4, 3) "STATUS_ID"
2005: FROM JTF_TASKS_B
2006: WHERE SOURCE_OBJECT_TYPE_CODE = p_source_object_type_code
2007: AND ((OPEN_FLAG = 'N' AND DELETED_FLAG = 'N') OR (DELETED_FLAG = 'Y'))
2008: AND ENTITY = 'TASK';
2009:

Line 6792: from jtf_tasks_b tb, jtf_tasks_tl tt, jtf_task_priorities_vl tp, ieu_uwqm_priorities_b ip

6788: -- 'A', tb.actual_end_date, 'S', tb.scheduled_end_date, null, tb.scheduled_end_date) due_date,
6789: tb.planned_start_date, tb.planned_end_date, tb.actual_start_date, tb.actual_end_date,
6790: tb.scheduled_start_date, tb.scheduled_end_date,tb.task_type_id,
6791: tb.task_status_id, tt.task_name, tp.importance_level, ip.priority_code, tb.task_priority_id
6792: from jtf_tasks_b tb, jtf_tasks_tl tt, jtf_task_priorities_vl tp, ieu_uwqm_priorities_b ip
6793: where tb.entity = 'TASK' and nvl(tb.deleted_flag, 'N') = 'N' and tb.task_id = tt.task_id
6794: and tt.language = userenv('LANG') and tp.task_priority_id = nvl(tb.task_priority_id, 4)
6795: and least(tp.importance_level, 4) = ip.priority_level
6796: and tb.open_flag = 'Y'

Line 6842: FROM JTF_TASKS_B

6838:
6839: CURSOR c_task_status(p_source_object_type_code in varchar2) IS
6840: SELECT TASK_ID,
6841: DECODE(DELETED_FLAG, 'Y', 4, 3) "STATUS_ID"
6842: FROM JTF_TASKS_B
6843: WHERE SOURCE_OBJECT_TYPE_CODE = p_source_object_type_code
6844: AND ((OPEN_FLAG = 'N' AND DELETED_FLAG = 'N') OR (DELETED_FLAG = 'Y'))
6845: AND ENTITY = 'TASK';
6846:

Line 11338: from jtf_tasks_b tb

11334: , ip.priority_code
11335: , tb.date_selected
11336: , decode(nvl(sts_b.on_hold_flag, 'N'), 'Y', 'SLEEP', 'OPEN') workitem_status
11337: , tb.task_status_id
11338: from jtf_tasks_b tb
11339: , jtf_tasks_tl tt
11340: , jtf_task_priorities_vl tp
11341: , ieu_uwqm_priorities_b ip
11342: , jtf_task_statuses_b sts_b

Line 11399: FROM JTF_TASKS_B

11395:
11396: CURSOR c_task_status(p_source_object_type_code in varchar2) IS
11397: SELECT TASK_ID,
11398: DECODE(DELETED_FLAG, 'Y', 4, 3) "STATUS_ID"
11399: FROM JTF_TASKS_B
11400: WHERE SOURCE_OBJECT_TYPE_CODE = p_source_object_type_code
11401: AND ((OPEN_FLAG = 'N' AND DELETED_FLAG = 'N') OR (DELETED_FLAG = 'Y'))
11402: AND ENTITY = 'TASK';
11403: