VIEW: HR.PAY_LATEST_BALANCES#

Source

View Text - Preformatted

select LATEST_BALANCE_ID LATEST_BALANCE_ID, DEFINED_BALANCE_ID DEFINED_BALANCE_ID, ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID, VALUE VALUE, PERSON_ID PERSON_ID, ASSIGNMENT_ID ASSIGNMENT_ID, EXPIRY_DATE EXPIRY_DATE, EXPIRED_ASSIGNMENT_ACTION_ID EXPIRED_ASSIGNMENT_ACTION_ID, EXPIRED_VALUE EXPIRED_VALUE, EXPIRED_DATE EXPIRED_DATE, PREV_ASSIGNMENT_ACTION_ID PREV_ASSIGNMENT_ACTION_ID, PREV_BALANCE_VALUE PREV_BALANCE_VALUE, PREV_EXPIRY_DATE PREV_EXPIRY_DATE, TAX_UNIT_ID TAX_UNIT_ID, JURISDICTION_CODE JURISDICTION_CODE, ORIGINAL_ENTRY_ID ORIGINAL_ENTRY_ID, SOURCE_ID SOURCE_ID, SOURCE_TEXT SOURCE_TEXT, SOURCE_TEXT2 SOURCE_TEXT2, SOURCE_NUMBER SOURCE_NUMBER, TAX_GROUP TAX_GROUP, PAYROLL_ID PAYROLL_ID, PROCESS_GROUP_ID PROCESS_GROUP_ID, SOURCE_NUMBER2 SOURCE_NUMBER2, LOCAL_UNIT_ID LOCAL_UNIT_ID, ORGANIZATION_ID ORGANIZATION_ID, INSTANCE_ID INSTANCE_ID from "HR"."PAY_LATEST_BALANCES"

View Text - HTML Formatted

SELECT LATEST_BALANCE_ID LATEST_BALANCE_ID
, DEFINED_BALANCE_ID DEFINED_BALANCE_ID
, ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, VALUE VALUE
, PERSON_ID PERSON_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, EXPIRY_DATE EXPIRY_DATE
, EXPIRED_ASSIGNMENT_ACTION_ID EXPIRED_ASSIGNMENT_ACTION_ID
, EXPIRED_VALUE EXPIRED_VALUE
, EXPIRED_DATE EXPIRED_DATE
, PREV_ASSIGNMENT_ACTION_ID PREV_ASSIGNMENT_ACTION_ID
, PREV_BALANCE_VALUE PREV_BALANCE_VALUE
, PREV_EXPIRY_DATE PREV_EXPIRY_DATE
, TAX_UNIT_ID TAX_UNIT_ID
, JURISDICTION_CODE JURISDICTION_CODE
, ORIGINAL_ENTRY_ID ORIGINAL_ENTRY_ID
, SOURCE_ID SOURCE_ID
, SOURCE_TEXT SOURCE_TEXT
, SOURCE_TEXT2 SOURCE_TEXT2
, SOURCE_NUMBER SOURCE_NUMBER
, TAX_GROUP TAX_GROUP
, PAYROLL_ID PAYROLL_ID
, PROCESS_GROUP_ID PROCESS_GROUP_ID
, SOURCE_NUMBER2 SOURCE_NUMBER2
, LOCAL_UNIT_ID LOCAL_UNIT_ID
, ORGANIZATION_ID ORGANIZATION_ID
, INSTANCE_ID INSTANCE_ID
FROM "HR"."PAY_LATEST_BALANCES"