For more information, please refer to this announcement explaining best practices for getting answers to questions.
Can we restrict Job requisitions LOV's input parameters for Job Applicatio Report to Hiring Manager?
Summary:
Hiring Managers should only be able to run the Job Application report for the Requisitions they are listed as the Hiring Manager whereas Recruiters should have access to run the Job Application report for all job requisitions.
If anyone has faced similar requirement, Can you please provide your comments?
Currently we are restricting the List of values available for selection by making changes at Data model level.
List of values
Query for REQ(Requisition Name):
select distinct
TITLE
from
IRC_REQUISITIONS_VL
where 1=1
and OBJECT_STATUS = 'ORA_ACTIVE'
and (RECRUITER_ID = (select distinct person_id from per_users where user_guid = FND_GLOBAL.user_guid) or