APPS.AHL_FMP_MR_REVISION_PVT dependencies on AHL_DOC_TITLE_ASSOS_B

Line 283: from AHL_DOC_TITLE_ASSOS_B A,AHL_DOC_TITLE_ASSOS_TL B

279: b.subject,
280: b.page,
281: b.figure,
282: b.note
283: from AHL_DOC_TITLE_ASSOS_B A,AHL_DOC_TITLE_ASSOS_TL B
284: where A.ASO_OBJECT_TYPE_CODE='MR'
285: AND A.ASO_OBJECT_ID=p_source_mr_header_id
286: and A.doc_title_asso_id=B.doc_title_asso_id
287: AND B.LANGUAGE=USERENV('LANG')

Line 719: SELECT AHL_DOC_TITLE_ASSOS_B_S.Nextval INTO

715:
716: for l_association_rec in CurGetDocTitledet
717: loop
718:
719: SELECT AHL_DOC_TITLE_ASSOS_B_S.Nextval INTO
720: l_doc_title_asso_id from DUAL;
721:
722:
723: AHL_DOC_TITLE_ASSOS_PKG.INSERT_ROW(