0
0
SELECT
HAPT.NAME,
HAPT.DESCRIPTION,
HRPB.TASK_FILE_NAME TaskName,
HRPB.TXN_MODULE_IDENTIFIER,
HAPT.CATEGORY_NAME,
HRPB.CATEGORY_CODE,
HAPT.SUBCATEGORY_NAME,
HRPB.SUBCATEGORY_CODE,
HRPB.FAMILY,
DECODE(HAAO.APPROVAL_DISABLED,'true','Bypassed','false','Enabled') "Enabled Status"
FROM
FUSION.HRC_ARM_PROCESS_B HRPB,
FUSION.HRC_ARM_PROCESS_TL HAPT,
FUSION.HRC_ARM_APPROVAL_OPTIONS HAAO
WHERE
HRPB.PROCESS_ID = HAAO.PROCESS_ID
AND HRPB.PROCESS_ID = HAPT.PROCESS_ID
AND HAPT.LANGUAGE = 'US'
AND HRPB.FAMILY = 'HCM'
ORDER BY 1
I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.