APPS.IBE_M_MIGRATION_PVT dependencies on IBC_CONTENT_ITEMS

Line 976: FROM ibc_content_items a, ibc_citem_version_labels b

972:
973: CURSOR c_get_content_item_csr(c_item_ref_code VARCHAR2,
974: c_label_code VARCHAR2) IS
975: SELECT a.content_item_id, b.citem_version_id
976: FROM ibc_content_items a, ibc_citem_version_labels b
977: WHERE a.item_reference_code = c_item_ref_code
978: AND a.content_item_id = b.content_item_id
979: AND b.label_code = c_label_code;
980:

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 990: FROM ibc_content_items

986: AND b.citem_version_status = IBC_UTILITIES_PUB.G_STV_APPROVED;
987:
988: CURSOR c_get_content_item(c_item_ref_code VARCHAR2) IS
989: SELECT content_item_id
990: FROM ibc_content_items
991: WHERE item_reference_code = c_item_ref_code;
992:
993: CURSOR c_get_lgl_phys_map_id_csr IS
994: SELECT IBE_DSP_LGL_PHYS_MAP_S1.nextval

Line 1412: FROM ibc_content_items

1408: l_list_flag VARCHAR2(1);
1409: l_item_id NUMBER;
1410: CURSOR c_get_content_item(c_item_ref_code VARCHAR2) IS
1411: SELECT content_item_id, creation_date
1412: FROM ibc_content_items
1413: WHERE item_reference_code = c_item_ref_code;
1414:
1415: BEGIN
1416: SAVEPOINT process_content_items;