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

VIEW: APPS.PAY_PDT_BATCH_LINES

Object Details
Object Name: PAY_PDT_BATCH_LINES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPAY.PAY_PDT_BATCH_LINES
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
BATCH_ID NUMBER (15) Yes
LINE_ID NUMBER (15) Yes
ASSIGNMENT_NUMBER VARCHAR2 (30)
ADJUSTMENT_TYPE_CODE VARCHAR2 (0)
AMOUNT NUMBER

APPLY_THIS_PERIOD VARCHAR2 (0)
COST_CENTER_CODE VARCHAR2 (0)
ELEMENT_NAME VARCHAR2 (80) Yes
FROM_DATE DATE

HOURLY_RATE NUMBER

HOURS_WORKED NUMBER

INC_ASC_BALANCE VARCHAR2 (30)
LABOR_DIST_CODE VARCHAR2 (0)
LINE_STATUS VARCHAR2 (30) Yes
LOCALITY_WORKED VARCHAR2 (0)
NEW_SALARY NUMBER

PAY_EFFECTIVE_DATE DATE

PCNT_INCREASE NUMBER

RATE_CODE VARCHAR2 (80)
RATE_MULTIPLE NUMBER

RATING_CODE VARCHAR2 (0)
SEPARATE_CHECK_FLAG VARCHAR2 (30)
SHIFT_TYPE VARCHAR2 (80)
STATE_WORKED VARCHAR2 (80)
TAX_SEPARATELY_FLAG VARCHAR2 (30)
TO_DATE DATE

VOL_DED_PROC_OVD VARCHAR2 (30)
COST_ALLOCATION_KEYFLEX_ID NUMBER (9)
CONCATENATED_SEGMENTS VARCHAR2 (240)
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 BATCH_ID
,      LINE_ID
,      ASSIGNMENT_NUMBER
,      ADJUSTMENT_TYPE_CODE
,      AMOUNT
,      APPLY_THIS_PERIOD
,      COST_CENTER_CODE
,      ELEMENT_NAME
,      FROM_DATE
,      HOURLY_RATE
,      HOURS_WORKED
,      INC_ASC_BALANCE
,      LABOR_DIST_CODE
,      LINE_STATUS
,      LOCALITY_WORKED
,      NEW_SALARY
,      PAY_EFFECTIVE_DATE
,      PCNT_INCREASE
,      RATE_CODE
,      RATE_MULTIPLE
,      RATING_CODE
,      SEPARATE_CHECK_FLAG
,      SHIFT_TYPE
,      STATE_WORKED
,      TAX_SEPARATELY_FLAG
,      TO_DATE
,      VOL_DED_PROC_OVD
,      COST_ALLOCATION_KEYFLEX_ID
,      CONCATENATED_SEGMENTS
,      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_PDT_BATCH_LINES;

Dependencies

[top of page]

APPS.PAY_PDT_BATCH_LINES references the following:

SchemaAPPS
PL/SQL PackageFND_NUMBER - show dependent code
PL/SQL PackageHR_API - show dependent code
ViewHR_LOOKUPS
ViewPAY_PDT_BATCH_LINES_V3
APPS.PAY_PDT_BATCH_LINES is referenced by following:

SchemaAPPS
TriggerPAY_PAYMIX_LINE_INSERT