DBA Data[Home] [Help]

APPS.IBE_M_IBC_INT_PVT dependencies on IBC_CITEM_VERSION_LABELS

Line 65: FROM ibc_citem_version_labels

61: RETURN VARCHAR2
62: IS
63: CURSOR c_get_live(c_citem_id NUMBER, c_item_version_id NUMBER) IS
64: SELECT 1
65: FROM ibc_citem_version_labels
66: WHERE citem_version_id = c_item_version_id
67: AND content_item_id = c_citem_id
68: AND label_code = 'IBE';
69: l_temp NUMBER;

Line 86: FROM ibc_citem_version_labels a, ibc_citem_versions_b b

82: RETURN NUMBER
83: IS
84: CURSOR c_get_live_version(c_citem_id NUMBER) IS
85: SELECT b.version_number
86: FROM ibc_citem_version_labels a, ibc_citem_versions_b b
87: WHERE a.citem_version_id = b.citem_version_id
88: AND a.content_item_id = c_citem_id
89: AND a.label_code = 'IBE';
90:

Line 366: FROM IBC_CITEM_VERSION_LABELS

362:
363: CURSOR c_label_flag(c_content_item_id NUMBER,
364: c_label_code VARCHAR2) IS
365: SELECT object_version_number
366: FROM IBC_CITEM_VERSION_LABELS
367: WHERE content_item_id = c_content_item_id
368: AND label_code = c_label_code;
369:
370: CURSOR c_associations_flag(c_content_item_id NUMBER,