Unable to default positions DFF value to Job Requisition DFF using SQL

Summary:

I'm trying to default certain DFF values which already exists on the position page. Our requirement is that whenever a requisition of type position is raised then the values in the job requisition DFF should be defaulted using the SQL.

Below is the SQL snippet which I'm trying to default using SQL in Job Requisition DFF.

SELECT ATTRIBUTE1 FROM HR_ALL_POSITIONS_F

Please let me know if the above snippet needs to be amended to fulfill the requirement?

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):