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

VIEW: APPS.PAY_PAYROLL_ACTIONS_V6

Object Details
Object Name: PAY_PAYROLL_ACTIONS_V6
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPAY.PAY_PAYROLL_ACTIONS_V6
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
ROW_ID ROWID (10)
PAYROLL_ID NUMBER (9)
PAYROLL_ACTION_ID NUMBER (9)
EFFECTIVE_DATE DATE

PERIOD_NAME VARCHAR2 (4000)
MEANING VARCHAR2 (4000)
NAME VARCHAR2 (4000)
ACTION_TYPE VARCHAR2 (30)
PAYROLL_NAME VARCHAR2 (80)
STATUS_CODE VARCHAR2 (1)
ACTION_STATUS VARCHAR2 (4000)
ACTION_SEQUENCE NUMBER (15)
MESSAGES_EXIST VARCHAR2 (4000)
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).
Query Text

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


SELECT ROW_ID
,      PAYROLL_ID
,      PAYROLL_ACTION_ID
,      EFFECTIVE_DATE
,      PERIOD_NAME
,      MEANING
,      NAME
,      ACTION_TYPE
,      PAYROLL_NAME
,      STATUS_CODE
,      ACTION_STATUS
,      ACTION_SEQUENCE
,      MESSAGES_EXIST
,      REQUEST_ID
FROM APPS.PAY_PAYROLL_ACTIONS_V6;

Dependencies

[top of page]

APPS.PAY_PAYROLL_ACTIONS_V6 references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PAYROLLS - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPAY_ASSIGNMENT_ACTIONS
ViewPAY_PAYROLLS_F
SynonymPAY_PAYROLL_ACTIONS
PL/SQL PackagePAY_PAYROLL_ACTIONS_PKG - show dependent code
ViewPER_ASSIGNMENTS_F2

APPS.PAY_PAYROLL_ACTIONS_V6 is not referenced by any database object