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

VIEW: APPS.PAY_PERF_PAYSLIP_ACTION_INFO_V

Object Details
Object Name: PAY_PERF_PAYSLIP_ACTION_INFO_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


This view retrieves the list of date, assignment id and number of checks for an employee to view.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ACTION_INFORMATION14 VARCHAR2 (240)
Assignment Number
CHECK_COUNT NUMBER

Check Number
ACTION_CONTEXT_ID NUMBER (15) Yes Action Context Id
PERSON_ID NUMBER (10) Yes Person Id
EFFECTIVE_DATE DATE

Effective Date
PAYROLL_ID NUMBER (9)
Payroll Id
TIME_PERIOD_ID VARCHAR2 (240)
Time Period Id
ASSIGNMENT_ID NUMBER (10) Yes Assignment Id
Query Text

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


SELECT ACTION_INFORMATION14
,      CHECK_COUNT
,      ACTION_CONTEXT_ID
,      PERSON_ID
,      EFFECTIVE_DATE
,      PAYROLL_ID
,      TIME_PERIOD_ID
,      ASSIGNMENT_ID
FROM APPS.PAY_PERF_PAYSLIP_ACTION_INFO_V;

Dependencies

[top of page]

APPS.PAY_PERF_PAYSLIP_ACTION_INFO_V references the following:

SchemaAPPS
SynonymHR_ORGANIZATION_INFORMATION
SynonymPAY_ACTION_INFORMATION
SynonymPAY_ASSIGNMENT_ACTIONS
SynonymPAY_LEGISLATIVE_FIELD_INFO
SynonymPAY_PAYROLL_ACTIONS
SynonymPER_ALL_ASSIGNMENTS_F
APPS.PAY_PERF_PAYSLIP_ACTION_INFO_V is referenced by following:

SchemaAPPS
PL/SQL PackagePAY_US_EMPLOYEE_PAYSLIP_WEB - show dependent code