View: PAYLV_INPUT_VALUE_V

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

View Text

SELECT PIVT.NAME
, PIV.INPUT_VALUE_ID
, PIV.EFFECTIVE_START_DATE
, PIV.EFFECTIVE_END_DATE
, CASE WHEN ((PIV.BUSINESS_GROUP_ID IS NULL
AND PIV.LEGISLATION_CODE IS NULL) OR (PIV.BUSINESS_GROUP_ID IS NULL
AND PIV.LEGISLATION_CODE = NVL(HR_BIS.GET_LEGISLATION_CODE
, PIV.LEGISLATION_CODE)) OR (PIV.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PIV.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
, PIVT.NAME ORDER_BY
FROM PAY_INPUT_VALUES_F PIV
, PAY_INPUT_VALUES_F_TL PIVT
WHERE PIV.INPUT_VALUE_ID = PIVT.INPUT_VALUE_ID
AND PIVT.LANGUAGE = USERENV('LANG') UNION ALL SELECT NULL
, -1
, HR_GENERAL.START_OF_TIME
, HR_GENERAL.END_OF_TIME
, 'Y'
, ' ' ORDER_BY
FROM DUAL WITH READ ONLY

Columns