APPS.AHL_DI_ASSO_DOCASO_PVT dependencies on AHL_DOC_TITLE_ASSOS_VL

Line 776: FROM AHL_DOC_TITLE_ASSOS_vl

772: c_page VARCHAR2,
773: c_figure VARCHAR2)
774: IS
775: SELECT DOC_TITLE_ASSO_ID,aso_object_id,aso_object_type_code,document_id,doc_revision_id
776: FROM AHL_DOC_TITLE_ASSOS_vl
777: WHERE aso_object_id = nvl(c_aso_object_id,0)
778: AND NVL(aso_object_type_code,'X') = NVL(c_aso_object_type_code,'X')
779: AND document_id = nvl(c_document_id,0)
780: AND nvl(doc_revision_id,0) = nvl(c_doc_revision_id,0)

Line 1137: FROM AHL_DOC_TITLE_ASSOS_vl

1133: c_page VARCHAR2,
1134: c_figure VARCHAR2)
1135: IS
1136: SELECT DOC_TITLE_ASSO_ID
1137: FROM AHL_DOC_TITLE_ASSOS_vl
1138: WHERE aso_object_id = nvl(c_aso_object_id,0)
1139: AND NVL(aso_object_type_code,'X') = NVL(c_aso_object_type_code,'X')
1140: AND document_id = nvl(c_document_id,0)
1141: AND nvl(doc_revision_id,0) = nvl(c_doc_revision_id,0)