APPS.IBC_STYLESHEETS_GRP dependencies on IBC_CONTENT_ITEMS

Line 23: from IBC_CONTENT_ITEMS

19: l_content_item_status VARCHAR2(30);
20: --
21: CURSOR Get_Citem IS
22: select LIVE_CITEM_VERSION_ID, CONTENT_ITEM_STATUS
23: from IBC_CONTENT_ITEMS
24: where content_item_id = p_stylesheet_item_id;
25:
26: BEGIN
27: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 248: from IBC_STYLESHEETS s, IBC_CONTENT_ITEMS i

244: l_stylesheet_id NUMBER;
245: --
246: CURSOR Get_StyleSheet_Id IS
247: select s.CONTENT_ITEM_ID
248: from IBC_STYLESHEETS s, IBC_CONTENT_ITEMS i
249: where i.CONTENT_ITEM_ID = p_content_item_id
250: and i.CONTENT_TYPE_CODE = s.CONTENT_TYPE_CODE
251: and s.DEFAULT_STYLESHEET_FLAG = FND_API.G_TRUE;
252:

Line 336: from IBC_STYLESHEETS s, IBC_CONTENT_ITEMS i

332: l_stylesheet_id NUMBER;
333: --
334: CURSOR Get_StyleSheet_Id IS
335: select s.CONTENT_ITEM_ID
336: from IBC_STYLESHEETS s, IBC_CONTENT_ITEMS i
337: where i.CONTENT_ITEM_ID = p_content_item_id
338: and i.CONTENT_TYPE_CODE = s.CONTENT_TYPE_CODE
339: and s.DEFAULT_STYLESHEET_FLAG = FND_API.G_TRUE;
340:

Line 485: from IBC_CONTENT_ITEMS

481: l_stylesheet_id NUMBER;
482: --
483: CURSOR Get_StyleSheet_Id IS
484: select CONTENT_ITEM_ID
485: from IBC_CONTENT_ITEMS
486: where ITEM_REFERENCE_CODE = p_stylesheet_ref_code;
487:
488: BEGIN
489: -- ******* Standard Begins ********

Line 588: from IBC_STYLESHEETS s, IBC_CONTENT_ITEMS i

584: --
585: CURSOR Get_StyleSheet_Ids IS
586: select s.CONTENT_ITEM_ID, p_stylesheets_label_code as LABEL,
587: userenv('LANG') as LANG
588: from IBC_STYLESHEETS s, IBC_CONTENT_ITEMS i
589: where i.CONTENT_ITEM_ID = p_content_item_id
590: and i.CONTENT_TYPE_CODE = s.CONTENT_TYPE_CODE;
591:
592: BEGIN