How to Get Translated Value in Peoplecode

How to Get Translated Value in Peoplecode

How to get translate value form page

&VALUELong = Record.Field.LongTranslateValue;

How to get translate value by sql of table translate value

SELECT XLATLONGNAME FROM PSXLATITEM WHERE FIELDNAME =’FIELD_NAME’