APPS.AHL_DI_ASSO_DOC_GEN_PUB dependencies on AHL_DOC_TITLE_ASSOS_B

Line 67: FROM AHL_DOC_TITLE_ASSOS_B a, AHL_DOC_TITLE_ASSOS_TL B

63: AS
64: Cursor GetDocDet(C_DOC_TITLE_ASSO_ID NUMBER)
65: IS
66: SELECT A.*,B.CHAPTER,B.SECTION,B.SUBJECT,B.PAGE,B.FIGURE,B.NOTE
67: FROM AHL_DOC_TITLE_ASSOS_B a, AHL_DOC_TITLE_ASSOS_TL B
68: WHERE A.DOC_TITLE_ASSO_ID=B.DOC_TITLE_ASSO_ID
69: AND A.DOC_TITLE_ASSO_ID=C_DOC_TITLE_ASSO_ID
70: AND B.LANGUAGE=USERENV('LANG');
71: