DBA Data[Home] [Help] [Dependency Information]

VIEW: HR.PAY_BATCH_HEADERS#

Object Details
Object Name: PAY_BATCH_HEADERS#
Object Type: VIEW
Owner: HR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (15) Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
BATCH_NAME VARCHAR2 (30) Yes
BATCH_STATUS VARCHAR2 (30) Yes
ACTION_IF_EXISTS VARCHAR2 (30)
BATCH_REFERENCE VARCHAR2 (30)
BATCH_SOURCE VARCHAR2 (150)
COMMENTS VARCHAR2 (2000)
DATE_EFFECTIVE_CHANGES VARCHAR2 (30)
PURGE_AFTER_TRANSFER VARCHAR2 (30)
REJECT_IF_FUTURE_CHANGES VARCHAR2 (30)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

OBJECT_VERSION_NUMBER NUMBER (9)
REJECT_IF_RESULTS_EXISTS VARCHAR2 (30)
PURGE_AFTER_ROLLBACK VARCHAR2 (30)
REJECT_ENTRY_NOT_REMOVED VARCHAR2 (30)
ROLLBACK_ENTRY_UPDATES VARCHAR2 (30)
BATCH_TYPE VARCHAR2 (30)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BATCH_ID
,      BUSINESS_GROUP_ID
,      BATCH_NAME
,      BATCH_STATUS
,      ACTION_IF_EXISTS
,      BATCH_REFERENCE
,      BATCH_SOURCE
,      COMMENTS
,      DATE_EFFECTIVE_CHANGES
,      PURGE_AFTER_TRANSFER
,      REJECT_IF_FUTURE_CHANGES
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      REJECT_IF_RESULTS_EXISTS
,      PURGE_AFTER_ROLLBACK
,      REJECT_ENTRY_NOT_REMOVED
,      ROLLBACK_ENTRY_UPDATES
,      BATCH_TYPE
FROM HR.PAY_BATCH_HEADERS#;

Dependencies

[top of page]

HR.PAY_BATCH_HEADERS# references the following:

SchemaHR
TablePAY_BATCH_HEADERS
HR.PAY_BATCH_HEADERS# is referenced by following:

SchemaAPPS
SynonymPAY_BATCH_HEADERS
TriggerPAY_BATCH_HEADERS_OVN
TriggerPAY_BATCH_HEADERS_WHO
TriggerSET_HXT_BATCH_STATES_INS