eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: HR.PAY_PRE_PAYMENTS

Object Details

Object Name:	PAY_PRE_PAYMENTS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PAY.PAY_PRE_PAYMENTS
Subobject Name:
Status:	VALID

PAY_PRE_PAYMENTS holds details of the amount to be paid in the payment
currency, using the designated payment method for the assignment. It
also records how the payment should be made.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PAY_PRE_PAYMENTS_PK

PRE_PAYMENT_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_PRE_PAYMENTS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PRE_PAYMENT_ID
PAY_PRE_PAYMENTS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_ACTION_ID
PAY_PRE_PAYMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSONAL_PAYMENT_METHOD_ID
PAY_PRE_PAYMENTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORG_PAYMENT_METHOD_ID
PAY_PRE_PAYMENTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYROLL_ACTION_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PAY_PRE_PAYMENTS	PAY_ASSIGNMENT_ACTIONS	PAY_PRE_PAYMENTS ASSIGNMENT_ACTION_ID
PAY_ASSIGNMENT_ACTIONS	PAY_PRE_PAYMENTS	PAY_ASSIGNMENT_ACTIONS PRE_PAYMENT_ID
PAY_COIN_ANAL_ELEMENTS	PAY_PRE_PAYMENTS	PAY_COIN_ANAL_ELEMENTS PRE_PAYMENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PRE_PAYMENT_ID	NUMBER	(15)	Yes	System-generated primary key column.
PERSONAL_PAYMENT_METHOD_ID	NUMBER	(9)		Foreign key to PAY_PERSONAL_PAYMENT_METHODS.
ASSIGNMENT_ACTION_ID	NUMBER	(15)		Foreign key to PAY_ASSIGNMENT_ACTIONS.
ORG_PAYMENT_METHOD_ID	NUMBER	(9)	Yes	Foreign key to PAY_ORG_PAYMENT_METHODS.
VALUE	NUMBER		Yes	Value of payment in target currency.
BASE_CURRENCY_VALUE	NUMBER			Payment value in base currency.
SOURCE_ACTION_ID	NUMBER	(15)		Foreign Key to PAY_ASSIGNMENT_ACTIONS. Used, for example, to identify part payments for a particular run type.
PREPAYMENT_ACTION_ID	NUMBER	(15)		Parent prepayment action
PAYROLL_ACTION_ID	NUMBER	(9)		Payroll Action ID
ORGANIZATION_ID	NUMBER	(15)		Foreign key to HR_ALL_ORGANIZATION_UNITS table
PAYEES_ORG_PAYMENT_METHOD_ID	NUMBER	(9)		Payment Method ID
EFFECTIVE_DATE	DATE			Effective Date

Query Text

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


SELECT PRE_PAYMENT_ID
,      PERSONAL_PAYMENT_METHOD_ID
,      ASSIGNMENT_ACTION_ID
,      ORG_PAYMENT_METHOD_ID
,      VALUE
,      BASE_CURRENCY_VALUE
,      SOURCE_ACTION_ID
,      PREPAYMENT_ACTION_ID
,      PAYROLL_ACTION_ID
,      ORGANIZATION_ID
,      PAYEES_ORG_PAYMENT_METHOD_ID
,      EFFECTIVE_DATE
FROM HR.PAY_PRE_PAYMENTS;

Dependencies

[top of page]

HR.PAY_PRE_PAYMENTS does not reference any database object

HR.PAY_PRE_PAYMENTS is referenced by following:

APPS: PAY_PRE_PAYMENTS
PUBLIC: PAY_PRE_PAYMENTS