This content has been marked as final. Show 4 replies
These are stored in the Lookup Type 'IRC_PROFESSIONAL_AREA'.
Find the query to get the Professional Area data in vacacancy creation.
Select * from FND_LOOKUP_VALUES_VL where LOOKUP_TYPE LIKE 'IRC_PROFESSIONAL_AREA'
thanks for the information but are how is it actually mapped to a vacancy information.
for ex: if i have vacancy with id 111 how would i map it to fnd_lookup_values to get the professional area for vacancy 111.
you can get mapping of professional area and vacancy using this query
select object_id, professional_area from irc_search_criteria; where object_id is vancancy_id.