View: FFBV_FORMULA

Product:	FF - FastFormula
Description:	Discoverer view for ff_formulas_f
Implementation/DBA Data:	APPS.FFBV_FORMULA

View Text

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 ((HR_BIS.GET_SEC_PROFILE_BG_ID IS NOT NULL
AND (FF.BUSINESS_GROUP_ID = HR_BIS.GET_SEC_PROFILE_BG_ID OR FF.LEGISLATION_CODE = HR_API.RETURN_LEGISLATION_CODE(HR_BIS.GET_SEC_PROFILE_BG_ID))) OR (HR_BIS.GET_SEC_PROFILE_BG_ID IS NULL)) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM FF_FORMULAS_F FF WITH READ ONLY

Columns