APPS.DOM_DOCUMENT_UTIL dependencies on DOM_DOC_REV_VERSIONS

Line 239: FROM dom_doc_rev_versions

235: rev.lifecycle_tracking_id = p_change_id;
236:
237:
238: SELECT status_code INTO l_approval_status
239: FROM dom_doc_rev_versions
240: WHERE version_id = (
241: SELECT max(version_id)
242: FROM dom_doc_rev_versions
243: WHERE revision_id = (SELECT revision_id FROM dom_document_revisions WHERE lifecycle_tracking_id = p_change_id));

Line 242: FROM dom_doc_rev_versions

238: SELECT status_code INTO l_approval_status
239: FROM dom_doc_rev_versions
240: WHERE version_id = (
241: SELECT max(version_id)
242: FROM dom_doc_rev_versions
243: WHERE revision_id = (SELECT revision_id FROM dom_document_revisions WHERE lifecycle_tracking_id = p_change_id));
244:
245:
246:

Line 303: UPDATE dom_doc_rev_versions SET STATUS_CODE = l_approval_status

299: END IF;
300: END;
301: END IF;
302:
303: UPDATE dom_doc_rev_versions SET STATUS_CODE = l_approval_status
304: WHERE version_id =
305: (SELECT version_id FROM dom_doc_rev_versions
306: WHERE creation_date = (
307: SELECT Max(ver.creation_date) FROM dom_doc_rev_versions ver, dom_document_revisions rev

Line 305: (SELECT version_id FROM dom_doc_rev_versions

301: END IF;
302:
303: UPDATE dom_doc_rev_versions SET STATUS_CODE = l_approval_status
304: WHERE version_id =
305: (SELECT version_id FROM dom_doc_rev_versions
306: WHERE creation_date = (
307: SELECT Max(ver.creation_date) FROM dom_doc_rev_versions ver, dom_document_revisions rev
308: WHERE ver.revision_id = rev.revision_id
309: AND rev.revision_id = ver.revision_id

Line 307: SELECT Max(ver.creation_date) FROM dom_doc_rev_versions ver, dom_document_revisions rev

303: UPDATE dom_doc_rev_versions SET STATUS_CODE = l_approval_status
304: WHERE version_id =
305: (SELECT version_id FROM dom_doc_rev_versions
306: WHERE creation_date = (
307: SELECT Max(ver.creation_date) FROM dom_doc_rev_versions ver, dom_document_revisions rev
308: WHERE ver.revision_id = rev.revision_id
309: AND rev.revision_id = ver.revision_id
310: AND rev.lifecycle_tracking_id = p_change_id));
311: