APPS.CS_KB_SECURITY_PVT dependencies on CS_KB_SET_CATEGORIES
Line 2975: FROM CS_KB_SET_CATEGORIES SC,
2971: AND sysdate BETWEEN nvl(Vis.Start_Date_Active, sysdate-1)
2972: AND nvl(Vis.End_Date_Active , sysdate+1)
2973: )
2974: AND EXISTS (SELECT 'x' 2975: FROM CS_KB_SET_CATEGORIES SC, 2976: CS_KB_CAT_GROUP_DENORM D
2977: WHERE SC.Set_id = S.Set_id
2978: AND D.Category_Group_Id = v_cat_grp
2979: AND SC.Category_id = D.Child_Category_id