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

VIEW: APPS.PAY_AC_EMP_SUM_ACTION_INFO_V

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

View Type

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


This view retrieves employee earnings and deductions summary data.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ACTION_CONTEXT_ID NUMBER (15) Yes System-generated primary key column
ACTION_INFORMATION_CATEGORY VARCHAR2 (80) Yes Represents the "Summary" category: current or year to date
ROW_LABEL VARCHAR2 (240)
Row label
EARNINGS NUMBER

Earnings amount
SUPPLEMENTAL_EARNINGS NUMBER

Supplemental earnings amount
IMPUTED_EARNINGS NUMBER

Imputed earnings amount
PRETAX_DEDUCTIONS NUMBER

Pre-tax deductions amount
INVOLUNTARY_DEDUCTIONS NUMBER

Involuntary deductions amount
VOLUNTARY_DEDUCTIONS NUMBER

Voluntary deductions amount
TAXES NUMBER

Taxes amount
NON_PAYROLL_PAYMENT NUMBER

Non-payroll payments amount
TAXABLE_BENEFITS NUMBER

Taxable benefits amount
AFTER_TAX_DEDUCTIONS NUMBER

After-tax deductions amount
GROSS_EARNINGS NUMBER

Gross Earnings amount
GROSS_PAY NUMBER

Gross pay amount
NET_PAY NUMBER

Net pay amount
CA_TOTAL_DEDUCTIONS NUMBER

Total deductions amount - CA legislation -
Query Text

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


SELECT ACTION_CONTEXT_ID
,      ACTION_INFORMATION_CATEGORY
,      ROW_LABEL
,      EARNINGS
,      SUPPLEMENTAL_EARNINGS
,      IMPUTED_EARNINGS
,      PRETAX_DEDUCTIONS
,      INVOLUNTARY_DEDUCTIONS
,      VOLUNTARY_DEDUCTIONS
,      TAXES
,      NON_PAYROLL_PAYMENT
,      TAXABLE_BENEFITS
,      AFTER_TAX_DEDUCTIONS
,      GROSS_EARNINGS
,      GROSS_PAY
,      NET_PAY
,      CA_TOTAL_DEDUCTIONS
FROM APPS.PAY_AC_EMP_SUM_ACTION_INFO_V;

Dependencies

[top of page]

APPS.PAY_AC_EMP_SUM_ACTION_INFO_V references the following:

SchemaAPPS
PL/SQL PackageFND_NUMBER - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPAY_ACTION_INFORMATION
PL/SQL PackagePAY_US_EMPLOYEE_PAYSLIP_WEB - show dependent code
ViewPER_ASSIGNMENTS_F
APPS.PAY_AC_EMP_SUM_ACTION_INFO_V is referenced by following:

SchemaAPPS
Package BodyPAY_CA_RULES - show dependent code
Package BodyPAY_US_HR_HELPDESK - show dependent code
Package BodyPAY_US_PAYSLIP_SIMULATION_MAIN - show dependent code
Package BodyPAY_US_RULES - show dependent code