VIEW: APPS.PAYBV_ORG_PAYMENT_METHODS_F_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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