APPS.JTF_FM_OCM_REND_REQ dependencies on IBC_CITEMS_V

Line 398: SELECT ATTACH_FID INTO file_id FROM ibc_citems_v

394: ELSE
395:
396: --First get the approved CITEM_VER_ID for the given content ID.
397:
398: SELECT ATTACH_FID INTO file_id FROM ibc_citems_v
399: WHERE CITEM_VER_ID = p_citem_ver_id AND item_status = 'APPROVED'
400: and LANGUAGE = USERENV('LANG');
401:
402: END IF;

Line 1081: FROM IBC_CITEMS_V

1077: -- The following gets the max version regardless of any status;
1078: -- item_status or version_status
1079:
1080: SELECT MAX(CITEM_VER_ID) INTO x_item_version_id
1081: FROM IBC_CITEMS_V
1082: WHERE CITEM_ID = TO_NUMBER(p_content_id)
1083: AND LANGUAGE = USERENV('LANG') ;
1084:
1085: END IF;