APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on CS_KB_SET_USED_HISTS

Line 3513: from cs_kb_set_used_hists a, cs_lookups cl

3509: sum(to_number(cl.meaning)*(1-(sysdate-a.creation_date)/l_time_usage))
3510: +
3511: (l_avg_score * ( 1 - (sysdate - c.last_update_date)/l_time_usage) )
3512: )
3513: from cs_kb_set_used_hists a, cs_lookups cl
3514: where a.set_id = c.set_id
3515: and a.used_type = cl.lookup_code
3516: and cl.lookup_type = 'CS_KB_USAGE_TYPE_WEIGHT'
3517: and a.creation_date >= (sysdate - l_time_usage)

Line 3526: from cs_kb_set_used_hists a, cs_lookups cl

3522: where c.status = 'PUB'
3523: and c.last_update_date > (sysdate-l_time_usage)
3524: and exists (
3525: select null
3526: from cs_kb_set_used_hists a, cs_lookups cl
3527: where a.set_id = c.set_id
3528: and a.used_type = cl.lookup_code
3529: and cl.lookup_type = 'CS_KB_USAGE_TYPE_WEIGHT'
3530: and a.creation_date >= (sysdate - l_time_usage)

Line 3574: from cs_kb_set_used_hists a, cs_lookups cl

3570: update cs_kb_sets_b c set usage_score =
3571: (
3572: select round(sum(to_number(cl.meaning)*(1-(sysdate-a.creation_date)/l_time_usage))
3573: )
3574: from cs_kb_set_used_hists a, cs_lookups cl
3575: where a.set_id = c.set_id
3576: and a.used_type = cl.lookup_code
3577: and cl.lookup_type = 'CS_KB_USAGE_TYPE_WEIGHT'
3578: and a.creation_date >= (sysdate - l_time_usage)

Line 3587: from cs_kb_set_used_hists a, cs_lookups cl

3583: where c.status = 'PUB'
3584: and c.last_update_date <= (sysdate-l_time_usage)
3585: and exists (
3586: select null
3587: from cs_kb_set_used_hists a, cs_lookups cl
3588: where a.set_id = c.set_id
3589: and a.used_type = cl.lookup_code
3590: and cl.lookup_type = 'CS_KB_USAGE_TYPE_WEIGHT'
3591: and a.creation_date >= (sysdate - l_time_usage)