APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on CS_KB_SET_LINKS

Line 3545: from cs_kb_set_links a, cs_lookups cl

3541: sum(to_number(cl.meaning)*(1-(sysdate-a.creation_date)/l_time_usage))
3542: +
3543: (l_avg_score * ( 1 - (sysdate - c.last_update_date)/l_time_usage) )
3544: ) + c.usage_score
3545: from cs_kb_set_links a, cs_lookups cl
3546: where a.set_id = c.set_id
3547: and a.link_type = cl.lookup_code
3548: and cl.lookup_type = 'CS_KB_USAGE_TYPE_WEIGHT'
3549: and a.creation_date >= (sysdate - l_time_usage)

Line 3558: from cs_kb_set_links a, cs_lookups cl

3554: where c.status = 'PUB'
3555: and c.last_update_date > (sysdate-l_time_usage)
3556: and exists (
3557: select null
3558: from cs_kb_set_links a, cs_lookups cl
3559: where a.set_id = c.set_id
3560: and a.link_type = cl.lookup_code
3561: and cl.lookup_type = 'CS_KB_USAGE_TYPE_WEIGHT'
3562: and a.creation_date >= (sysdate - l_time_usage)

Line 3602: from cs_kb_set_links a, cs_lookups cl

3598: update cs_kb_sets_b c set usage_score =
3599: (
3600: select round(sum(to_number(cl.meaning)*(1-(sysdate-a.creation_date)/l_time_usage))
3601: ) + c.usage_score
3602: from cs_kb_set_links a, cs_lookups cl
3603: where a.set_id = c.set_id
3604: and a.link_type = cl.lookup_code
3605: and cl.lookup_type = 'CS_KB_USAGE_TYPE_WEIGHT'
3606: and a.creation_date >= (sysdate - l_time_usage)

Line 3615: from cs_kb_set_links a, cs_lookups cl

3611: where c.status = 'PUB'
3612: and c.last_update_date <= (sysdate-l_time_usage)
3613: and exists (
3614: select null
3615: from cs_kb_set_links a, cs_lookups cl
3616: where a.set_id = c.set_id
3617: and a.link_type = cl.lookup_code
3618: and cl.lookup_type = 'CS_KB_USAGE_TYPE_WEIGHT'
3619: and a.creation_date >= (sysdate - l_time_usage)