once create job requisition we need pass parameter for position in same screen to link it with flex
Summary:
Dear Oracle support,
Kindly note that once create job requisition we need pass parameter for position in same screen to link it with flex filed.
kindly find SQL we used on flex filed to call position in the Code Snippet:
Regards,
Mohammad Merie
Content (required):
Recruiting , DATA BASE Column
Version (include the version you are using, if applicable):
23B (11.13.23.04.0)
Code Snippet (add any code snippets that support your topic, if applicable):
select distinct NAME
from
HR_ALL_ORGANIZATION_UNITS_F a,
HR_ORGANIZATION_UNITS_F_TL b ,
HR_ALL_POSITIONS_F c
where
a.ORGANIZATION_ID=b.ORGANIZATION_ID