[Home] [Help]
[Dependency Information]
Object Name: | HRFV_PAY_METH_NOT_DIR_DEPOSITS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This view shows the history of payment instructions for current employees. The
payment instructions shown are those that are not direct deposits, which are shown separately.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUSINESS_GROUP_NAME | VARCHAR2 | (240) | Yes | |
PERSON_NAME | VARCHAR2 | (240) | ||
PAYMENT_METHOD | VARCHAR2 | (80) | Yes | |
AMOUNT | NUMBER | |||
PERCENTAGE | NUMBER | (23) | ||
EFFECTIVE_START_DATE | DATE | Yes | ||
EFFECTIVE_END_DATE | DATE | |||
PRIORITY | NUMBER | (15) | ||
PAYEE_TYPE | VARCHAR2 | (4000) | ||
PAYEE_NAME | VARCHAR2 | (240) | ||
PAYMENT_TYPE | VARCHAR2 | (80) | Yes | |
CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
ASSIGNMENT_NUMBER | VARCHAR2 | (30) | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | |
JOB_NAME | VARCHAR2 | (700) | ||
POSITION_NAME | VARCHAR2 | (240) | ||
GRADE_NAME | VARCHAR2 | (240) | ||
LOCATION_NAME | VARCHAR2 | (60) | ||
EMPLOYEE_NUMBER | VARCHAR2 | (30) | ||
_DF | CHAR | (40) | ||
ASSIGNMENT_ID | NUMBER | (10) | Yes | |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
ORG_PAYMENT_METHOD_ID | NUMBER | (9) | Yes | |
PERSON_ID | NUMBER | (10) | Yes | |
PERSONAL_PAYMENT_METHOD_ID | NUMBER | (9) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT BUSINESS_GROUP_NAME
, PERSON_NAME
, PAYMENT_METHOD
, AMOUNT
, PERCENTAGE
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, PRIORITY
, PAYEE_TYPE
, PAYEE_NAME
, PAYMENT_TYPE
, CURRENCY_CODE
, ASSIGNMENT_NUMBER
, ORGANIZATION_NAME
, JOB_NAME
, POSITION_NAME
, GRADE_NAME
, LOCATION_NAME
, EMPLOYEE_NUMBER
, _DF
, ASSIGNMENT_ID
, BUSINESS_GROUP_ID
, ORG_PAYMENT_METHOD_ID
, PERSON_ID
, PERSONAL_PAYMENT_METHOD_ID
FROM APPS.HRFV_PAY_METH_NOT_DIR_DEPOSITS;
APPS.HRFV_PAY_METH_NOT_DIR_DEPOSITS is not referenced by any database object
|
|
|