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

VIEW: APPS.PAY_ZA_ASSIGNMENT_ACTIONS_V2

Object Details
Object Name: PAY_ZA_ASSIGNMENT_ACTIONS_V2
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPAY.PAY_ZA_ASSIGNMENT_ACTIONS_V2
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
ROW_ID ROWID (10)

ASSIGNMENT_ID NUMBER (10)

ASSIGNMENT_ACTION_ID NUMBER (15) Yes
PERSON_ID NUMBER (10) Yes
SALARY VARCHAR2 (60)

PAY_BASIS VARCHAR2 (30)

JOB_TITLE VARCHAR2 (700)

FULL_NAME VARCHAR2 (240)

TITLE VARCHAR2 (30)

INITIALS VARCHAR2 (3)

LAST_NAME VARCHAR2 (150) Yes
ASSIGNMENT_NUMBER VARCHAR2 (30)

LOCATION_ID NUMBER (15)

INTERNAL_ADDRESS_LINE VARCHAR2 (80)

NI_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)

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
,      ASSIGNMENT_ID
,      ASSIGNMENT_ACTION_ID
,      PERSON_ID
,      SALARY
,      PAY_BASIS
,      JOB_TITLE
,      FULL_NAME
,      TITLE
,      INITIALS
,      LAST_NAME
,      ASSIGNMENT_NUMBER
,      LOCATION_ID
,      INTERNAL_ADDRESS_LINE
,      NI_NUMBER
,      EXPENSE_CHECK_SEND_TO_ADDRESS
,      DATE_EARNED
,      PAYROLL_ACTION_ID
,      RUN_ASSIGNMENT_ACTION_ID
,      RUN_PAYROLL_ACTION_ID
,      TIME_PERIOD_ID
,      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_ZA_ASSIGNMENT_ACTIONS_V2;

Dependencies

[top of page]

APPS.PAY_ZA_ASSIGNMENT_ACTIONS_V2 references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPAY_ACTION_INTERLOCKS
SynonymPAY_ASSIGNMENT_ACTIONS
PL/SQL PackagePAY_GB_PAYROLL_ACTIONS_PKG - show dependent code
SynonymPAY_PAYROLL_ACTIONS
SynonymPAY_PEOPLE_GROUPS
SynonymPER_ALL_ASSIGNMENTS_F
SynonymPER_JOBS_TL
ViewPER_PEOPLE_F
SynonymPER_TIME_PERIODS

APPS.PAY_ZA_ASSIGNMENT_ACTIONS_V2 is not referenced by any database object