APPS.CS_KB_SOLUTION_PVT dependencies on CS_KB_SET_TYPES_B

Line 741: select 'X' from cs_kb_set_types_b

737: l_dummy VARCHAR2(1) := null;
738: l_vis_count NUMBER;
739:
740: Cursor check_active_type_csr(p_type_id IN NUMBER) Is
741: select 'X' from cs_kb_set_types_b
742: where set_type_id = p_type_id
743: and trunc(sysdate) between trunc(nvl(start_date_active, sysdate))
744: and trunc(nvl(end_date_active, sysdate));
745:

Line 786: FROM CS_KB_SET_TYPES_B

782:
783: ELSE
784: -- IF type exists
785: SELECT COUNT(*) INTO l_count
786: FROM CS_KB_SET_TYPES_B
787: WHERE set_type_id = p_set_type_id;
788:
789: IF(l_count <1) THEN
790: FND_MSG_PUB.initialize;

Line 988: select 'X' from cs_kb_set_types_b

984:
985: --SEDATE
986: l_dummy VARCHAR2(1) := null;
987: Cursor check_active_type_csr(p_type_id IN NUMBER) Is
988: select 'X' from cs_kb_set_types_b
989: where set_type_id = p_type_id
990: and trunc(sysdate) between trunc(nvl(start_date_active, sysdate))
991: and trunc(nvl(end_date_active, sysdate));
992:

Line 1034: FROM CS_KB_SET_TYPES_B

1030: p_data => X_MSG_DATA);
1031: ELSE
1032:
1033: SELECT COUNT(*) INTO l_count
1034: FROM CS_KB_SET_TYPES_B
1035: WHERE set_type_id = p_set_type_id;
1036:
1037: IF(l_count <1) THEN
1038: FND_MSG_PUB.initialize;