VIEW: HR.PAY_RUN_BALANCES#

Source

View Text - Preformatted

select RUN_BALANCE_ID RUN_BALANCE_ID, DEFINED_BALANCE_ID DEFINED_BALANCE_ID, EFFECTIVE_DATE EFFECTIVE_DATE, BALANCE_VALUE BALANCE_VALUE, ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID, ASSIGNMENT_ID ASSIGNMENT_ID, ACTION_SEQUENCE ACTION_SEQUENCE, PAYROLL_ACTION_ID PAYROLL_ACTION_ID, TAX_UNIT_ID TAX_UNIT_ID, JURISDICTION_CODE JURISDICTION_CODE, JURISDICTION_COMP1 JURISDICTION_COMP1, JURISDICTION_COMP2 JURISDICTION_COMP2, JURISDICTION_COMP3 JURISDICTION_COMP3, SOURCE_ID SOURCE_ID, SOURCE_TEXT SOURCE_TEXT, TAX_GROUP TAX_GROUP, SOURCE_NUMBER SOURCE_NUMBER, SOURCE_TEXT2 SOURCE_TEXT2, SOURCE_NUMBER2 SOURCE_NUMBER2, TIME_DEFINITION_ID TIME_DEFINITION_ID, BALANCE_DATE BALANCE_DATE, LOCAL_UNIT_ID LOCAL_UNIT_ID, ORGANIZATION_ID ORGANIZATION_ID, INSTANCE_ID INSTANCE_ID from "HR"."PAY_RUN_BALANCES"

View Text - HTML Formatted

SELECT RUN_BALANCE_ID RUN_BALANCE_ID
, DEFINED_BALANCE_ID DEFINED_BALANCE_ID
, EFFECTIVE_DATE EFFECTIVE_DATE
, BALANCE_VALUE BALANCE_VALUE
, ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, ACTION_SEQUENCE ACTION_SEQUENCE
, PAYROLL_ACTION_ID PAYROLL_ACTION_ID
, TAX_UNIT_ID TAX_UNIT_ID
, JURISDICTION_CODE JURISDICTION_CODE
, JURISDICTION_COMP1 JURISDICTION_COMP1
, JURISDICTION_COMP2 JURISDICTION_COMP2
, JURISDICTION_COMP3 JURISDICTION_COMP3
, SOURCE_ID SOURCE_ID
, SOURCE_TEXT SOURCE_TEXT
, TAX_GROUP TAX_GROUP
, SOURCE_NUMBER SOURCE_NUMBER
, SOURCE_TEXT2 SOURCE_TEXT2
, SOURCE_NUMBER2 SOURCE_NUMBER2
, TIME_DEFINITION_ID TIME_DEFINITION_ID
, BALANCE_DATE BALANCE_DATE
, LOCAL_UNIT_ID LOCAL_UNIT_ID
, ORGANIZATION_ID ORGANIZATION_ID
, INSTANCE_ID INSTANCE_ID
FROM "HR"."PAY_RUN_BALANCES"