DBA Data[Home] [Help]

APPS.IBC_CITEM_RUNTIME_PUB dependencies on IBC_CONTENT_ITEMS

Line 210: from IBC_ASSOCIATIONS a, IBC_CONTENT_ITEMS c

206: l_invalid_input VARCHAR2(1) := FND_API.g_false;
207: --
208: CURSOR Get_Citems_By_Assoc_Ctype IS
209: select c.CONTENT_ITEM_ID
210: from IBC_ASSOCIATIONS a, IBC_CONTENT_ITEMS c
211: where a.ASSOCIATION_TYPE_CODE = p_association_type_code
212: and a.ASSOCIATED_OBJECT_VAL1 = p_associated_object_val1
213: and NVL(a.ASSOCIATED_OBJECT_VAL2, '0') = NVL(p_associated_object_val2, '0')
214: and NVL(a.ASSOCIATED_OBJECT_VAL3, '0') = NVL(p_associated_object_val3, '0')