APPS.IBE_M_IBC_INT_PVT dependencies on IBC_CITEM_VERSIONS_B

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 137: FROM ibc_citem_versions_b a

133: RETURN NUMBER
134: IS
135: CURSOR c_get_aval_status(c_citem_id NUMBER) IS
136: SELECT MAX(a.version_number)
137: FROM ibc_citem_versions_b a
138: WHERE a.citem_version_status = 'APPROVED'
139: AND a.content_item_id = c_citem_id;
140: l_version_number NUMBER;
141: BEGIN

Line 157: FROM ibc_citem_versions_b a

153: RETURN NUMBER
154: IS
155: CURSOR c_get_aval_status(c_citem_id NUMBER) IS
156: SELECT MAX(a.citem_version_id)
157: FROM ibc_citem_versions_b a
158: WHERE a.citem_version_status = 'APPROVED'
159: AND a.content_item_id = c_citem_id;
160: l_citem_version_id NUMBER;
161: BEGIN

Line 350: FROM ibc_citem_versions_b

346: r_cv_label_rec Ibc_Cv_Label_Grp.CV_Label_Rec_Type;
347: CURSOR c_get_version_id(c_content_item_id NUMBER,
348: c_version_number NUMBER) IS
349: SELECT citem_version_id
350: FROM ibc_citem_versions_b
351: WHERE content_item_id = c_content_item_id
352: AND version_number = c_version_number;
353:
354: l_assoc_val1 VARCHAR2(254);