DBA Data[Home] [Help]

APPS.CSP_REQUIREMENT_HEADERS_PUB dependencies on JTF_OBJECTS_VL

Line 189: FROM jtf_objects_vl jov,

185: AND l_pvt_RQH_rec.resource_type <> FND_API.G_MISS_CHAR) THEN
186: BEGIN
187: SELECT count(jov.object_code)
188: INTO l_count
189: FROM jtf_objects_vl jov,
190: jtf_object_usages jou
191: WHERE trunc(sysdate) between trunc(nvl(jov.start_date_active,sysdate))
192: and trunc(nvl(jov.end_date_active,sysdate))
193: AND jou.object_code = jov.object_code