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