APPS.AHL_FMP_MR_REVISION_PVT dependencies on AHL_DOC_TITLE_ASSOS_B

Line 289: from AHL_DOC_TITLE_ASSOS_B A,AHL_DOC_TITLE_ASSOS_TL B

285: b.subject,
286: b.page,
287: b.figure,
288: b.note
289: from AHL_DOC_TITLE_ASSOS_B A,AHL_DOC_TITLE_ASSOS_TL B
290: where A.ASO_OBJECT_TYPE_CODE='MR'
291: AND A.ASO_OBJECT_ID=p_source_mr_header_id
292: and A.doc_title_asso_id=B.doc_title_asso_id
293: AND B.LANGUAGE=USERENV('LANG')

Line 871: SELECT AHL_DOC_TITLE_ASSOS_B_S.Nextval INTO

867:
868: for l_association_rec in CurGetDocTitledet
869: loop
870:
871: SELECT AHL_DOC_TITLE_ASSOS_B_S.Nextval INTO
872: l_doc_title_asso_id from DUAL;
873:
874:
875: AHL_DOC_TITLE_ASSOS_PKG.INSERT_ROW(