View: PER_BF_BALANCE_ELEMENTS_V

Product:	PER - Human Resources
Description:
Implementation/DBA Data:	APPS.PER_BF_BALANCE_ELEMENTS_V

View Text

SELECT BBT.BALANCE_TYPE_ID
, INV.NAME
, PET.ELEMENT_NAME
, PET.REPORTING_NAME
, PET.OUTPUT_CURRENCY_CODE
, INV.UOM
, INV.INPUT_VALUE_ID
, PET.ELEMENT_TYPE_ID
FROM PAY_ELEMENT_TYPES_F PET
, PAY_INPUT_VALUES_F INV
, PER_BF_BALANCE_TYPES BBT
WHERE BBT.INPUT_VALUE_ID = INV.INPUT_VALUE_ID
AND INV.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND TRUNC(SYSDATE) BETWEEN INV.EFFECTIVE_START_DATE
AND INV.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE WITH READ ONLY

Columns