DBA Data[Home] [Help]

APPS.CS_KB_SOLUTION_PVT dependencies on CS_KB_VISIBILITIES_B

Line 748: FROM CS_KB_VISIBILITIES_B

744: and trunc(nvl(end_date_active, sysdate));
745:
746: Cursor Check_Visibility IS
747: SELECT count(*)
748: FROM CS_KB_VISIBILITIES_B
749: WHERE Visibility_Id = p_visibility_id
750: AND sysdate BETWEEN nvl(Start_Date_Active, sysdate-1)
751: AND nvl(End_Date_Active, sysdate+1);
752:

Line 1000: FROM CS_KB_VISIBILITIES_B

996: and set_type_id = p_type_id;
997:
998: Cursor Check_Visibility IS
999: SELECT count(*)
1000: FROM CS_KB_VISIBILITIES_B
1001: WHERE Visibility_Id = p_visibility_id
1002: AND sysdate BETWEEN nvl(Start_Date_Active, sysdate-1)
1003: AND nvl(End_Date_Active, sysdate+1);
1004: