APPS.IBE_M_MIGRATION_PVT dependencies on IBC_CITEM_VERSIONS_B

Line 983: FROM ibc_content_items a, ibc_citem_versions_b b

979: AND b.label_code = c_label_code;
980:
981: CURSOR c_get_item_version_csr(c_item_ref_code VARCHAR2) IS
982: SELECT a.content_item_id, b.citem_version_id
983: FROM ibc_content_items a, ibc_citem_versions_b b
984: WHERE a.item_reference_code = c_item_ref_code
985: AND a.content_item_id = b.citem_version_id
986: AND b.citem_version_status = IBC_UTILITIES_PUB.G_STV_APPROVED;
987:

Line 1010: FROM ibc_citem_versions_b

1006: AND attachment_id = -1;
1007:
1008: CURSOR c_get_version_number(c_citem_version_id NUMBER) IS
1009: SELECT version_number
1010: FROM ibc_citem_versions_b
1011: WHERE citem_version_id = c_citem_version_id;
1012:
1013: l_upsert_item VARCHAR2(1);
1014: l_label_associate_item VARCHAR2(1);