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

VIEW: APPS.PAY_IE_P45_PAYE_DETAILS

Object Details
Object Name: PAY_IE_P45_PAYE_DETAILS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPAY.PAY_IE_P45_PAYE_DETAILS
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_ACTION_ID NUMBER (15) Yes
MONTHLY_TAX_CREDIT NUMBER

MONTHLY_STD_CUT_OFF NUMBER

WEEKLY_TAX_CREDIT NUMBER

WEEKLY_STD_CUT_OFF NUMBER

MONTH_NO NUMBER

WEEK_NO NUMBER

TOTAL_TAX NUMBER

TOTAL_PAY NUMBER

LUMP_SUM NUMBER

EMERGENCY_TAX VARCHAR2 (240)
THIS_PAY VARCHAR2 (40)
THIS_TAX VARCHAR2 (40)
THIS_USC_PAY VARCHAR2 (40)
THIS_USC VARCHAR2 (40)
TOTAL_USC NUMBER

TOTAL_USC_PAY NUMBER

Query Text

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


SELECT ASSIGNMENT_ACTION_ID
,      MONTHLY_TAX_CREDIT
,      MONTHLY_STD_CUT_OFF
,      WEEKLY_TAX_CREDIT
,      WEEKLY_STD_CUT_OFF
,      MONTH_NO
,      WEEK_NO
,      TOTAL_TAX
,      TOTAL_PAY
,      LUMP_SUM
,      EMERGENCY_TAX
,      THIS_PAY
,      THIS_TAX
,      THIS_USC_PAY
,      THIS_USC
,      TOTAL_USC
,      TOTAL_USC_PAY
FROM APPS.PAY_IE_P45_PAYE_DETAILS;

Dependencies

[top of page]

APPS.PAY_IE_P45_PAYE_DETAILS references the following:

SchemaAPPS
PL/SQL PackageFND_DATE - show dependent code
SynonymPAY_ACTION_INFORMATION
SynonymPAY_ASSIGNMENT_ACTIONS
PL/SQL PackagePAY_IE_P45_ARCHIVE - show dependent code
SynonymPAY_LEGISLATION_RULES
SynonymPAY_PAYROLL_ACTIONS
SynonymPER_TIME_PERIODS
APPS.PAY_IE_P45_PAYE_DETAILS is referenced by following:

SchemaAPPS
Package BodyPAY_IE_P45_ARCHIVE - show dependent code