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 868: FROM AHL_DOCUMENTS_B

864:
865: CURSOR get_doc_num(c_document_id NUMBER)
866: IS
867: SELECT document_no
868: FROM AHL_DOCUMENTS_B
869: WHERE document_id = c_document_id;
870: --
871: ---------- for update only
872: -- To get the existing record

Line 1507: FROM AHL_DOCUMENTS_B

1503: --
1504: CURSOR get_doc_num(c_document_id NUMBER)
1505: IS
1506: SELECT document_no
1507: FROM AHL_DOCUMENTS_B
1508: WHERE document_id = c_document_id;
1509: --
1510: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_ASSOC_REC';
1511: l_api_version CONSTANT NUMBER := 1.0;