SELECT
A.APPR_REQ_ID,
A.SEQNO,
A.LOG_DTTM,
A.LOG_ENTRY_TYPE_FLG,
A.USER_ID,
A.CHAR_VAL_FK1,
B.FIRST_NAME,
B.LAST_NAME
FROM CI_APPR_REQ_LOG A,
SC_USER B
WHERE A.APPR_REQ_ID = :INSERT_REQUEST_ID
AND A.USER_ID = B.USER_ID
uploaded by Nuno Rodrigues