APPS.CS_KB_ELEMENTS_AUDIT_PKG dependencies on CS_KB_CAT_GROUP_DENORM

Line 992: CS_KB_CAT_GROUP_DENORM d

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
996: AND c.Category_id = d.Child_Category_id

Line 1005: CS_KB_CAT_GROUP_DENORM d

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
1009: AND c.Category_id = d.Child_Category_id

Line 1022: CS_KB_CAT_GROUP_DENORM d

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
1026: AND c.Category_id = d.Child_Category_id

Line 1052: CS_KB_CAT_GROUP_DENORM denorm

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'
1056: AND setb.Status <> 'OBS'

Line 1063: CS_KB_CAT_GROUP_DENORM denorm2

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'
1067: AND setb2.Set_id = setcat2.Set_id