Problem with (before/after) image - GoldenGate 12c

Hi Experts,

I am trying to map table A (source) to table B (target) with the help of another lookup table C (target). 

Mapping is something like : Source  ---->  Target

S_ORG_EXT      ------->      CDS_COMPANY  (straight forward insert/update/delete - one to one mapping)

S_DOC_QUOTE   ------->  CDS_QUOTE (For Insert & Update need to check the value from CDS_COMPANY)

Basically, we are using CDS_COMPANY as look up table here. Insert went fine. But problem is with update.

I have created one procedure which will fetch the current data before update the value, based on a condition.