View: PAY_NL_EMP_OTHER_ACTION_INFO_V

Product:	PAY - Payroll
Description:	View Used in Dutch Payslip Report
Implementation/DBA Data:	APPS.PAY_NL_EMP_OTHER_ACTION_INFO_V

View Text

SELECT PAI_NL_OED.ACTION_CONTEXT_ID ACTION_CONTEXT_ID
, PAI_NL_OED.ACTION_INFORMATION4 PAYROLL_ID
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI_NL_OED.ACTION_INFORMATION6) INDIVIDUAL_WORKING_HOURS
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI_NL_OED.ACTION_INFORMATION7) LEGAL_MIN_PAYMENT
, PAI_NL_OED.ACTION_INFORMATION8 SI_DAYS
FROM PAY_ACTION_INFORMATION PAI_NL_OED /* AIC ---- NL OTHER EMPLOYEE DETAILS */
WHERE /* AIC ---- NL OTHER EMPLOYEE DETAILS */ PAI_NL_OED.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI_NL_OED.ACTION_INFORMATION_CATEGORY = 'NL OTHER EMPLOYEE DETAILS'

Columns