DBA Data[Home] [Help]

APPS.OKL_INSURANCE_WF dependencies on JTF_OBJECTS_VL

Line 256: JTF_OBJECTS_VL OB

252: CURSOR task_temp_grp_name_csr (temp_grp_id NUMBER)
253: IS
254: SELECT T.TEMPLATE_GROUP_NAME
255: FROM JTF_TASK_TEMP_GROUPS_VL T,
256: JTF_OBJECTS_VL OB
257: WHERE T.SOURCE_OBJECT_TYPE_CODE = OB.OBJECT_CODE
258: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(T.START_DATE_ACTIVE, SYSDATE))
259: AND TRUNC(NVL(T.END_DATE_ACTIVE, SYSDATE))
260: AND T.TASK_TEMPLATE_GROUP_ID = temp_grp_id;