SELECT ADJ_TYPE_CD FROM CI_ADJ_TYPE WHERE APPR_PROF_CD=:INSERT_PROFILE_CODEuploaded by Nuno Rodrigues
SELECT T.ADJ_TYPE_CD,
TL.DESCR, T.*
FROM CI_ADJ_TYPE T,
CI_ADJ_TYPE_L TL
WHERE
T.ADJ_TYPE_CD = TL.ADJ_TYPE_CD
AND TL.LANGUAGE_CD = 'INSERT_LANGUAGE_CD_MOSTLY_ENG'
AND UPPER(T.ADJ_TYPE_CD) LIKE UPPER('INSERT_ADJUSTMENT_CODE')
ORDER BY T.ADJ_TYPE_CD
uploaded by Nuno Rodrigues