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

VIEW: APPS.PAY_GB_YEAR_END_ASSIGNMENTS_V

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ASSIGNMENT_ACTION_ID NUMBER (15) Yes
ASSIGNMENT_ID NUMBER (10)
PAYROLL_ACTION_ID NUMBER (9) Yes
ACTION_STATUS VARCHAR2 (1) Yes
CHUNK_NUMBER NUMBER (15)
PAYROLL_ID NUMBER

EFFECTIVE_END_DATE DATE

ADDRESS_LINE1 VARCHAR2 (4000)
ADDRESS_LINE2 VARCHAR2 (4000)
ADDRESS_LINE3 VARCHAR2 (4000)
ASSIGNMENT_NUMBER VARCHAR2 (4000)
COUNTY VARCHAR2 (4000)
DATE_OF_BIRTH DATE

DIRECTOR_INDICATOR VARCHAR2 (4000)
EFFECTIVE_START_DATE DATE

EOY_PRIMARY_FLAG VARCHAR2 (4000)
EXPENSE_CHECK_SEND_TO_ADDRESS VARCHAR2 (4000)
FIRST_NAME VARCHAR2 (4000)
GROSS_PAY NUMBER

LAST_ASG_ACTION_ID NUMBER

LAST_EFFECTIVE_DATE DATE

LAST_NAME VARCHAR2 (4000)
LOCATION_ID NUMBER

MIDDLE_NAME VARCHAR2 (4000)
MULTIPLE_ASG_FLAG VARCHAR2 (4000)
AGGREGATED_PAYE_FLAG VARCHAR2 (4000)
NATIONAL_INSURANCE_NUMBER VARCHAR2 (4000)
ORGANIZATION_ID NUMBER

PENSIONER_INDICATOR VARCHAR2 (4000)
PEOPLE_GROUP_ID NUMBER

PERSON_ID NUMBER

POSTAL_CODE VARCHAR2 (4000)
PREVIOUS_TAXABLE_PAY NUMBER

PREVIOUS_TAX_PAID NUMBER

PREVIOUS_YEAR_ASG_ACTION_ID NUMBER

PREVIOUS_YEAR_EFFECTIVE_DATE DATE

SEX VARCHAR2 (4000)
SSP NUMBER

SMP NUMBER

START_OF_EMP DATE

SUPERANNUATION_PAID NUMBER

SUPERANNUATION_REFUND VARCHAR2 (4000)
TAXABLE_PAY NUMBER

TAX_CODE VARCHAR2 (4000)
TAX_PAID NUMBER

TAX_REFUND VARCHAR2 (4000)
TAX_RUN_RESULT_ID NUMBER

TERMINATION_DATE DATE

TERMINATION_TYPE VARCHAR2 (4000)
TITLE VARCHAR2 (4000)
TOWN_OR_CITY VARCHAR2 (4000)
W1_M1_INDICATOR VARCHAR2 (4000)
WEEK_53_INDICATOR VARCHAR2 (4000)
WIDOWS_AND_ORPHANS NUMBER

NOTIONAL_PAY NUMBER

SAP NUMBER

SPP_ADOPT NUMBER

SPP_BIRTH NUMBER

STUDENT_LOANS NUMBER

TAX_CREDITS NUMBER

ASPP_ADOPT NUMBER

ASPP_BIRTH NUMBER

Query Text

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


SELECT ASSIGNMENT_ACTION_ID
,      ASSIGNMENT_ID
,      PAYROLL_ACTION_ID
,      ACTION_STATUS
,      CHUNK_NUMBER
,      PAYROLL_ID
,      EFFECTIVE_END_DATE
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      ASSIGNMENT_NUMBER
,      COUNTY
,      DATE_OF_BIRTH
,      DIRECTOR_INDICATOR
,      EFFECTIVE_START_DATE
,      EOY_PRIMARY_FLAG
,      EXPENSE_CHECK_SEND_TO_ADDRESS
,      FIRST_NAME
,      GROSS_PAY
,      LAST_ASG_ACTION_ID
,      LAST_EFFECTIVE_DATE
,      LAST_NAME
,      LOCATION_ID
,      MIDDLE_NAME
,      MULTIPLE_ASG_FLAG
,      AGGREGATED_PAYE_FLAG
,      NATIONAL_INSURANCE_NUMBER
,      ORGANIZATION_ID
,      PENSIONER_INDICATOR
,      PEOPLE_GROUP_ID
,      PERSON_ID
,      POSTAL_CODE
,      PREVIOUS_TAXABLE_PAY
,      PREVIOUS_TAX_PAID
,      PREVIOUS_YEAR_ASG_ACTION_ID
,      PREVIOUS_YEAR_EFFECTIVE_DATE
,      SEX
,      SSP
,      SMP
,      START_OF_EMP
,      SUPERANNUATION_PAID
,      SUPERANNUATION_REFUND
,      TAXABLE_PAY
,      TAX_CODE
,      TAX_PAID
,      TAX_REFUND
,      TAX_RUN_RESULT_ID
,      TERMINATION_DATE
,      TERMINATION_TYPE
,      TITLE
,      TOWN_OR_CITY
,      W1_M1_INDICATOR
,      WEEK_53_INDICATOR
,      WIDOWS_AND_ORPHANS
,      NOTIONAL_PAY
,      SAP
,      SPP_ADOPT
,      SPP_BIRTH
,      STUDENT_LOANS
,      TAX_CREDITS
,      ASPP_ADOPT
,      ASPP_BIRTH
FROM APPS.PAY_GB_YEAR_END_ASSIGNMENTS_V;

Dependencies

[top of page]

APPS.PAY_GB_YEAR_END_ASSIGNMENTS_V references the following:

SchemaAPPS
SynonymFF_ARCHIVE_ITEMS
SynonymFF_USER_ENTITIES
SynonymPAY_ASSIGNMENT_ACTIONS
PL/SQL PackagePAY_GB_EOY_ARCHIVE - show dependent code

APPS.PAY_GB_YEAR_END_ASSIGNMENTS_V is not referenced by any database object