APPS.AHL_DI_DOC_REVISION_PUB dependencies on AHL_DOC_REVISIONS_B

Line 1070: ahl_doc_revisions_b

1066: FND_MSG_PUB.ADD;
1067: ELSE
1068: -- select the current revision date. the edited date cannot be less than that.
1069: SELECT REVISION_DATE INTO l_current_revision_date from
1070: ahl_doc_revisions_b
1071: where
1072: ahl_doc_revisions_b.doc_revision_id = p_x_revision_tbl(i).doc_revision_id
1073: and
1074: ahl_doc_revisions_b.document_id = p_x_revision_tbl(i).document_id;

Line 1072: ahl_doc_revisions_b.doc_revision_id = p_x_revision_tbl(i).doc_revision_id

1068: -- select the current revision date. the edited date cannot be less than that.
1069: SELECT REVISION_DATE INTO l_current_revision_date from
1070: ahl_doc_revisions_b
1071: where
1072: ahl_doc_revisions_b.doc_revision_id = p_x_revision_tbl(i).doc_revision_id
1073: and
1074: ahl_doc_revisions_b.document_id = p_x_revision_tbl(i).document_id;
1075:
1076: IF p_x_revision_tbl(i).revision_date < l_current_revision_date

Line 1074: ahl_doc_revisions_b.document_id = p_x_revision_tbl(i).document_id;

1070: ahl_doc_revisions_b
1071: where
1072: ahl_doc_revisions_b.doc_revision_id = p_x_revision_tbl(i).doc_revision_id
1073: and
1074: ahl_doc_revisions_b.document_id = p_x_revision_tbl(i).document_id;
1075:
1076: IF p_x_revision_tbl(i).revision_date < l_current_revision_date
1077: THEN
1078: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REVDT_LESS_PREVDATE');