eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PER_BF_BALANCE_ELEMENTS_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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