APPS.JTF_FM_MD_MIGRATION_PVT dependencies on JTF_FM_QUERY_MES

Line 563: SELECT QUERY_ID from JTF_FM_QUERY_MES where MES_DOC_ID = c_item_id;

559: AND file_id IS NOT NULL;
560:
561: -- Check if this document has an associated query
562: CURSOR c_get_query_csr(c_item_id NUMBER) IS
563: SELECT QUERY_ID from JTF_FM_QUERY_MES where MES_DOC_ID = c_item_id;
564:
565: -- Get the CITEM_ID for the associated QUERY, assuming it has already been migrated to OCM
566: CURSOR c_get_query_details_csr(c_query_id NUMBER) IS
567: SELECT CONTENT_ITEM_ID from JTF_FM_MIG_HISTORY_DETAILS where item_id = c_query_id;