Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.FF_FORMULAS_F_FV |
SELECT B.ROW_ID
, B.FORMULA_ID
, B.EFFECTIVE_START_DATE
, B.EFFECTIVE_END_DATE
, B.BUSINESS_GROUP_ID
, B.LEGISLATION_CODE
, B.FORMULA_TYPE_ID
, B.BASE_FORMULA_NAME
, B.DESCRIPTION BASE_DESCRIPTION
, B.FORMULA_NAME
, B.DESCRIPTION
, B.FORMULA_TEXT
, B.STICKY_FLAG
, B.COMPILE_FLAG
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREATED_BY
, B.CREATION_DATE
, NVL(HR_GENERAL.DECODE_LOOKUP('FORMULA_TYPE'
, FTY.FORMULA_TYPE_NAME)
, FTY.FORMULA_TYPE_NAME) FORMULA_TYPE
, DECODE(CPI.FORMULA_ID
, NULL
, 'N'
, 'Y') VERIFIED
FROM FF_FORMULAS_F_VL B
, FF_FORMULA_TYPES FTY
, FF_COMPILED_INFO_F CPI
, FND_SESSIONS SES
WHERE FTY.FORMULA_TYPE_ID = B.FORMULA_TYPE_ID
AND CPI.FORMULA_ID (+) = B.FORMULA_ID
AND CPI.EFFECTIVE_START_DATE (+) = B.EFFECTIVE_START_DATE
AND SES.SESSION_ID = USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN B.EFFECTIVE_START_DATE
AND B.EFFECTIVE_END_DATE