DBA Data[Home] [Help]

APPS.AHL_DI_ASSO_DOC_ASO_PVT dependencies on AHL_DOC_TITLE_ASSOS_TL

Line 371: DELETE FROM AHL_DOC_TITLE_ASSOS_TL

367: DELETE FROM AHL_DOC_TITLE_ASSOS_B
368: WHERE doc_title_asso_id = p_association_rec.doc_title_asso_id;
369: --
370: -- Delete the record from document associations Trans table
371: DELETE FROM AHL_DOC_TITLE_ASSOS_TL
372: WHERE doc_title_asso_id = p_association_rec.doc_title_asso_id;
373: --
374: */
375: --Standard check for commit;

Line 1046: FROM AHL_DOC_TITLE_ASSOS_TL

1042: subject,
1043: page,
1044: figure,
1045: note
1046: FROM AHL_DOC_TITLE_ASSOS_TL
1047: WHERE doc_title_asso_id = c_doc_title_asso_id
1048: FOR UPDATE OF doc_title_asso_id NOWAIT;
1049: -- Used to check for duplicate records
1050: CURSOR dup_rec(c_aso_object_type_code VARCHAR2,