Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAYBV_INPUT_VALUE |
SELECT PIVT.NAME
, PIV.EFFECTIVE_START_DATE
, PIV.EFFECTIVE_END_DATE
, PIV.LOOKUP_TYPE
, PIV.LEGISLATION_CODE
, PIV.DISPLAY_SEQUENCE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PIV.GENERATE_DB_ITEMS_FLAG) GENERATE_DB_ITEMS_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PIV.HOT_DEFAULT_FLAG) HOT_DEFAULT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PIV.MANDATORY_FLAG) MANDATORY_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('UNITS'
, PIV.UOM) UOM
, PIV.DEFAULT_VALUE
, PIV.LEGISLATION_SUBGROUP
, PIV.MAX_VALUE
, PIV.MIN_VALUE
, HR_BIS.BIS_DECODE_LOOKUP('WARNING_ERROR'
, PIV.WARNING_OR_ERROR) WARNING_OR_ERROR
, PIV.WARNING_OR_ERROR WARNING_OR_ERROR_CODE
, PIV.GENERATE_DB_ITEMS_FLAG GENERATE_DB_ITEMS_FLAG_CODE
, PIV.HOT_DEFAULT_FLAG HOT_DEFAULT_FLAG_CODE
, PIV.MANDATORY_FLAG MANDATORY_FLAG_CODE
, PIV.UOM UOM_CODE
, PIV.INPUT_VALUE_ID
, PIV.ELEMENT_TYPE_ID
, PIV.BUSINESS_GROUP_ID
, PIV.FORMULA_ID
, PIV.VALUE_SET_ID
, PIV.LAST_UPDATE_DATE
, PIV.LAST_UPDATED_BY
, PIV.LAST_UPDATE_LOGIN
, PIV.CREATED_BY
, PIV.CREATION_DATE
, PIV.OBJECT_VERSION_NUMBER
, 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
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') WITH READ ONLY