DBA Data[Home] [Help]

APPS.CSP_REQUIREMENT_HEADERS_PUB dependencies on JTF_OBJECT_USAGES

Line 190: jtf_object_usages jou

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
194: AND jou.object_user_code = 'RESOURCES'