View: PER_BF_BALANCES_V

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

View Text

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

Columns