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


VIEW: APPS.HRDPV_UPDATE_PERSONAL_PAY_METH

Object Details
Object Name: HRDPV_UPDATE_PERSONAL_PAY_METH
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (15) Yes
BATCH_LINE_ID NUMBER (15) Yes
API_MODULE_ID NUMBER (15) Yes
LINE_STATUS VARCHAR2 (1) Yes
USER_SEQUENCE NUMBER (15)
LINK_VALUE NUMBER (15)
BUSINESS_GROUP_NAME VARCHAR2 (240)
P_EFFECTIVE_DATE VARCHAR2 (2000)
P_DATETRACK_UPDATE_MODE VARCHAR2 (2000)
P_AMOUNT VARCHAR2 (2000)
P_COMMENTS VARCHAR2 (2000)
P_PERCENTAGE VARCHAR2 (2000)
P_PRIORITY VARCHAR2 (2000)
P_ATTRIBUTE_CATEGORY VARCHAR2 (2000)
P_ATTRIBUTE1 VARCHAR2 (2000)
P_ATTRIBUTE2 VARCHAR2 (2000)
P_ATTRIBUTE3 VARCHAR2 (2000)
P_ATTRIBUTE4 VARCHAR2 (2000)
P_ATTRIBUTE5 VARCHAR2 (2000)
P_ATTRIBUTE6 VARCHAR2 (2000)
P_ATTRIBUTE7 VARCHAR2 (2000)
P_ATTRIBUTE8 VARCHAR2 (2000)
P_ATTRIBUTE9 VARCHAR2 (2000)
P_ATTRIBUTE10 VARCHAR2 (2000)
P_ATTRIBUTE11 VARCHAR2 (2000)
P_ATTRIBUTE12 VARCHAR2 (2000)
P_ATTRIBUTE13 VARCHAR2 (2000)
P_ATTRIBUTE14 VARCHAR2 (2000)
P_ATTRIBUTE15 VARCHAR2 (2000)
P_ATTRIBUTE16 VARCHAR2 (2000)
P_ATTRIBUTE17 VARCHAR2 (2000)
P_ATTRIBUTE18 VARCHAR2 (2000)
P_ATTRIBUTE19 VARCHAR2 (2000)
P_ATTRIBUTE20 VARCHAR2 (2000)
P_TERRITORY_CODE VARCHAR2 (2000)
P_SEGMENT1 VARCHAR2 (2000)
P_SEGMENT2 VARCHAR2 (2000)
P_SEGMENT3 VARCHAR2 (2000)
P_SEGMENT4 VARCHAR2 (2000)
P_SEGMENT5 VARCHAR2 (2000)
P_SEGMENT6 VARCHAR2 (2000)
P_SEGMENT7 VARCHAR2 (2000)
P_SEGMENT8 VARCHAR2 (2000)
P_SEGMENT9 VARCHAR2 (2000)
P_SEGMENT10 VARCHAR2 (2000)
P_SEGMENT11 VARCHAR2 (2000)
P_SEGMENT12 VARCHAR2 (2000)
P_SEGMENT13 VARCHAR2 (2000)
P_SEGMENT14 VARCHAR2 (2000)
P_SEGMENT15 VARCHAR2 (2000)
P_SEGMENT16 VARCHAR2 (2000)
P_SEGMENT17 VARCHAR2 (2000)
P_SEGMENT18 VARCHAR2 (2000)
P_SEGMENT19 VARCHAR2 (2000)
P_SEGMENT20 VARCHAR2 (2000)
P_SEGMENT21 VARCHAR2 (2000)
P_SEGMENT22 VARCHAR2 (2000)
P_SEGMENT23 VARCHAR2 (2000)
P_SEGMENT24 VARCHAR2 (2000)
P_SEGMENT25 VARCHAR2 (2000)
P_SEGMENT26 VARCHAR2 (2000)
P_SEGMENT27 VARCHAR2 (2000)
P_SEGMENT28 VARCHAR2 (2000)
P_SEGMENT29 VARCHAR2 (2000)
P_SEGMENT30 VARCHAR2 (2000)
P_CONCAT_SEGMENTS VARCHAR2 (2000)
P_PAYEE_TYPE VARCHAR2 (2000)
P_PPM_INFORMATION_CATEGORY VARCHAR2 (2000)
P_PPM_INFORMATION1 VARCHAR2 (2000)
P_PPM_INFORMATION2 VARCHAR2 (2000)
P_PPM_INFORMATION3 VARCHAR2 (2000)
P_PPM_INFORMATION4 VARCHAR2 (2000)
P_PPM_INFORMATION5 VARCHAR2 (2000)
P_PPM_INFORMATION6 VARCHAR2 (2000)
P_PPM_INFORMATION7 VARCHAR2 (2000)
P_PPM_INFORMATION8 VARCHAR2 (2000)
P_PPM_INFORMATION9 VARCHAR2 (2000)
P_PPM_INFORMATION10 VARCHAR2 (2000)
P_PPM_INFORMATION11 VARCHAR2 (2000)
P_PPM_INFORMATION12 VARCHAR2 (2000)
P_PPM_INFORMATION13 VARCHAR2 (2000)
P_PPM_INFORMATION14 VARCHAR2 (2000)
P_PPM_INFORMATION15 VARCHAR2 (2000)
P_PPM_INFORMATION16 VARCHAR2 (2000)
P_PPM_INFORMATION17 VARCHAR2 (2000)
P_PPM_INFORMATION18 VARCHAR2 (2000)
P_PPM_INFORMATION19 VARCHAR2 (2000)
P_PPM_INFORMATION20 VARCHAR2 (2000)
P_PPM_INFORMATION21 VARCHAR2 (2000)
P_PPM_INFORMATION22 VARCHAR2 (2000)
P_PPM_INFORMATION23 VARCHAR2 (2000)
P_PPM_INFORMATION24 VARCHAR2 (2000)
P_PPM_INFORMATION25 VARCHAR2 (2000)
P_PPM_INFORMATION26 VARCHAR2 (2000)
P_PPM_INFORMATION27 VARCHAR2 (2000)
P_PPM_INFORMATION28 VARCHAR2 (2000)
P_PPM_INFORMATION29 VARCHAR2 (2000)
P_PPM_INFORMATION30 VARCHAR2 (2000)
P_COMMENT_ID VARCHAR2 (2000)
P_EXTERNAL_ACCOUNT_ID VARCHAR2 (2000)
P_EFFECTIVE_START_DATE VARCHAR2 (2000)
P_EFFECTIVE_END_DATE VARCHAR2 (2000)
P_PERSONAL_PAY_METHOD_USER_KEY VARCHAR2 (2000)
P_PAYEE_ORG VARCHAR2 (2000)
P_PAYEE_PERSON_USER_KEY VARCHAR2 (2000)
P_LANGUAGE_CODE VARCHAR2 (2000)
Query Text

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


