APPS.CS_KB_ELEMENTS_AUDIT_PKG dependencies on CS_KB_ELEMENT_TYPES_B

Line 618: FROM cs_kb_element_types_b

614: l_dummy VARCHAR2(1) := null;
615:
616: CURSOR check_active_type_csr(p_element_type_id IN NUMBER) IS
617: SELECT 'X'
618: FROM cs_kb_element_types_b
619: WHERE element_type_id = p_element_type_id
620: AND trunc(sysdate) BETWEEN trunc(nvl(start_date_active, sysdate))
621: AND trunc(nvl(end_date_active, sysdate));
622:

Line 639: FROM CS_KB_ELEMENT_TYPES_B

635:
636: ELSE
637: -- IF type exists
638: SELECT COUNT(*) INTO l_count
639: FROM CS_KB_ELEMENT_TYPES_B
640: WHERE element_type_id = p_element_type_id;
641:
642: IF(l_count <1) THEN
643: FND_MSG_PUB.initialize;

Line 816: FROM cs_kb_element_types_b

812: --SEDATE
813: l_dummy VARCHAR2(1) := null;
814: CURSOR check_active_type_csr(p_element_type_id IN NUMBER) Is
815: SELECT 'X'
816: FROM cs_kb_element_types_b
817: WHERE element_type_id = p_element_type_id
818: AND trunc(sysdate) BETWEEN trunc(nvl(start_date_active, sysdate))
819: AND trunc(nvl(end_date_active, sysdate));
820:

Line 846: FROM CS_KB_ELEMENT_TYPES_B

842: ELSE
843:
844: -- IF type exists
845: SELECT COUNT(*) INTO l_count
846: FROM CS_KB_ELEMENT_TYPES_B
847: WHERE element_type_id = p_element_type_id;
848:
849: IF(l_count <1) THEN
850: X_RETURN := -2;