View: PAY_ACTION_PARAMETERS_V1

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_ACTION_PARAMETERS_V1

View Text

SELECT PAPV.PARAMETER_NAME
, HR.MEANING
, DECODE(NVL(PAY_CORE_UTILS.GET_PAP_GROUP_ID
, -1)
, -1
, PAPV.PARAMETER_VALUE
, DECODE(NVL(PAPV.ACTION_PARAMETER_GROUP_ID
, -1)
, -1
, NULL
, PAPV.PARAMETER_VALUE))
, NVL(NVL(PAY_CORE_UTILS.GET_PAP_GROUP_ID
, PAPV.ACTION_PARAMETER_GROUP_ID)
, -1)
, DECODE(NVL(PAPV.ACTION_PARAMETER_GROUP_ID
, -1)
, -1
, PAPV.PARAMETER_VALUE
, NULL)
FROM PAY_ACTION_PARAMETER_VALUES PAPV
, HR_LOOKUPS HR
, FND_SESSIONS SESH
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 IN( PAPV.PARAMETER_NAME
, REPLACE(PAPV.PARAMETER_NAME
, ' '
, '_')
, REPLACE(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))))
AND HR.LOOKUP_TYPE = 'ACTION_PARAMETER_TYPE'
AND HR.LOOKUP_CODE IN (PAPV.PARAMETER_NAME
, REPLACE(PAPV.PARAMETER_NAME
, ' '
, '_')
, REPLACE(PAPV.PARAMETER_NAME
, '_'
, ' ') )
AND HR.ENABLED_FLAG = 'Y'
AND USERENV('SESSIONID') = SESH.SESSION_ID
AND SESH.EFFECTIVE_DATE BETWEEN NVL(HR.START_DATE_ACTIVE
, HR_GENERAL.START_OF_TIME)
AND NVL(HR.END_DATE_ACTIVE
, HR_GENERAL.END_OF_TIME)

Columns