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


VIEW: APPS.PAYBV_PAYROLL_MESSAGE_V

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

View Type

A Business Intelligence System view

[View Source]

Columns
Name Datatype Length Mandatory Comments
PAYROLL_NAME VARCHAR2 (80)
PERIOD_NAME VARCHAR2 (4000)
PROCESS_TYPE_M VARCHAR2 (4000)
PROCESS_DATE DATE

PAYROLL_ACTION_STATUS VARCHAR2 (4000)
FULL_NAME VARCHAR2 (240)
ASSIGNMENT_NUMBER VARCHAR2 (30)
ASSIGNMENT_ACTION_STATUS VARCHAR2 (4000)
SEVERITY_LEVEL_M VARCHAR2 (4000)
MESSAGE_LINE VARCHAR2 (2000)
LINE_SEQUENCE NUMBER (15)
MESSAGE_SOURCE_M VARCHAR2 (4000)
PROCESS_TYPE VARCHAR2 (30)
SEVERITY_LEVEL VARCHAR2 (1)
MESSAGE_SOURCE VARCHAR2 (1)
PAYROLL_ACTION_ID NUMBER (9)
PAYROLL_ID NUMBER (9)
REQUEST_ID NUMBER (15)
ASSIGNMENT_ACTION_ID NUMBER

BG_SECURITY_FLAG_CODE CHAR (1)
Query Text

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


SELECT PAYROLL_NAME
,      PERIOD_NAME
,      PROCESS_TYPE_M
,      PROCESS_DATE
,      PAYROLL_ACTION_STATUS
,      FULL_NAME
,      ASSIGNMENT_NUMBER
,      ASSIGNMENT_ACTION_STATUS
,      SEVERITY_LEVEL_M
,      MESSAGE_LINE
,      LINE_SEQUENCE
,      MESSAGE_SOURCE_M
,      PROCESS_TYPE
,      SEVERITY_LEVEL
,      MESSAGE_SOURCE
,      PAYROLL_ACTION_ID
,      PAYROLL_ID
,      REQUEST_ID
,      ASSIGNMENT_ACTION_ID
,      BG_SECURITY_FLAG_CODE
FROM APPS.PAYBV_PAYROLL_MESSAGE_V;

Dependencies

[top of page]

APPS.PAYBV_PAYROLL_MESSAGE_V references the following:

SchemaAPPS
PL/SQL PackageHR_BIS - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PAYROLLS - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPAY_ASSIGNMENT_ACTIONS
PL/SQL PackagePAY_ASSIGNMENT_ACTIONS_PKG - show dependent code
SynonymPAY_MESSAGE_LINES
ViewPAY_PAYROLLS_F
SynonymPAY_PAYROLL_ACTIONS
PL/SQL PackagePAY_PAYROLL_ACTIONS_PKG - show dependent code
ViewPER_ASSIGNMENTS_F
ViewPER_PEOPLE_F

APPS.PAYBV_PAYROLL_MESSAGE_V is not referenced by any database object