APPS.IEU_UWQ_MY_TASKS_ENUMS_PVT dependencies on JTF_TASKS_B

Line 38: FROM JTF_TASKS_B TASKS

34: FROM JTF_TASK_TYPES_TL TYPES
35: WHERE TYPES.LANGUAGE = USERENV('LANG')
36: AND EXISTS (
37: SELECT 1
38: FROM JTF_TASKS_B TASKS
39: WHERE tasks.open_flag = l_open_flag
40: AND TASKS.OWNER_ID = P_RESOURCE_ID
41: AND TASKS.OWNER_TYPE_CODE NOT IN ( l_owner_type_code1, l_owner_type_code2 )
42: AND TASKS.ENTITY = l_entity

Line 176: 'begin select /*+ index(tasks jtf_tasks_b_n2) */ count(*) into :l_count from jtf_tasks_b tasks '||

172: BEGIN
173: -- Get count
174:
175: l_sql_own_count :=
176: 'begin select /*+ index(tasks jtf_tasks_b_n2) */ count(*) into :l_count from jtf_tasks_b tasks '||
177: 'where '||
178: '( tasks.owner_id = :resource_id
179: and tasks.owner_type_code not in ('||''''||'RS_GROUP'||''''||','||''''||'RS_TEAM'||''''||') ) '||
180: 'and exists