APPS.AMS_ACTPRODUCT_PVT dependencies on IBC_CONTENT_ITEMS

Line 2442: FROM ibc_associations assoc, ibc_content_Items ci

2438: l_Return_status varchar2(20);
2439:
2440: CURSOR c_citem_assoc (l_csch_id IN NUMBER) IS
2441: SELECT assoc.association_id, assoc.content_item_id, ci.live_citem_version_id
2442: FROM ibc_associations assoc, ibc_content_Items ci
2443: --by musman:as per r12 requirement,live version stamping should be done for collab content
2444: WHERE assoc.association_type_code in ('AMS_PLCE') --('AMS_COLB','AMS_PLCE')
2445: AND assoc.associated_object_val1 = to_char(l_csch_id) --musman:bug 4145845 Fix
2446: AND assoc.content_item_id = ci.content_Item_id;

Line 2517: ibc_content_items citem

2513: IS
2514: cursor C_Content( l_sch_id IN NUMBER) IS
2515: SELECT count(*)
2516: FROM IBC_ASSOCIATIONS IbcAssn,
2517: ibc_content_items citem
2518: WHERE IbcAssn.ASSOCIATED_OBJECT_VAL1 = to_char(l_sch_id )-- musman:bug 4145845 Fix
2519: AND IbcAssn.Content_item_id = citem.content_item_id
2520: AND citem.content_item_status <> 'APPROVED'
2521: AND ibcassn.ASSOCIATION_TYPE_CODE in ('AMS_COLB','AMS_PLCE') ;