APPS.AHL_DI_ASSO_DOC_GEN_PVT dependencies on AHL_DOC_REVISIONS_B

Line 25: FROM AHL_DOCUMENTS_B D, AHL_DOC_REVISIONS_B R

21: as
22: CURSOR get_rev_dat(c_document_id NUMBER, c_doc_revision_id NUMBER)
23: IS
24: SELECT DOCUMENT_NO, REVISION_NO
25: FROM AHL_DOCUMENTS_B D, AHL_DOC_REVISIONS_B R
26: WHERE D.DOCUMENT_ID = R.DOCUMENT_ID
27: AND R.DOC_REVISION_ID = c_doc_revision_id
28: AND D.DOCUMENT_ID = c_document_id;
29:

Line 96: FROM AHL_DOC_REVISIONS_B

92: IS
93: SELECT REVISION_STATUS_CODE,
94: OBSOLETE_DATE,
95: REVISION_NO
96: FROM AHL_DOC_REVISIONS_B
97: WHERE DOC_REVISION_ID = c_doc_revision_id;
98:
99: l_Rev_rec1 get_rev_dat%rowtype;
100:

Line 177: FROM AHL_DOC_REVISIONS_B

173: --Cursor To get revision status code
174: CURSOR get_revision_status_code(c_doc_revision_id NUMBER)
175: IS
176: SELECT revision_status_code
177: FROM AHL_DOC_REVISIONS_B
178: WHERE doc_revision_id = c_doc_revision_id;
179:
180: -- Cursor to get MC status
181: CURSOR get_mc_status(c_relationship_id NUMBER)

Line 552: FROM ahl_doc_revisions_b

548: THEN
549: -- If use latest = 'Y' then
550: -- Validate that the revision to be associated is the latest revision
551: SELECT MAX(doc_revision_id) INTO l_latest_doc_revision_id
552: FROM ahl_doc_revisions_b
553: WHERE NVL(effective_date,revision_date) = (SELECT MAX(NVL(effective_date,revision_date))
554: FROM ahl_doc_revisions_b
555: WHERE document_id = p_document_id
556: AND NVL(effective_date,revision_date) <= SYSDATE

Line 554: FROM ahl_doc_revisions_b

550: -- Validate that the revision to be associated is the latest revision
551: SELECT MAX(doc_revision_id) INTO l_latest_doc_revision_id
552: FROM ahl_doc_revisions_b
553: WHERE NVL(effective_date,revision_date) = (SELECT MAX(NVL(effective_date,revision_date))
554: FROM ahl_doc_revisions_b
555: WHERE document_id = p_document_id
556: AND NVL(effective_date,revision_date) <= SYSDATE
557: AND revision_status_code = 'CURRENT')
558: AND document_id = p_document_id