APPS.CSP_REQUIREMENT_HEADERS_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 211: FROM jtf_rs_resource_extns

207: AND l_pvt_RQH_rec.resource_id <> FND_API.G_MISS_NUM) THEN
208: BEGIN
209: SELECT count(resource_id)
210: INTO l_count
211: FROM jtf_rs_resource_extns
212: WHERE resource_id = l_pvt_RQH_rec.resource_id
213: AND ( end_date_active is null OR
214: trunc(end_date_active) >= trunc(sysdate));
215: IF (l_count <= 0) THEN