VIEW: APPS.PAY_ACTION_PARAMETERS

Source

View Text - Preformatted

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)))

View Text - HTML Formatted

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)))