APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on CS_KB_SET_USED_HISTS

Line 3523: from cs_kb_set_used_hists a, cs_lookups cl

3519: sum(to_number(cl.meaning)*(1-(sysdate-a.creation_date)/l_time_usage))
3520: +
3521: (l_avg_score * ( 1 - (sysdate - c.last_update_date)/l_time_usage) )
3522: )
3523: from cs_kb_set_used_hists a, cs_lookups cl
3524: where a.set_id = c.set_id
3525: and a.used_type = cl.lookup_code
3526: and cl.lookup_type = 'CS_KB_USAGE_TYPE_WEIGHT'
3527: and a.creation_date >= (sysdate - l_time_usage)

Line 3536: from cs_kb_set_used_hists a, cs_lookups cl

3532: where c.status = 'PUB'
3533: and c.last_update_date > (sysdate-l_time_usage)
3534: and exists (
3535: select null
3536: from cs_kb_set_used_hists a, cs_lookups cl
3537: where a.set_id = c.set_id
3538: and a.used_type = cl.lookup_code
3539: and cl.lookup_type = 'CS_KB_USAGE_TYPE_WEIGHT'
3540: and a.creation_date >= (sysdate - l_time_usage)

Line 3584: from cs_kb_set_used_hists a, cs_lookups cl

3580: update cs_kb_sets_b c set usage_score =
3581: (
3582: select round(sum(to_number(cl.meaning)*(1-(sysdate-a.creation_date)/l_time_usage))
3583: )
3584: from cs_kb_set_used_hists a, cs_lookups cl
3585: where a.set_id = c.set_id
3586: and a.used_type = cl.lookup_code
3587: and cl.lookup_type = 'CS_KB_USAGE_TYPE_WEIGHT'
3588: and a.creation_date >= (sysdate - l_time_usage)

Line 3597: from cs_kb_set_used_hists a, cs_lookups cl

3593: where c.status = 'PUB'
3594: and c.last_update_date <= (sysdate-l_time_usage)
3595: and exists (
3596: select null
3597: from cs_kb_set_used_hists a, cs_lookups cl
3598: where a.set_id = c.set_id
3599: and a.used_type = cl.lookup_code
3600: and cl.lookup_type = 'CS_KB_USAGE_TYPE_WEIGHT'
3601: and a.creation_date >= (sysdate - l_time_usage)