SELECT BATCH_ID
,      BATCH_LINE_ID
,      API_MODULE_ID
,      LINE_STATUS
,      USER_SEQUENCE
,      LINK_VALUE
,      BUSINESS_GROUP_NAME
,      P_EFFECTIVE_DATE
,      P_DATETRACK_UPDATE_MODE
,      P_AMOUNT
,      P_COMMENTS
,      P_PERCENTAGE
,      P_PRIORITY
,      P_ATTRIBUTE_CATEGORY
,      P_ATTRIBUTE1
,      P_ATTRIBUTE2
,      P_ATTRIBUTE3
,      P_ATTRIBUTE4
,      P_ATTRIBUTE5
,      P_ATTRIBUTE6
,      P_ATTRIBUTE7
,      P_ATTRIBUTE8
,      P_ATTRIBUTE9
,      P_ATTRIBUTE10
,      P_ATTRIBUTE11
,      P_ATTRIBUTE12
,      P_ATTRIBUTE13
,      P_ATTRIBUTE14
,      P_ATTRIBUTE15
,      P_ATTRIBUTE16
,      P_ATTRIBUTE17
,      P_ATTRIBUTE18
,      P_ATTRIBUTE19
,      P_ATTRIBUTE20
,      P_TERRITORY_CODE
,      P_SEGMENT1
,      P_SEGMENT2
,      P_SEGMENT3
,      P_SEGMENT4
,      P_SEGMENT5
,      P_SEGMENT6
,      P_SEGMENT7
,      P_SEGMENT8
,      P_SEGMENT9
,      P_SEGMENT10
,      P_SEGMENT11
,      P_SEGMENT12
,      P_SEGMENT13
,      P_SEGMENT14
,      P_SEGMENT15
,      P_SEGMENT16
,      P_SEGMENT17
,      P_SEGMENT18
,      P_SEGMENT19
,      P_SEGMENT20
,      P_SEGMENT21
,      P_SEGMENT22
,      P_SEGMENT23
,      P_SEGMENT24
,      P_SEGMENT25
,      P_SEGMENT26
,      P_SEGMENT27
,      P_SEGMENT28
,      P_SEGMENT29
,      P_SEGMENT30
,      P_CONCAT_SEGMENTS
,      P_PAYEE_TYPE
,      P_PPM_INFORMATION_CATEGORY
,      P_PPM_INFORMATION1
,      P_PPM_INFORMATION2
,      P_PPM_INFORMATION3
,      P_PPM_INFORMATION4
,      P_PPM_INFORMATION5
,      P_PPM_INFORMATION6
,      P_PPM_INFORMATION7
,      P_PPM_INFORMATION8
,      P_PPM_INFORMATION9
,      P_PPM_INFORMATION10
,      P_PPM_INFORMATION11
,      P_PPM_INFORMATION12
,      P_PPM_INFORMATION13
,      P_PPM_INFORMATION14
,      P_PPM_INFORMATION15
,      P_PPM_INFORMATION16
,      P_PPM_INFORMATION17
,      P_PPM_INFORMATION18
,      P_PPM_INFORMATION19
,      P_PPM_INFORMATION20
,      P_PPM_INFORMATION21
,      P_PPM_INFORMATION22
,      P_PPM_INFORMATION23
,      P_PPM_INFORMATION24
,      P_PPM_INFORMATION25
,      P_PPM_INFORMATION26
,      P_PPM_INFORMATION27
,      P_PPM_INFORMATION28
,      P_PPM_INFORMATION29
,      P_PPM_INFORMATION30
,      P_COMMENT_ID
,      P_EXTERNAL_ACCOUNT_ID
,      P_EFFECTIVE_START_DATE
,      P_EFFECTIVE_END_DATE
,      P_PERSONAL_PAY_METHOD_USER_KEY
,      P_PAYEE_ORG
,      P_PAYEE_PERSON_USER_KEY
,      P_LANGUAGE_CODE
FROM APPS.HRDPV_UPDATE_PERSONAL_PAY_METH;

Dependencies

[top of page]

APPS.HRDPV_UPDATE_PERSONAL_PAY_METH references the following:

SchemaAPPS
SynonymHR_PUMP_BATCH_LINES

APPS.HRDPV_UPDATE_PERSONAL_PAY_METH is not referenced by any database object