[Home] [Help]
View: HR_H2PI_ORG_PAYMENT_METHODS_V
Product: | PER - Human Resources |
Description: | Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for organization payment methods |
Implementation/DBA Data: |
APPS.HR_H2PI_ORG_PAYMENT_METHODS_V
|
View Text
SELECT OPM.LAST_UPDATE_DATE
, OPM.ORG_PAYMENT_METHOD_ID
, OPM.BUSINESS_GROUP_ID
, OPM.ORG_PAYMENT_METHOD_NAME
, OPM.EFFECTIVE_START_DATE
, OPM.EFFECTIVE_END_DATE
, OPM.CURRENCY_CODE
, OPM.EXTERNAL_ACCOUNT_ID
, PYT.PAYMENT_TYPE_NAME
, PYT.TERRITORY_CODE
FROM PAY_ORG_PAYMENT_METHODS_F OPM
, PAY_PAYMENT_TYPES PYT
WHERE OPM.PAYMENT_TYPE_ID = PYT.PAYMENT_TYPE_ID
AND OPM.ATTRIBUTE2 = 'Y'
Columns
Name |
LAST_UPD_DATE |
ORG_PAYMENT_METHOD_ID |
BUSINESS_GROUP_ID |
ORG_PAYMENT_METHOD_NAME |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
CURRENCY_CODE |
EXTERNAL_ACCOUNT_ID |
PAYMENT_TYPE_NAME |
TERRITORY_CODE |