APPS.CS_KB_SOLUTION_PVT dependencies on CS_KB_SET_TYPES_B

Line 755: select 'X' from cs_kb_set_types_b

751: l_dummy VARCHAR2(1) := null;
752: l_vis_count NUMBER;
753:
754: Cursor check_active_type_csr(p_type_id IN NUMBER) Is
755: select 'X' from cs_kb_set_types_b
756: where set_type_id = p_type_id
757: and trunc(sysdate) between trunc(nvl(start_date_active, sysdate))
758: and trunc(nvl(end_date_active, sysdate));
759:

Line 800: FROM CS_KB_SET_TYPES_B

796:
797: ELSE
798: -- IF type exists
799: SELECT COUNT(*) INTO l_count
800: FROM CS_KB_SET_TYPES_B
801: WHERE set_type_id = p_set_type_id;
802:
803: IF(l_count <1) THEN
804: FND_MSG_PUB.initialize;

Line 1002: select 'X' from cs_kb_set_types_b

998:
999: --SEDATE
1000: l_dummy VARCHAR2(1) := null;
1001: Cursor check_active_type_csr(p_type_id IN NUMBER) Is
1002: select 'X' from cs_kb_set_types_b
1003: where set_type_id = p_type_id
1004: and trunc(sysdate) between trunc(nvl(start_date_active, sysdate))
1005: and trunc(nvl(end_date_active, sysdate));
1006:

Line 1048: FROM CS_KB_SET_TYPES_B

1044: p_data => X_MSG_DATA);
1045: ELSE
1046:
1047: SELECT COUNT(*) INTO l_count
1048: FROM CS_KB_SET_TYPES_B
1049: WHERE set_type_id = p_set_type_id;
1050:
1051: IF(l_count <1) THEN
1052: FND_MSG_PUB.initialize;