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

VIEW: APPS.PAY_NZ_ASG_PAYMENT_RUNS_V

Object Details
Object Name: PAY_NZ_ASG_PAYMENT_RUNS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPAY.PAY_NZ_ASG_PAYMENT_RUNS_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
ROW_ID ROWID (10)
BUSINESS_GROUP_ID NUMBER (15) Yes
ASSIGNMENT_ID NUMBER (10)
ASSIGNMENT_ACTION_ID NUMBER (15) Yes
PERSON_ID NUMBER (10) Yes
SALARY VARCHAR2 (4000)
TAX_CODE VARCHAR2 (4000)
COST_CENTRE VARCHAR2 (2000)
COST_CENTRE_PROPORTION NUMBER

POSITION_TITLE VARCHAR2 (240)
FULL_NAME VARCHAR2 (240)
ORDER_NAME VARCHAR2 (240)
TITLE VARCHAR2 (30)
INITIALS VARCHAR2 (3)
LAST_NAME VARCHAR2 (150) Yes
ASSIGNMENT_NUMBER VARCHAR2 (30)
REGISTERED_EMPLOYER VARCHAR2 (240) Yes
LOCATION_ID NUMBER (15)
LOCATION_CODE VARCHAR2 (60)
INTERNAL_ADDRESS_LINE VARCHAR2 (80)
IRD_NUMBER VARCHAR2 (30)
EXPENSE_CHECK_SEND_TO_ADDRESS VARCHAR2 (30)
DATE_EARNED DATE

PAYROLL_ACTION_ID NUMBER (9) Yes
RUN_ASSIGNMENT_ACTION_ID NUMBER (15) Yes
RUN_PAYROLL_ACTION_ID NUMBER (9) Yes
TIME_PERIOD_ID NUMBER (15) Yes
PERIOD_NUMBER NUMBER (15) Yes
PERIOD_START_DATE DATE
Yes
PERIOD_END_DATE DATE
Yes
PAYROLL_ID NUMBER (9)
PAY_ADVICE_DATE DATE

SEGMENT1 VARCHAR2 (60)
Key flexfield segment
SEGMENT2 VARCHAR2 (60)
Key flexfield segment
SEGMENT3 VARCHAR2 (60)
Key flexfield segment
SEGMENT4 VARCHAR2 (60)
Key flexfield segment
SEGMENT5 VARCHAR2 (60)
Key flexfield segment
SEGMENT6 VARCHAR2 (60)
Key flexfield segment
SEGMENT7 VARCHAR2 (60)
Key flexfield segment
SEGMENT8 VARCHAR2 (60)
Key flexfield segment
SEGMENT9 VARCHAR2 (60)
Key flexfield segment
SEGMENT10 VARCHAR2 (60)
Key flexfield segment
SEGMENT11 VARCHAR2 (60)
Key flexfield segment
SEGMENT12 VARCHAR2 (60)
Key flexfield segment
SEGMENT13 VARCHAR2 (60)
Key flexfield segment
SEGMENT14 VARCHAR2 (60)
Key flexfield segment
SEGMENT15 VARCHAR2 (60)
Key flexfield segment
SEGMENT16 VARCHAR2 (60)
Key flexfield segment
SEGMENT17 VARCHAR2 (60)
Key flexfield segment
SEGMENT18 VARCHAR2 (60)
Key flexfield segment
SEGMENT19 VARCHAR2 (60)
Key flexfield segment
SEGMENT20 VARCHAR2 (60)
Key flexfield segment
SEGMENT21 VARCHAR2 (60)
SEGMENT22 VARCHAR2 (60)
SEGMENT23 VARCHAR2 (60)
SEGMENT24 VARCHAR2 (60)
SEGMENT25 VARCHAR2 (60)
SEGMENT26 VARCHAR2 (60)
SEGMENT27 VARCHAR2 (60)
SEGMENT28 VARCHAR2 (60)
SEGMENT29 VARCHAR2 (60)
SEGMENT30 VARCHAR2 (60)
Query Text

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


SELECT ROW_ID
,      BUSINESS_GROUP_ID
,      ASSIGNMENT_ID
,      ASSIGNMENT_ACTION_ID
,      PERSON_ID
,      SALARY
,      TAX_CODE
,      COST_CENTRE
,      COST_CENTRE_PROPORTION
,      POSITION_TITLE
,      FULL_NAME
,      ORDER_NAME
,      TITLE
,      INITIALS
,      LAST_NAME
,      ASSIGNMENT_NUMBER
,      REGISTERED_EMPLOYER
,      LOCATION_ID
,      LOCATION_CODE
,      INTERNAL_ADDRESS_LINE
,      IRD_NUMBER
,      EXPENSE_CHECK_SEND_TO_ADDRESS
,      DATE_EARNED
,      PAYROLL_ACTION_ID
,      RUN_ASSIGNMENT_ACTION_ID
,      RUN_PAYROLL_ACTION_ID
,      TIME_PERIOD_ID
,      PERIOD_NUMBER
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      PAYROLL_ID
,      PAY_ADVICE_DATE
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
FROM APPS.PAY_NZ_ASG_PAYMENT_RUNS_V;

Dependencies

[top of page]

APPS.PAY_NZ_ASG_PAYMENT_RUNS_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
ViewHR_ORGANIZATION_UNITS
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymHR_SOFT_CODING_KEYFLEX
SynonymPAY_ACTION_INTERLOCKS
SynonymPAY_ASSIGNMENT_ACTIONS
SynonymPAY_COST_ALLOCATIONS_F
SynonymPAY_COST_ALLOCATION_KEYFLEX
PL/SQL PackagePAY_NZ_SOE_PKG - show dependent code
SynonymPAY_PAYROLL_ACTIONS
SynonymPAY_PEOPLE_GROUPS
ViewPER_ASSIGNMENTS_F
ViewPER_PEOPLE_F
ViewPER_POSITIONS
SynonymPER_TIME_PERIODS
APPS.PAY_NZ_ASG_PAYMENT_RUNS_V is referenced by following:

SchemaPUBLIC
SynonymPAY_NZ_ASG_PAYMENT_RUNS_V