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.

[Home] [Help]

View: PAYBV_ORG_PAYMENT_METHODS_F_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAYBV_ORG_PAYMENT_METHODS_F_V

View Text

SELECT POPM.EFFECTIVE_START_DATE
, POPM.EFFECTIVE_END_DATE
, POPM.CURRENCY_CODE
, POPM.ORG_PAYMENT_METHOD_NAME /* DESCRIPTIVE FLEXFIELD */
, '_DF:PAY:PAY_ORG_PAYMENT_METHODS:POPM'
, POPM.ATTRIBUTE_CATEGORY
, POPM.ATTRIBUTE1
, POPM.ATTRIBUTE2
, POPM.ATTRIBUTE3
, POPM.ATTRIBUTE4
, POPM.ATTRIBUTE5
, POPM.ATTRIBUTE6
, POPM.ATTRIBUTE7
, POPM.ATTRIBUTE8
, POPM.ATTRIBUTE9
, POPM.ATTRIBUTE10
, POPM.ATTRIBUTE11
, POPM.ATTRIBUTE12
, POPM.ATTRIBUTE13
, POPM.ATTRIBUTE14
, POPM.ATTRIBUTE15
, POPM.ATTRIBUTE16
, POPM.ATTRIBUTE17
, POPM.ATTRIBUTE18
, POPM.ATTRIBUTE19
, POPM.ATTRIBUTE20
, '_DF:PAY:PAYMETH DEVELOPER DF:POPM'
, /* ID COLUMNS */ POPM.PMETH_INFORMATION_CATEGORY
, POPM.PMETH_INFORMATION1
, POPM.PMETH_INFORMATION2
, POPM.PMETH_INFORMATION3
, POPM.PMETH_INFORMATION4
, POPM.PMETH_INFORMATION5
, POPM.PMETH_INFORMATION6
, POPM.PMETH_INFORMATION7
, POPM.PMETH_INFORMATION8
, POPM.PMETH_INFORMATION9
, POPM.PMETH_INFORMATION10
, POPM.PMETH_INFORMATION11
, POPM.PMETH_INFORMATION12
, POPM.PMETH_INFORMATION13
, POPM.PMETH_INFORMATION14
, POPM.PMETH_INFORMATION15
, POPM.PMETH_INFORMATION16
, POPM.PMETH_INFORMATION17
, POPM.PMETH_INFORMATION18
, POPM.PMETH_INFORMATION19
, POPM.PMETH_INFORMATION20
, POPM.COMMENT_ID
, POPM.PAYMENT_TYPE_ID
, POPM.DEFINED_BALANCE_ID
, POPM.BUSINESS_GROUP_ID
, POPM.EXTERNAL_ACCOUNT_ID
, POPM.ORG_PAYMENT_METHOD_ID /* WHO COLUMNS */
, POPM.LAST_UPDATE_DATE
, POPM.LAST_UPDATED_BY
, POPM.CREATED_BY
, POPM.CREATION_DATE
, CASE WHEN (POPM.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, POPM.BUSINESS_GROUP_ID)) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
, PAY_ADHOC_UTILS_PKG.GET_BANK_DETAILS(POPM.EXTERNAL_ACCOUNT_ID) BANK_DETAILS
FROM PAY_ORG_PAYMENT_METHODS_F POPM
, PAY_ORG_PAYMENT_METHODS_F_TL POPMTL
WHERE POPM.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, POPM.BUSINESS_GROUP_ID)
AND POPM.ORG_PAYMENT_METHOD_ID = POPMTL.ORG_PAYMENT_METHOD_ID
AND POPMTL.LANGUAGE = USERENV('LANG') WITH READ ONLY

Columns

Name
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
CURRENCY_CODE
ORG_PAYMENT_METHOD_NAME
DF:POPM1
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
DF:POPM2
PMETH_INFORMATION_CATEGORY
PMETH_INFORMATION1
PMETH_INFORMATION2
PMETH_INFORMATION3
PMETH_INFORMATION4
PMETH_INFORMATION5
PMETH_INFORMATION6
PMETH_INFORMATION7
PMETH_INFORMATION8
PMETH_INFORMATION9
PMETH_INFORMATION10
PMETH_INFORMATION11
PMETH_INFORMATION12
PMETH_INFORMATION13
PMETH_INFORMATION14
PMETH_INFORMATION15
PMETH_INFORMATION16
PMETH_INFORMATION17
PMETH_INFORMATION18
PMETH_INFORMATION19
PMETH_INFORMATION20
COMMENT_ID
PAYMENT_TYPE_ID
DEFINED_BALANCE_ID
BUSINESS_GROUP_ID
EXTERNAL_ACCOUNT_ID
ORG_PAYMENT_METHOD_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATED_BY
CREATION_DATE
BG_SECURITY_FLAG_CODE
BANK_DETAILS