how to get the function_id of the hr_api_transactions
hi
Code:
SELECT hr_ameutil_ss.get_process_name(:transactionId)
FROM DUAL
this code give me the process name of one transactionId from hr_api_transactions, but i want to get the FUNCTION_ID column of that table(hr_api_transactions).
how can i find the function_id or something else related to SIT (that can seperate the type of the SIT or is uniqe aboat the SIT) from that table?
Regards,
-Keshani