View: PAYBV_PERSONAL_PMNT_MTH_F_V

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

View Text

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

Columns