DBA Data[Home] [Help]

VIEW: APPS.IRCBV_VACANCY_CONSIDERAT_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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