VIEW: APPS.PAY_ACTION_PARAMETERS_V1

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)