SQL query used as value set for unposting Job Requisition

Summary:

DEFAULT FOR IRC_REQ_REQUISITION_NUMBER IS 'NA'

CONDITION_RESULT = 'N'
REQ_COUNT=0

COUNT = COUNT_JOBAPPS_ACTIVE_IN_PHASE_STATE(IRC_REQ_REQUISITION_NUMBER, 'Offer', 'Accepted', 'US')
REQ_ID = GET_CONTEXT(IRC_JOB_REQUISITION_ID,1)

IF (REQ_ID > 1) THEN
(
REQ_COUNT= to_number(GET_VALUE_SET('Requisition_Unpost_VS','|=P_REQUISITION_ID='''||to_char(REQ_ID)||''''))

IF (COUNT = REQ_COUNT ) THEN
(
CONDITION_RESULT = 'Y'
)
)

RETURN CONDITION_RESULT

Content (please ensure you mask any confidential information):

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

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