I'm very new to OAF. I have created an employee leave details self-service search page with options to search by different parameters. However, I don't know how to restrict this search only to the logged in user ID and not allow access to all employee leave details.
After browsing a lot, I got to know that we have to use one of these to get the value:
I got that, but how do I pass it to the SQL statement. Please advice. Thanks:
This is my SQL:
WITH h1 AS
(SELECTREPLACE(subject,'@Leave Of Absence for ') applicant,
INSTR(REPLACE(CONTEXT,'HRSSA:'),':', 1)- 1
FROM wf_notifications wn
WHERE wn.MESSAGE_TYPE ='HRSSA'
--AND WN.CONTEXT LIKE 'HRSSA:321552%'
AND wn.status ='OPEN'
AND wn.from_role <>'SYSADMIN'
ORDERBY wn.notification_id DESC),
FROM hr_api_transaction_steps has, hr_api_transaction_values hav
WHERE item_type ='HRSSA'
AND has.transaction_step_id = hav.transaction_step_id