DBA Data[Home] [Help]

APPS.PRP_IBC_INT_PVT dependencies on IBC_CONTENT_ITEMS

Line 28: IBC_CONTENT_ITEMS ICI,

24:
25: CURSOR Cur_Content_item_name(p_component_style_id NUMBER,p_association_type VARCHAR2) IS
26: SELECT ICV.Content_Item_Name
27: FROM IBC_CITEM_VERSIONS_VL ICV,
28: IBC_CONTENT_ITEMS ICI,
29: IBC_ASSOCIATIONS IBA
30: WHERE IBA.ASSOCIATION_TYPE_CODE = P_ASSOCIATION_TYPE_CODE
31: AND IBA.ASSOCIATED_OBJECT_VAL1 = p_component_style_id
32: AND ICI.CONTENT_ITEM_ID = IBA.CONTENT_ITEM_ID