APPS.AHL_DI_ASSO_DOC_GEN_PVT dependencies on AHL_DOC_TITLE_ASSOS_TL

Line 693: DELETE FROM AHL_DOC_TITLE_ASSOS_TL

689: DELETE FROM AHL_DOC_TITLE_ASSOS_B
690: WHERE doc_title_asso_id = p_association_rec.doc_title_asso_id;
691: --
692: -- Delete the record from document associations Trans table
693: DELETE FROM AHL_DOC_TITLE_ASSOS_TL
694: WHERE doc_title_asso_id = p_association_rec.doc_title_asso_id;
695: --
696: */
697: --Standard check for commit;

Line 912: FROM AHL_DOC_TITLE_ASSOS_TL

908: subject,
909: page,
910: figure,
911: note
912: FROM AHL_DOC_TITLE_ASSOS_TL
913: WHERE doc_title_asso_id = c_doc_title_asso_id
914: FOR UPDATE OF doc_title_asso_id NOWAIT;
915: ---------- for update only
916: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_ASSOCIATION';

Line 2267: FROM AHL_DOC_TITLE_ASSOS_TL

2263: END IF;
2264:
2265: -- Knocking off all doc associations from the particular ASO object...
2266: DELETE
2267: FROM AHL_DOC_TITLE_ASSOS_TL
2268: WHERE DOC_TITLE_ASSO_ID IN (
2269: SELECT DOC_TITLE_ASSO_ID
2270: FROM AHL_DOC_TITLE_ASSOS_B
2271: WHERE aso_object_type_code = p_aso_object_type_code and