APPS.CS_KB_ELEMENTS_AUDIT_PKG dependencies on CS_KB_SET_CATEGORIES

Line 991: CS_KB_SET_CATEGORIES c,

987: CURSOR Get_Current_Cat_Group_Solns IS
988: SELECT distinct s.Set_id, s.Set_Number
989: FROM CS_KB_SETS_B s,
990: CS_KB_SET_ELES e,
991: CS_KB_SET_CATEGORIES c,
992: CS_KB_CAT_GROUP_DENORM d
993: WHERE s.Set_id = e.Set_Id
994: AND e.Element_id = P_ELEMENT_ID
995: AND s.Set_id = c.Set_id

Line 1004: CS_KB_SET_CATEGORIES c,

1000: CURSOR Get_Curr_CG_Solns_Upd_Stmt (v_dup_id IN NUMBER) IS
1001: SELECT distinct s.Set_id, s.Set_Number
1002: FROM CS_KB_SETS_B s,
1003: CS_KB_SET_ELES e,
1004: CS_KB_SET_CATEGORIES c,
1005: CS_KB_CAT_GROUP_DENORM d
1006: WHERE s.Set_id = e.Set_Id
1007: AND e.Element_id = P_ELEMENT_ID
1008: AND s.Set_id = c.Set_id

Line 1021: CS_KB_SET_CATEGORIES c,

1017: CURSOR Get_Curr_CG_Solns_Rem_Stmt (v_dup_id IN NUMBER) IS
1018: SELECT distinct s.Set_id, s.Set_Number
1019: FROM CS_KB_SETS_B s,
1020: CS_KB_SET_ELES e,
1021: CS_KB_SET_CATEGORIES c,
1022: CS_KB_CAT_GROUP_DENORM d
1023: WHERE s.Set_id = e.Set_Id
1024: AND e.Element_id = P_ELEMENT_ID
1025: AND s.Set_id = c.Set_id

Line 1051: CS_KB_SET_CATEGORIES setcat,

1047: AND s.Status <> 'OBS'
1048: AND s.Set_Id IN (SELECT setb.Set_Id
1049: FROM CS_KB_SETS_B setb,
1050: CS_KB_SET_ELES setele,
1051: CS_KB_SET_CATEGORIES setcat,
1052: CS_KB_CAT_GROUP_DENORM denorm
1053: WHERE setb.set_id = setele.Set_Id
1054: AND setele.Element_id = e.Element_id
1055: AND setb.Latest_Version_Flag = 'Y'

Line 1062: CS_KB_SET_CATEGORIES setcat2,

1058: AND setcat.Category_id = denorm.Child_Category_id
1059: AND denorm.Category_Group_Id <> CS_KB_SECURITY_PVT.Get_Category_Group_Id
1060: AND NOT EXISTS (SELECT 'x'
1061: FROM CS_KB_SETS_B setb2,
1062: CS_KB_SET_CATEGORIES setcat2,
1063: CS_KB_CAT_GROUP_DENORM denorm2
1064: WHERE setb2.set_id = setb.Set_Id
1065: AND setb2.Latest_Version_Flag = 'Y'
1066: AND setb2.Status <> 'OBS'