SELECT vac.name vacancy_name ,hr_bis.bis_decode_lookup('IRC_VARIABLE_COMP_ELEMENT' , vce.variable_comp_lookup) compensation_object ,vce.variable_comp_lookup compensation_object_code ,vce.object_version_number version_number ,vce.vacancy_id vacancy_id FROM irc_variable_comp_elements vce ,per_all_vacancies vac WHERE vac.vacancy_id = vce.vacancy_id WITH READ ONLY
SELECT VAC.NAME VACANCY_NAME
, HR_BIS.BIS_DECODE_LOOKUP('IRC_VARIABLE_COMP_ELEMENT'
, VCE.VARIABLE_COMP_LOOKUP) COMPENSATION_OBJECT
, VCE.VARIABLE_COMP_LOOKUP COMPENSATION_OBJECT_CODE
, VCE.OBJECT_VERSION_NUMBER VERSION_NUMBER
, VCE.VACANCY_ID VACANCY_ID
FROM IRC_VARIABLE_COMP_ELEMENTS VCE
, PER_ALL_VACANCIES VAC
WHERE VAC.VACANCY_ID = VCE.VACANCY_ID WITH READ ONLY
|
|
|