213: , l_language
214: , l_text
215: FROM
216: ENG_CHANGE_IMTEXT_TL eitl
217: , ENG_ENGINEERING_CHANGES eec
218: WHERE
219: eitl.rowid = p_rowid
220: and eitl.change_id = eec.change_id
221: and eitl.language in(select language_code
538: EEC.CREATED_BY ,
539: EEC.CREATION_DATE ,
540: EEC.LAST_UPDATED_BY ,
541: EEC.LAST_UPDATE_DATE ,
542: EEC.LAST_UPDATE_LOGIN FROM ENG_ENGINEERING_CHANGES EEC
543: WHERE
544: CHANGE_ID = p_change_id ) EEC, FND_LANGUAGES FLA
545: WHERE FLA.INSTALLED_FLAG IN ('I','B');
546: END IF;