SELECT HR_BIS.BIS_DECODE_LOOKUP('IRC_VARIABLE_COMP_ELEMENT',VCE.VARIABLE_COMP_LOOKUP) , VCE.VARIABLE_COMP_LOOKUP , VCE.VACANCY_ID , VCE.LAST_UPDATE_DATE , VCE.LAST_UPDATED_BY , VCE.LAST_UPDATE_LOGIN , VCE.CREATED_BY , VCE.CREATION_DATE FROM IRC_VARIABLE_COMP_ELEMENTS VCE WITH READ ONLY
SELECT HR_BIS.BIS_DECODE_LOOKUP('IRC_VARIABLE_COMP_ELEMENT'
, VCE.VARIABLE_COMP_LOOKUP)
, VCE.VARIABLE_COMP_LOOKUP
, VCE.VACANCY_ID
, VCE.LAST_UPDATE_DATE
, VCE.LAST_UPDATED_BY
, VCE.LAST_UPDATE_LOGIN
, VCE.CREATED_BY
, VCE.CREATION_DATE
FROM IRC_VARIABLE_COMP_ELEMENTS VCE WITH READ ONLY
|
|
|