DBA Data[Home] [Help]

APPS.OKC_TIME_RES_PVT dependencies on JTF_TASKS_B

Line 1708: SELECT '1' from OKC_RESOLVED_TIMEVALUES rtv, JTF_TASKS_B t, JTF_TASK_TYPES_VL tt

1704: SELECT '1' from OKC_RESOLVED_TIMEVALUES
1705: WHERE tve_id = p_tve_id AND
1706: datetime <= p_date
1707: UNION ALL
1708: SELECT '1' from OKC_RESOLVED_TIMEVALUES rtv, JTF_TASKS_B t, JTF_TASK_TYPES_VL tt
1709: WHERE SOURCE_OBJECT_ID = rtv.id AND
1710: t.TASK_TYPE_ID = tt.TASK_TYPE_ID AND
1711: tve_id = p_tve_id AND
1712: tt.task_type_id = 23 AND