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

VIEW: APPS.PAY_AU_ASG_PAYMENT_RUNS_V

Object Details
Object Name: PAY_AU_ASG_PAYMENT_RUNS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPAY.PAY_AU_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)
ASSIGNMENT_ID NUMBER (10)
ASSIGNMENT_ACTION_ID NUMBER (15) Yes
PERSON_ID NUMBER (10) Yes
FULL_NAME VARCHAR2 (240)
ORDER_NAME VARCHAR2 (240)
TITLE VARCHAR2 (30)
INITIALS VARCHAR2 (3)
LAST_NAME VARCHAR2 (150) Yes
ASSIGNMENT_NUMBER VARCHAR2 (30)
POSITION_TITLE VARCHAR2 (240)
JOB VARCHAR2 (700)
SALARY VARCHAR2 (4000)
LOCATION_ID NUMBER (15)
LOCATION_CODE VARCHAR2 (60)
INTERNAL_ADDRESS_LINE VARCHAR2 (80)
EXPENSE_CHECK_SEND_TO_ADDRESS VARCHAR2 (30)
BUSINESS_GROUP_ID NUMBER (15) Yes
REGISTERED_EMPLOYER VARCHAR2 (150)
PAYROLL_ID NUMBER (9)
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
PAY_ADVICE_DATE DATE

DATE_EARNED DATE

RUN_ASSIGNMENT_ACTION_ID NUMBER (15) Yes
RUN_PAYROLL_ACTION_ID NUMBER (9) Yes
ABN VARCHAR2 (150)
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)
ORGANIZATION_NAME VARCHAR2 (240) Yes
GRADE VARCHAR2 (240)
Query Text

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


SELECT ROW_ID
,      ASSIGNMENT_ID
,      ASSIGNMENT_ACTION_ID
,      PERSON_ID
,      FULL_NAME
,      ORDER_NAME
,      TITLE
,      INITIALS
,      LAST_NAME
,      ASSIGNMENT_NUMBER
,      POSITION_TITLE
,      JOB
,      SALARY
,      LOCATION_ID
,      LOCATION_CODE
,      INTERNAL_ADDRESS_LINE
,      EXPENSE_CHECK_SEND_TO_ADDRESS
,      BUSINESS_GROUP_ID
,      REGISTERED_EMPLOYER
,      PAYROLL_ID
,      PAYROLL_ACTION_ID
,      TIME_PERIOD_ID
,      PERIOD_NUMBER
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      PAY_ADVICE_DATE
,      DATE_EARNED
,      RUN_ASSIGNMENT_ACTION_ID
,      RUN_PAYROLL_ACTION_ID
,      ABN
,      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
,      ORGANIZATION_NAME
,      GRADE
FROM APPS.PAY_AU_ASG_PAYMENT_RUNS_V;

Dependencies

[top of page]

APPS.PAY_AU_ASG_PAYMENT_RUNS_V references the following:

SchemaAPPS
SynonymHR_ALL_POSITIONS_F_TL
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
SynonymHR_ORGANIZATION_INFORMATION
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
PL/SQL PackagePAY_AU_SOE_PKG - show dependent code
SynonymPAY_PAYROLL_ACTIONS
SynonymPAY_PEOPLE_GROUPS
ViewPER_ASSIGNMENTS_F
SynonymPER_GRADES_TL
SynonymPER_JOBS_TL
ViewPER_PEOPLE_F
SynonymPER_TIME_PERIODS

APPS.PAY_AU_ASG_PAYMENT_RUNS_V is not referenced by any database object