APPS.AHL_DI_DOC_REVISION_PUB dependencies on AHL_DOC_REVISIONS_B

Line 860: FROM AHL_DOC_REVISIONS_B

856: -- FP For Bug #8410484
857: CURSOR get_current_effective_date (c_doc_revision_id NUMBER,c_document_id NUMBER)
858: IS
859: SELECT effective_date
860: FROM AHL_DOC_REVISIONS_B
861: WHERE doc_revision_id = c_doc_revision_id
862: AND document_id = c_document_id;
863: --FP end
864:

Line 1091: ahl_doc_revisions_b

1087: FND_MSG_PUB.ADD;
1088: ELSE
1089: -- select the current revision date. the edited date cannot be less than that.
1090: SELECT REVISION_DATE INTO l_current_revision_date from
1091: ahl_doc_revisions_b
1092: where
1093: ahl_doc_revisions_b.doc_revision_id = p_x_revision_tbl(i).doc_revision_id
1094: and
1095: ahl_doc_revisions_b.document_id = p_x_revision_tbl(i).document_id;

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

1089: -- select the current revision date. the edited date cannot be less than that.
1090: SELECT REVISION_DATE INTO l_current_revision_date from
1091: ahl_doc_revisions_b
1092: where
1093: ahl_doc_revisions_b.doc_revision_id = p_x_revision_tbl(i).doc_revision_id
1094: and
1095: ahl_doc_revisions_b.document_id = p_x_revision_tbl(i).document_id;
1096:
1097: IF p_x_revision_tbl(i).revision_date < l_current_revision_date

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

1091: ahl_doc_revisions_b
1092: where
1093: ahl_doc_revisions_b.doc_revision_id = p_x_revision_tbl(i).doc_revision_id
1094: and
1095: ahl_doc_revisions_b.document_id = p_x_revision_tbl(i).document_id;
1096:
1097: IF p_x_revision_tbl(i).revision_date < l_current_revision_date
1098: THEN
1099: FND_MESSAGE.SET_NAME('AHL','AHL_DI_REVDT_LESS_PREVDATE');