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

VIEW: APPS.PSP_ENC_PAYROLL_ASSIGNMENT_V

Object Details
Object Name: PSP_ENC_PAYROLL_ASSIGNMENT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPSP.PSP_ENC_PAYROLL_ASSIGNMENT_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ASSIGNMENT_ID NUMBER

Foreign key to PER_ASSIGNMENTS_F
ASSIGNMENT_NUMBER VARCHAR2 (30)
ENC_PAYROLL_ID NUMBER (9)
Foreign key to PSP_ENC_PAYROLLS
BUSINESS_GROUP_ID NUMBER (15)
Business Group Identifier
SET_OF_BOOKS_ID NUMBER (15)
Set of Books Identifier
ENC_PAYROLL_ASSIGNMENT_ID NUMBER

System generated primary key column.
INCLUDE VARCHAR2 (1)
Include flag
EXCLUDE VARCHAR2 (1)
Exclude flag
FULL_NAME VARCHAR2 (240)
Full name
PAYROLL_ID NUMBER (9)
Foreign key to PAY_PAYROLLS_F
Query Text

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


SELECT ASSIGNMENT_ID
,      ASSIGNMENT_NUMBER
,      ENC_PAYROLL_ID
,      BUSINESS_GROUP_ID
,      SET_OF_BOOKS_ID
,      ENC_PAYROLL_ASSIGNMENT_ID
,      INCLUDE
,      EXCLUDE
,      FULL_NAME
,      PAYROLL_ID
FROM APPS.PSP_ENC_PAYROLL_ASSIGNMENT_V;

Dependencies

[top of page]

APPS.PSP_ENC_PAYROLL_ASSIGNMENT_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewPAY_PAYROLLS_F
SynonymPER_ALL_ASSIGNMENTS_F
SynonymPER_ALL_PEOPLE_F
ViewPER_ASSIGNMENTS_F
SynonymPER_ASSIGNMENT_STATUS_TYPES
ViewPER_PEOPLE_F
SynonymPSP_ENC_PAYROLLS
SynonymPSP_ENC_PAYROLL_ASSIGNMENTS
APPS.PSP_ENC_PAYROLL_ASSIGNMENT_V is referenced by following:

SchemaAPPS
Package BodyPSP_ENC_CREATE_LINES - show dependent code