APPS.AMS_SCHEDULERULES_PVT dependencies on IBC_CITEMS_V

Line 212: FROM IBC_ASSOCIATIONS IbcAssn,ibc_citems_v citm

208: WHERE schedule_id = p_scheduleid;
209:
210: CURSOR C_Content_CL( l_obj_id IN NUMBER) IS
211: SELECT ibcassn.content_item_id,citm.name
212: FROM IBC_ASSOCIATIONS IbcAssn,ibc_citems_v citm
213: WHERE IbcAssn.ASSOCIATED_OBJECT_VAL1 = to_char(l_obj_id )
214: AND IbcAssn.Content_item_id = citm.citem_id
215: AND citm.item_status <> 'APPROVED'
216: AND ibcassn.ASSOCIATION_TYPE_CODE = 'AMS_CSCH' ;

Line 220: FROM IBC_ASSOCIATIONS IbcAssn,ibc_citems_v citm

216: AND ibcassn.ASSOCIATION_TYPE_CODE = 'AMS_CSCH' ;
217:
218: CURSOR C_Content_NDM( l_obj_id IN NUMBER) IS
219: SELECT ibcassn.content_item_id,citm.name
220: FROM IBC_ASSOCIATIONS IbcAssn,ibc_citems_v citm
221: WHERE IbcAssn.ASSOCIATED_OBJECT_VAL1 = to_char(l_obj_id )
222: AND IbcAssn.Content_item_id = citm.citem_id
223: AND citm.item_status <> 'APPROVED'
224: AND ibcassn.ASSOCIATION_TYPE_CODE = 'AMS_COLLAT'

Line 229: FROM IBC_ASSOCIATIONS IbcAssn,ibc_citems_v citm

225: AND citm.VERSION = 1 ;
226:
227: CURSOR C_Content_Exists( l_obj_id IN NUMBER) IS
228: SELECT count(1)
229: FROM IBC_ASSOCIATIONS IbcAssn,ibc_citems_v citm
230: WHERE IbcAssn.ASSOCIATED_OBJECT_VAL1 = to_char(l_obj_id )
231: AND IbcAssn.Content_item_id = citm.citem_id
232: AND ibcassn.ASSOCIATION_TYPE_CODE in ('AMS_CSCH') ;
233:

Line 236: FROM IBC_ASSOCIATIONS IbcAssn,ibc_citems_v citm

232: AND ibcassn.ASSOCIATION_TYPE_CODE in ('AMS_CSCH') ;
233:
234: CURSOR C_Content_Exists_NDM( l_obj_id IN NUMBER) IS
235: SELECT count(1)
236: FROM IBC_ASSOCIATIONS IbcAssn,ibc_citems_v citm
237: WHERE IbcAssn.ASSOCIATED_OBJECT_VAL1 = to_char(l_obj_id )
238: AND IbcAssn.Content_item_id = citm.citem_id
239: AND ibcassn.ASSOCIATION_TYPE_CODE in ('AMS_COLLAT') ;
240: