APPS.AHL_DI_ASSO_DOCASO_PVT dependencies on AHL_DOCUMENTS_B

Line 455: FROM AHL_DOCUMENTS_B a,AHL_DOC_REVISIONS_B b

451:
452: CURSOR GetdocCount(c_document_no VARCHAR2)
453: IS
454: SELECT count(a.document_no)
455: FROM AHL_DOCUMENTS_B a,AHL_DOC_REVISIONS_B b
456: WHERE upper(a.document_no)=upper(c_document_no)
457: and a.document_id=b.document_id;
458:
459:

Line 566: FROM ahl_documents_b a ,AHL_DOC_REVISIONS_B b

562: IF l_check_flag='Y'
563: Then
564:
565: SELECT count(a.document_no) into l_counter3
566: FROM ahl_documents_b a ,AHL_DOC_REVISIONS_B b
567: WHERE A.DOCUMENT_ID=B.DOCUMENT_ID
568: AND upper(a.document_no)=upper(p_x_association_tbl(i).document_no);
569:
570: IF l_counter3=0

Line 742: FROM AHL_DOCUMENTS_B

738: -- Used to validate the document id
739: CURSOR check_doc_info(c_document_id NUMBER)
740: IS
741: SELECT 'X'
742: FROM AHL_DOCUMENTS_B
743: WHERE document_id = c_document_id;
744: --
745: CURSOR get_doc_det(c_document_id NUMBER)
746: IS

Line 748: FROM AHL_DOCUMENTS_B

744: --
745: CURSOR get_doc_det(c_document_id NUMBER)
746: IS
747: SELECT document_no
748: FROM AHL_DOCUMENTS_B
749: WHERE document_id = c_document_id;
750:
751: CURSOR get_operation_status(c_operation_id NUMBER)
752: IS