Product: | PAY - Payroll |
---|---|
Description: | Date-effective view. |
Implementation/DBA Data: | APPS.PAY_ORG_PAYMENT_METHODS |
SELECT OPM.ORG_PAYMENT_METHOD_ID
, OPM.EFFECTIVE_START_DATE
, OPM.EFFECTIVE_END_DATE
, OPM.BUSINESS_GROUP_ID
, OPM.EXTERNAL_ACCOUNT_ID
, OPM.CURRENCY_CODE
, OPM.PAYMENT_TYPE_ID
, OPM.DEFINED_BALANCE_ID
, OPMTL.ORG_PAYMENT_METHOD_NAME
, OPM.COMMENT_ID
, OPM.ATTRIBUTE_CATEGORY
, OPM.ATTRIBUTE1
, OPM.ATTRIBUTE2
, OPM.ATTRIBUTE3
, OPM.ATTRIBUTE4
, OPM.ATTRIBUTE5
, OPM.ATTRIBUTE6
, OPM.ATTRIBUTE7
, OPM.ATTRIBUTE8
, OPM.ATTRIBUTE9
, OPM.ATTRIBUTE10
, OPM.ATTRIBUTE11
, OPM.ATTRIBUTE12
, OPM.ATTRIBUTE13
, OPM.ATTRIBUTE14
, OPM.ATTRIBUTE15
, OPM.ATTRIBUTE16
, OPM.ATTRIBUTE17
, OPM.ATTRIBUTE18
, OPM.ATTRIBUTE19
, OPM.ATTRIBUTE20
, OPM.LAST_UPDATE_DATE
, OPM.LAST_UPDATED_BY
, OPM.LAST_UPDATE_LOGIN
, OPM.CREATED_BY
, OPM.CREATION_DATE
, OPM.PMETH_INFORMATION_CATEGORY
, OPM.PMETH_INFORMATION1
, OPM.PMETH_INFORMATION2
, OPM.PMETH_INFORMATION3
, OPM.PMETH_INFORMATION4
, OPM.PMETH_INFORMATION5
, OPM.PMETH_INFORMATION6
, OPM.PMETH_INFORMATION7
, OPM.PMETH_INFORMATION8
, OPM.PMETH_INFORMATION9
, OPM.PMETH_INFORMATION10
, OPM.PMETH_INFORMATION11
, OPM.PMETH_INFORMATION12
, OPM.PMETH_INFORMATION13
, OPM.PMETH_INFORMATION14
, OPM.PMETH_INFORMATION15
, OPM.PMETH_INFORMATION16
, OPM.PMETH_INFORMATION17
, OPM.PMETH_INFORMATION18
, OPM.PMETH_INFORMATION19
, OPM.PMETH_INFORMATION20
, OPM.ORG_PAYMENT_METHOD_NAME SYSTEM_ORG_PAY_METHOD_NAME
FROM PAY_ORG_PAYMENT_METHODS_F OPM
, PAY_ORG_PAYMENT_METHODS_F_TL OPMTL
WHERE OPM.ORG_PAYMENT_METHOD_ID = OPMTL.ORG_PAYMENT_METHOD_ID
AND OPMTL.LANGUAGE = USERENV('LANG')
AND EFFECTIVE_START_DATE <= ( SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EFFECTIVE_END_DATE >= (SELECT SE.EFFECTIVE_DATE
FROM FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID'))