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


TABLE: HR.PAY_PROCESS_GROUPS

Object Details
Object Name: PAY_PROCESS_GROUPS
Object Type: TABLE
Owner: HR
FND Design Data: TablePAY.PAY_PROCESS_GROUPS
Subobject Name:
Status: VALID


PAY_PROCESS_GROUPS defines a group of processes. This
provides an easier method of enabling and disabling related
processes.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PAY_PROCESS_GROUPS_PK
  1. ColumnPROCESS_GROUP_ID
Indexes
Index Type Uniqueness Tablespace Column
PAY_PROCESS_GROUPS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROCESS_GROUP_ID
Columns
Name Datatype Length Mandatory Comments
PROCESS_GROUP_ID NUMBER
Yes System-generated primary key column.
GROUP_NAME VARCHAR2 (30) Yes Name of the Processing Group
BUSINESS_GROUP_ID NUMBER (15)
Foreign Key to HR_ORGANIZATION_UNITS.
LEGISLATION_CODE VARCHAR2 (30)
Foreign Key to FND_TERRITORIES.
DESCRIPTION VARCHAR2 (80)
Free text description for user entry.
Query Text

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


SELECT PROCESS_GROUP_ID
,      GROUP_NAME
,      BUSINESS_GROUP_ID
,      LEGISLATION_CODE
,      DESCRIPTION
FROM HR.PAY_PROCESS_GROUPS;

Dependencies

[top of page]

HR.PAY_PROCESS_GROUPS does not reference any database object

HR.PAY_PROCESS_GROUPS is referenced by following:

SchemaAPPS
SynonymPAY_PROCESS_GROUPS
SchemaPUBLIC
SynonymPAY_PROCESS_GROUPS