APPS.IBC_CITEM_RUNTIME_PUB dependencies on IBC_ASSOCIATIONS

Line 61: from IBC_ASSOCIATIONS

57: l_item_found VARCHAR2(1) := FND_API.G_TRUE;
58: --
59: CURSOR Get_Citems_By_Assoc IS
60: select CONTENT_ITEM_ID
61: from IBC_ASSOCIATIONS
62: where ASSOCIATION_TYPE_CODE = p_association_type_code
63: and ASSOCIATED_OBJECT_VAL1 = p_associated_object_val1
64: and NVL(ASSOCIATED_OBJECT_VAL2, '0') = NVL(p_associated_object_val2, '0')
65: and NVL(ASSOCIATED_OBJECT_VAL3, '0') = NVL(p_associated_object_val3, '0')

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')