VIEW: APPS.PAYBV_INPUT_VALUE

Source

View Text - Preformatted

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

View Text - HTML Formatted

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