APPS.AHL_DI_ASSO_DOC_ASO_PVT dependencies on AHL_DOC_REVISIONS_B

Line 29: FROM AHL_DOC_REVISIONS_B

25: CURSOR get_doc_status(c_doc_revision_id NUMBER)
26: IS
27: SELECT REVISION_STATUS_CODE,
28: OBSOLETE_DATE
29: FROM AHL_DOC_REVISIONS_B
30:
31: WHERE DOC_REVISION_ID = c_doc_revision_id;
32:
33: --Cursor to retrieve Aso Object Type Code

Line 71: FROM AHL_DOC_REVISIONS_B

67: --
68: CURSOR get_rev_det(c_doc_revision_id NUMBER)
69: IS
70: SELECT revision_no
71: FROM AHL_DOC_REVISIONS_B
72: WHERE DOC_REVISION_ID = c_doc_revision_id;
73: --
74: CURSOR get_operation_status(c_operation_id NUMBER)
75: IS