DBA Data[Home] [Help]

VIEW: APPS.PAY_NL_SUMMARY_ACTION_INFO_V

Source

View Text - Preformatted

SELECT PAI_NL_SUM.ACTION_CONTEXT_ID Action_Context_Id ,PAI_NL_SUM.ACTION_INFORMATION8 Element_Type ,PAI_NL_SUM.ACTION_INFORMATION12 Element_Value FROM PAY_ACTION_INFORMATION PAI_NL_SUM /* AIC ---- NL Calculations */ WHERE /* AIC ---- NL Calculations */ PAI_NL_SUM.ACTION_CONTEXT_TYPE = 'AAP' AND PAI_NL_SUM.ACTION_INFORMATION_CATEGORY = 'NL CALCULATIONS'
View Text - HTML Formatted

SELECT PAI_NL_SUM.ACTION_CONTEXT_ID ACTION_CONTEXT_ID
, PAI_NL_SUM.ACTION_INFORMATION8 ELEMENT_TYPE
, PAI_NL_SUM.ACTION_INFORMATION12 ELEMENT_VALUE
FROM PAY_ACTION_INFORMATION PAI_NL_SUM /* AIC ---- NL CALCULATIONS */
WHERE /* AIC ---- NL CALCULATIONS */ PAI_NL_SUM.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI_NL_SUM.ACTION_INFORMATION_CATEGORY = 'NL CALCULATIONS'