APPS.AHL_DI_ASSO_DOC_GEN_PVT dependencies on AHL_DOCUMENTS_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 128: FROM AHL_DOCUMENTS_B

124: -- Used to validate the document id
125: CURSOR check_doc_info(c_document_id NUMBER)
126: IS
127: SELECT 'X'
128: FROM AHL_DOCUMENTS_B
129: WHERE document_id = c_document_id;
130: --
131: CURSOR get_doc_det(c_document_id NUMBER)
132: IS

Line 134: FROM AHL_DOCUMENTS_B

130: --
131: CURSOR get_doc_det(c_document_id NUMBER)
132: IS
133: SELECT document_no
134: FROM AHL_DOCUMENTS_B
135: WHERE document_id = c_document_id;
136:
137: CURSOR get_operation_status(c_operation_id NUMBER)
138: IS

Line 720: FROM AHL_DOCUMENTS_B

716:
717: CURSOR get_doc_num(c_document_id NUMBER)
718: IS
719: SELECT document_no
720: FROM AHL_DOCUMENTS_B
721: WHERE document_id = c_document_id;
722: --
723: ---------- for update only
724: -- To get the existing record

Line 1350: FROM AHL_DOCUMENTS_B

1346: --
1347: CURSOR get_doc_num(c_document_id NUMBER)
1348: IS
1349: SELECT document_no
1350: FROM AHL_DOCUMENTS_B
1351: WHERE document_id = c_document_id;
1352: --
1353: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_ASSOC_REC';
1354: l_api_version CONSTANT NUMBER := 1.0;