[Home] [Help] [Dependency Information]
Object Name: | PAY_PAYROLL_LIST |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PAY.PAY_PAYROLL_LIST |
Subobject Name: | |
Status: | VALID |
PAY_PAYROLL_LIST holds the list of specific payrolls that a secure
user can access. This list is created and maintained by the LISTGEN
security process using the definition of the security profile and it
will restrict user access to the specified payrolls and the employees
assigned to those payrolls.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PAY_PAYROLL_LIST_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SECURITY_PROFILE_ID |
PAY_PAYROLL_LIST_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PAYROLL_ID |
Table | |
Foreign Table | Foreign Key Column | PAY_PAYROLL_LIST | PER_SECURITY_PROFILES | PAY_PAYROLL_LIST SECURITY_PROFILE_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PAYROLL_ID | NUMBER | (9) | Yes | Payroll accessible by the security profile. |
SECURITY_PROFILE_ID | NUMBER | (15) | Yes | Security profile restricted by payroll. |
REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |
PROGRAM_ID | NUMBER | (15) | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | |
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). |
Cut, paste (and edit) the following text to query this object:
SELECT PAYROLL_ID
, SECURITY_PROFILE_ID
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM HR.PAY_PAYROLL_LIST;
HR.PAY_PAYROLL_LIST does not reference any database object
HR.PAY_PAYROLL_LIST is referenced by following:
|
|
|