VIEW: APPS.FFBV_FORMULA

Source

View Text - Preformatted

SELECT ff.FORMULA_NAME ,ff.EFFECTIVE_START_DATE ,ff.EFFECTIVE_END_DATE ,ff.LEGISLATION_CODE ,ff.DESCRIPTION ,ff.FORMULA_TEXT ,hr_bis.bis_decode_lookup('YES_NO', ff.STICKY_FLAG) STICKY_FLAG ,hr_bis.bis_decode_lookup('YES_NO', ff.COMPILE_FLAG) COMPILE_FLAG ,ff.STICKY_FLAG STICKY_FLAG_CODE ,ff.COMPILE_FLAG COMPILE_FLAG_CODE ,ff.FORMULA_ID ,ff.BUSINESS_GROUP_ID ,ff.FORMULA_TYPE_ID ,ff.LAST_UPDATED_BY ,ff.LAST_UPDATE_LOGIN ,ff.LAST_UPDATE_DATE ,ff.CREATED_BY ,ff.CREATION_DATE ,CASE WHEN ((ff.business_group_id IS NULL AND ff.legislation_code IS NULL) OR (ff.business_group_id IS NULL AND ff.legislation_code = NVL(hr_bis.get_legislation_code,ff.legislation_code)) OR (ff.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, ff.business_group_id))) THEN 'Y' ELSE 'N' END bg_security_flag_code FROM FF_FORMULAS_F ff WITH READ ONLY

View Text - HTML Formatted

SELECT FF.FORMULA_NAME
, FF.EFFECTIVE_START_DATE
, FF.EFFECTIVE_END_DATE
, FF.LEGISLATION_CODE
, FF.DESCRIPTION
, FF.FORMULA_TEXT
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, FF.STICKY_FLAG) STICKY_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, FF.COMPILE_FLAG) COMPILE_FLAG
, FF.STICKY_FLAG STICKY_FLAG_CODE
, FF.COMPILE_FLAG COMPILE_FLAG_CODE
, FF.FORMULA_ID
, FF.BUSINESS_GROUP_ID
, FF.FORMULA_TYPE_ID
, FF.LAST_UPDATED_BY
, FF.LAST_UPDATE_LOGIN
, FF.LAST_UPDATE_DATE
, FF.CREATED_BY
, FF.CREATION_DATE
, CASE WHEN ((FF.BUSINESS_GROUP_ID IS NULL
AND FF.LEGISLATION_CODE IS NULL) OR (FF.BUSINESS_GROUP_ID IS NULL
AND FF.LEGISLATION_CODE = NVL(HR_BIS.GET_LEGISLATION_CODE
, FF.LEGISLATION_CODE)) OR (FF.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, FF.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM FF_FORMULAS_F FF WITH READ ONLY