View: PAY_ACTION_PARAMETERS

Product:	PAY - Payroll
Description:	Shows current Action Parameters for processes
Implementation/DBA Data:	APPS.PAY_ACTION_PARAMETERS

View Text

SELECT PAPV.PARAMETER_NAME
, PAPV.PARAMETER_VALUE
FROM PAY_ACTION_PARAMETER_VALUES PAPV
WHERE NVL(PAY_CORE_UTILS.GET_PAP_GROUP_ID
, -1) = NVL(PAPV.ACTION_PARAMETER_GROUP_ID
, -2) OR (PAPV.ACTION_PARAMETER_GROUP_ID IS NULL
AND NOT EXISTS (SELECT NULL
FROM PAY_ACTION_PARAMETER_VALUES PAPV2
WHERE PAPV2.PARAMETER_NAME = PAPV.PARAMETER_NAME
AND PAPV2.ACTION_PARAMETER_GROUP_ID IS NOT NULL
AND PAPV2.ACTION_PARAMETER_GROUP_ID = NVL(PAY_CORE_UTILS.GET_PAP_GROUP_ID
, -1)))

Columns