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

VIEW: APPS.PAY_ASS_STATUS_TYPES_PLUS_STD

Object Details
Object Name: PAY_ASS_STATUS_TYPES_PLUS_STD
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPAY.PAY_ASS_STATUS_TYPES_PLUS_STD
Subobject Name:
Status: VALID

View Type

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.


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.PAY_ASS_STATUS_TYPES_PLUS_STD references the following:

SchemaAPPS
PL/SQL PackageFND_NUMBER - show dependent code
PL/SQL PackageHR_API - show dependent code
ViewHR_LOOKUPS
SynonymPER_ASSIGNMENT_STATUS_TYPES
SynonymPER_ASSIGNMENT_STATUS_TYPES_TL
APPS.PAY_ASS_STATUS_TYPES_PLUS_STD is referenced by following:

SchemaAPPS
Package BodyPAY_PPR_BUS - show dependent code
ViewPAY_STATUS_PROCESSING_RULES_V