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_BALANCES_V

Source

View Text - Preformatted


SELECT bv.BALANCE_AMOUNT_ID ,bt.BALANCE_TYPE_ID ,pa.PROCESSED_ASSIGNMENT_ID ,pa.ASSIGNMENT_ID ,pyr.PAYROLL_RUN_ID ,pyr.PAYROLL_ID ,bt.BUSINESS_GROUP_ID ,bt.DISPLAYED_NAME ,bt.UOM ,bt.CATEGORY ,bv.YTD_AMOUNT ,bv.FYTD_AMOUNT ,bv.PTD_AMOUNT ,bv.MTD_AMOUNT ,bv.QTD_AMOUNT ,bv.RUN_AMOUNT ,pyr.PAYROLL_IDENTIFIER ,pyr.PERIOD_START_DATE ,pyr.PERIOD_END_DATE ,pyr.PROCESSING_DATE from per_bf_balance_types bt , per_bf_balance_amounts bv , per_bf_processed_assignments pa , per_bf_payroll_runs pyr WHERE bv.balance_type_id = bt.balance_type_id and bv.processed_assignment_id = pa.processed_assignment_id and pa.payroll_run_id = pyr.payroll_run_id

View Text - HTML Formatted

SELECT BV.BALANCE_AMOUNT_ID
, BT.BALANCE_TYPE_ID
, PA.PROCESSED_ASSIGNMENT_ID
, PA.ASSIGNMENT_ID
, PYR.PAYROLL_RUN_ID
, PYR.PAYROLL_ID
, BT.BUSINESS_GROUP_ID
, BT.DISPLAYED_NAME
, BT.UOM
, BT.CATEGORY
, BV.YTD_AMOUNT
, BV.FYTD_AMOUNT
, BV.PTD_AMOUNT
, BV.MTD_AMOUNT
, BV.QTD_AMOUNT
, BV.RUN_AMOUNT
, PYR.PAYROLL_IDENTIFIER
, PYR.PERIOD_START_DATE
, PYR.PERIOD_END_DATE
, PYR.PROCESSING_DATE
FROM PER_BF_BALANCE_TYPES BT
, PER_BF_BALANCE_AMOUNTS BV
, PER_BF_PROCESSED_ASSIGNMENTS PA
, PER_BF_PAYROLL_RUNS PYR
WHERE BV.BALANCE_TYPE_ID = BT.BALANCE_TYPE_ID
AND BV.PROCESSED_ASSIGNMENT_ID = PA.PROCESSED_ASSIGNMENT_ID
AND PA.PAYROLL_RUN_ID = PYR.PAYROLL_RUN_ID