[Home] [Help]
758: and trunc(nvl(end_date_active, sysdate));
759:
760: Cursor Check_Visibility IS
761: SELECT count(*)
762: FROM CS_KB_VISIBILITIES_B
763: WHERE Visibility_Id = p_visibility_id
764: AND sysdate BETWEEN nvl(Start_Date_Active, sysdate-1)
765: AND nvl(End_Date_Active, sysdate+1);
766:
1010: and set_type_id = p_type_id;
1011:
1012: Cursor Check_Visibility IS
1013: SELECT count(*)
1014: FROM CS_KB_VISIBILITIES_B
1015: WHERE Visibility_Id = p_visibility_id
1016: AND sysdate BETWEEN nvl(Start_Date_Active, sysdate-1)
1017: AND nvl(End_Date_Active, sysdate+1);
1018: