AR_OVRDUE/FCAMOUNT SQL looks wrong
Hi, all.
Don't know that this SQL is causing us any problems, but it looks wrong compared to similar SQL in other steps in the same App Engine Section.
For FCAMT1 the following SQL is coded:
UPDATE %Table(OC_ITEM1_TAO)
SET OC_AMT = %RoundCurrency(%SQL(ARFNCHRG$FCAMOUNT), BAL_CURRENCY )
WHERE PROCESS_INSTANCE = %Bind(PROCESS_INSTANCE)
AND (EXISTS (
SELECT 'X'
FROM %Table(OC_TBL_TAO)
WHERE INCL_OC_IN_CALC = 'Y'
AND OC_RATE_TYPE IN ('P','S')
AND PROCESS_INSTANCE = %Bind(PROCESS_INSTANCE)
AND OC_PROMPT_SETID = %Table(OC_ITEM1_TAO).OC_PROMPT_SETID
AND OC_ID = %Table(OC_ITEM1_TAO).OC_ID)