VIEW: APPS.PAYBV_PERSONAL_PMNT_MTH_F_V

Source

View Text - Preformatted

SELECT PPPM.EFFECTIVE_START_DATE, PPPM.EFFECTIVE_END_DATE , PPPM.AMOUNT, PPPM.PERCENTAGE, PPPM.PRIORITY, PPPM.PAYEE_TYPE, '_DF:PAY:PAY_PERSONAL_PAYMENT_METHODS:PPPM', /* id columns */ PPPM.ATTRIBUTE_CATEGORY, PPPM.ATTRIBUTE1, PPPM.ATTRIBUTE2, PPPM.ATTRIBUTE3, PPPM.ATTRIBUTE4, PPPM.ATTRIBUTE5, PPPM.ATTRIBUTE6, PPPM.ATTRIBUTE7, PPPM.ATTRIBUTE8, PPPM.ATTRIBUTE9, PPPM.ATTRIBUTE10, PPPM.ATTRIBUTE11, PPPM.ATTRIBUTE12, PPPM.ATTRIBUTE13, PPPM.ATTRIBUTE14, PPPM.ATTRIBUTE15, PPPM.ATTRIBUTE16, PPPM.ATTRIBUTE17, PPPM.ATTRIBUTE18, PPPM.ATTRIBUTE19, PPPM.ATTRIBUTE20, PPPM.COMMENT_ID , PPPM.PERSONAL_PAYMENT_METHOD_ID , PPPM.BUSINESS_GROUP_ID , PPPM.EXTERNAL_ACCOUNT_ID , PPPM.ASSIGNMENT_ID , PPPM.ORG_PAYMENT_METHOD_ID , PPPM.PAYEE_ID , PPPM.PERSON_ID , PPPM.RUN_TYPE_ID /* who columns */ , PPPM.LAST_UPDATE_DATE , PPPM.LAST_UPDATED_BY , PPPM.CREATED_BY , PPPM.CREATION_DATE , CASE WHEN (pppm.business_group_id = nvl(hr_bis.get_sec_profile_bg_id, pppm.business_group_id)) THEN 'Y' ELSE 'N' END bg_security_flag_code, PAY_ADHOC_UTILS_PKG.GET_BANK_DETAILS(PPPM.EXTERNAL_ACCOUNT_ID) BANK_DETAILS FROM PAY_PERSONAL_PAYMENT_METHODS_F PPPM WHERE PPPM.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PPPM.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT PPPM.EFFECTIVE_START_DATE
, PPPM.EFFECTIVE_END_DATE
, PPPM.AMOUNT
, PPPM.PERCENTAGE
, PPPM.PRIORITY
, PPPM.PAYEE_TYPE
, '_DF:PAY:PAY_PERSONAL_PAYMENT_METHODS:PPPM'
, /* ID COLUMNS */ PPPM.ATTRIBUTE_CATEGORY
, PPPM.ATTRIBUTE1
, PPPM.ATTRIBUTE2
, PPPM.ATTRIBUTE3
, PPPM.ATTRIBUTE4
, PPPM.ATTRIBUTE5
, PPPM.ATTRIBUTE6
, PPPM.ATTRIBUTE7
, PPPM.ATTRIBUTE8
, PPPM.ATTRIBUTE9
, PPPM.ATTRIBUTE10
, PPPM.ATTRIBUTE11
, PPPM.ATTRIBUTE12
, PPPM.ATTRIBUTE13
, PPPM.ATTRIBUTE14
, PPPM.ATTRIBUTE15
, PPPM.ATTRIBUTE16
, PPPM.ATTRIBUTE17
, PPPM.ATTRIBUTE18
, PPPM.ATTRIBUTE19
, PPPM.ATTRIBUTE20
, PPPM.COMMENT_ID
, PPPM.PERSONAL_PAYMENT_METHOD_ID
, PPPM.BUSINESS_GROUP_ID
, PPPM.EXTERNAL_ACCOUNT_ID
, PPPM.ASSIGNMENT_ID
, PPPM.ORG_PAYMENT_METHOD_ID
, PPPM.PAYEE_ID
, PPPM.PERSON_ID
, PPPM.RUN_TYPE_ID /* WHO COLUMNS */
, PPPM.LAST_UPDATE_DATE
, PPPM.LAST_UPDATED_BY
, PPPM.CREATED_BY
, PPPM.CREATION_DATE
, CASE WHEN (PPPM.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PPPM.BUSINESS_GROUP_ID)) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
, PAY_ADHOC_UTILS_PKG.GET_BANK_DETAILS(PPPM.EXTERNAL_ACCOUNT_ID) BANK_DETAILS
FROM PAY_PERSONAL_PAYMENT_METHODS_F PPPM
WHERE PPPM.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PPPM.BUSINESS_GROUP_ID) WITH READ ONLY