[Home] [Help] [Dependency Information]
Object Name: | PAY_ASS_STATUS_TYPES_PLUS_STD |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAY_ASS_STATUS_TYPES_PLUS_STD |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
PAY_ASS_STATUS_TYPES_PLUS_STD provides the list of assignment
status types plus the "Standard" status type, used for formula result
rules. There is an implicit rule that if an assignment has no
assignment status type then the status type is taken as "Standard".
This view allows that rule to appear explicity to clarify the possible
choices of assignment status type.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
USER_STATUS | VARCHAR2 | (80) | Translated User Status value | |
ASSIGNMENT_STATUS_TYPE_ID | NUMBER | Assignment Status Type ID value | ||
BUSINESS_GROUP_ID | NUMBER | Business group ID | ||
LEGISLATION_CODE | VARCHAR2 | (30) | Legislation Code | |
LOOKUP_CODE | VARCHAR2 | (30) | Standard or Balance Adjustment |
Cut, paste (and edit) the following text to query this object:
SELECT USER_STATUS
, ASSIGNMENT_STATUS_TYPE_ID
, BUSINESS_GROUP_ID
, LEGISLATION_CODE
, LOOKUP_CODE
FROM APPS.PAY_ASS_STATUS_TYPES_PLUS_STD;
|
|
|