APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on CS_KB_ELEMENT_TYPES_VL

Line 89: FROM CS_KB_SET_ELE_TYPES A, CS_KB_ELEMENT_TYPES_VL B

85:
86: -- list of required element types
87: CURSOR cur_ele_type(p_set_type_id IN NUMBER) IS
88: SELECT B.element_type_id
89: FROM CS_KB_SET_ELE_TYPES A, CS_KB_ELEMENT_TYPES_VL B
90: WHERE A.set_type_id = p_set_type_id
91: AND A.optional_flag = 'N'
92: AND A.element_type_id = B.element_type_id
93: AND trunc(sysdate) between trunc(nvl(B.start_date_active, sysdate)) and trunc(nvl(B.end_date_active, sysdate))

Line 3974: cs_kb_element_types_vl d, cs_lookups e

3970: CURSOR get_element_info(c_set_id IN NUMBER) IS
3971: select a.element_number, d.name, e.meaning,
3972: NVL(a.content_type, 'TEXT/HTML'), b.name, b.description, a.status
3973: from cs_kb_elements_b a , cs_kb_elements_tl b, cs_kb_set_eles c,
3974: cs_kb_element_types_vl d, cs_lookups e
3975: where a.element_id = c.element_id and c.set_id = c_set_id
3976: and a.element_id = b.element_id and b.language = userenv('LANG')
3977: and a.element_type_id = d.element_type_id
3978: and a.access_level = e.lookup_code and e.lookup_type = 'CS_KB_ACCESS_LEVEL';