Product: | HXC - Time and Labor Engine |
---|---|
Description: | |
Implementation/DBA Data: | APPS.HXC_APPROVAL_STYLES_V |
SELECT APS.BUSINESS_GROUP_ID
, APS.LEGISLATION_CODE
, APS.APPROVAL_STYLE_ID
, APS.NAME
, APS.DESCRIPTION
, APS.OBJECT_VERSION_NUMBER
, NVL(APS.RUN_RECIPIENT_EXTENSIONS
, 'Y') RUN_RECIPIENT_EXTENSIONS
, APS.ADMIN_ROLE
, APS.ERROR_ADMIN_ROLE
, HXC_NOTIFICATION_HELPER.HAS_TIMEOUT_NOTIFICATIONS(APS.APPROVAL_STYLE_ID) TIMEOUTS_ENABLED
, HXC_NOTIFICATION_HELPER.NUMBER_TIMEOUT_RETRIES_ANY(APS.APPROVAL_STYLE_ID) NUMBER_RETRIES
, HXC_NOTIFICATION_HELPER.APPROVER_TIMEOUT_VALUE(APS.APPROVAL_STYLE_ID) APPROVER_TIMEOUT
, HXC_NOTIFICATION_HELPER.PREPARER_TIMEOUT_VALUE(APS.APPROVAL_STYLE_ID) PREPARER_TIMEOUT
, HXC_NOTIFICATION_HELPER.ADMIN_TIMEOUT_VALUE(APS.APPROVAL_STYLE_ID) ADMIN_TIMEOUT
, HXC_NOTIFICATION_HELPER.NOTIFY_SUP_FOR_APPROVAL(APS.APPROVAL_STYLE_ID) NOTIFY_SUPERVISOR
, HXC_NOTIFICATION_HELPER.NOTIFY_WORKER_SUBMISSION(APS.APPROVAL_STYLE_ID) NOTIFY_WORKER_ON_SUBMIT
, HXC_NOTIFICATION_HELPER.NOTIFY_WORKER_AUTO_APPROVE(APS.APPROVAL_STYLE_ID) NOTIFY_WORKER_ON_AA
, HXC_NOTIFICATION_HELPER.NOTIFY_PREPARER_APPROVE(APS.APPROVAL_STYLE_ID) NOTIFY_PREPARER_APPROVED
, HXC_NOTIFICATION_HELPER.NOTIFY_PREPARER_REJECT(APS.APPROVAL_STYLE_ID) NOTIFY_PREPARER_REJECTED
, HXC_NOTIFICATION_HELPER.NOTIFY_PREPARER_TRANSFER(APS.APPROVAL_STYLE_ID) NOTIFY_PREPARER_TRANSFER
, APS.CREATED_BY
, APS.CREATION_DATE
, APS.LAST_UPDATED_BY
, APS.LAST_UPDATE_DATE
, APS.LAST_UPDATE_LOGIN
FROM HXC_APPROVAL_STYLES APS