SELECT HR_BIS.BIS_DECODE_LOOKUP('IRC_CONSIDERATION',IVC.CONSIDERATION_STATUS) , IVC.CONSIDERATION_STATUS , IVC.PARTY_ID , IVC.VACANCY_ID , IVC.VACANCY_CONSIDERATION_ID , IVC.PERSON_ID , IVC.LAST_UPDATE_DATE , IVC.LAST_UPDATED_BY , IVC.LAST_UPDATE_LOGIN , IVC.CREATED_BY , IVC.CREATION_DATE FROM IRC_VACANCY_CONSIDERATIONS IVC WITH READ ONLY
SELECT HR_BIS.BIS_DECODE_LOOKUP('IRC_CONSIDERATION'
, IVC.CONSIDERATION_STATUS)
, IVC.CONSIDERATION_STATUS
, IVC.PARTY_ID
, IVC.VACANCY_ID
, IVC.VACANCY_CONSIDERATION_ID
, IVC.PERSON_ID
, IVC.LAST_UPDATE_DATE
, IVC.LAST_UPDATED_BY
, IVC.LAST_UPDATE_LOGIN
, IVC.CREATED_BY
, IVC.CREATION_DATE
FROM IRC_VACANCY_CONSIDERATIONS IVC WITH READ ONLY
|
|
|