View: PAY_PERSONAL_PAYMENT_METHODS_V

Product:	PAY - Payroll
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PAY_PERSONAL_PAYMENT_METHODS_V

View Text

SELECT PPM.ROWID ROW_ID
, PPM.PERSONAL_PAYMENT_METHOD_ID
, PPM.EFFECTIVE_START_DATE
, PPM.EFFECTIVE_END_DATE
, PPM.BUSINESS_GROUP_ID
, PPM.EXTERNAL_ACCOUNT_ID
, PPM.ASSIGNMENT_ID
, PPM.ORG_PAYMENT_METHOD_ID
, PPM.AMOUNT
, PPM.COMMENT_ID
, PPM.PERCENTAGE
, PPM.PRIORITY
, PPM.PAYEE_TYPE
, PPM.PAYEE_ID
, PAY_ORG_PAYMENT_METHODS_PKG.PAYEE_TYPE (PPM.PAYEE_TYPE
, PPM.PAYEE_ID
, FF.EFFECTIVE_DATE) PAYEE_NAME
, PPM.ATTRIBUTE_CATEGORY
, PPM.ATTRIBUTE1
, PPM.ATTRIBUTE2
, PPM.ATTRIBUTE3
, PPM.ATTRIBUTE4
, PPM.ATTRIBUTE5
, PPM.ATTRIBUTE6
, PPM.ATTRIBUTE7
, PPM.ATTRIBUTE8
, PPM.ATTRIBUTE9
, PPM.ATTRIBUTE10
, PPM.ATTRIBUTE11
, PPM.ATTRIBUTE12
, PPM.ATTRIBUTE13
, PPM.ATTRIBUTE14
, PPM.ATTRIBUTE15
, PPM.ATTRIBUTE16
, PPM.ATTRIBUTE17
, PPM.ATTRIBUTE18
, PPM.ATTRIBUTE19
, PPM.ATTRIBUTE20
, PPM.LAST_UPDATE_DATE
, PPM.LAST_UPDATED_BY
, PPM.LAST_UPDATE_LOGIN
, PPM.CREATED_BY
, PPM.CREATION_DATE
, OPMTL.ORG_PAYMENT_METHOD_NAME
, OPM.PAYMENT_TYPE_ID
, OPM.CURRENCY_CODE
, OPM.DEFINED_BALANCE_ID
, PTTL.PAYMENT_TYPE_NAME
, PT.TERRITORY_CODE
, PT.CATEGORY
, PT.PRE_VALIDATION_REQUIRED
, C.COMMENT_TEXT
, PEA.PRENOTE_DATE
, PEA.ID_FLEX_NUM
, PBD.BALANCE_TYPE_ID
, PPM.PERSON_ID
, PPM.RUN_TYPE_ID
, PLR.RULE_MODE C_BANK_STRUCTURE
, PA.PAYROLL_ID
, FF.EFFECTIVE_DATE
, PPM.PPM_INFORMATION_CATEGORY
, PPM.PPM_INFORMATION1
, PPM.PPM_INFORMATION2
, PPM.PPM_INFORMATION3
, PPM.PPM_INFORMATION4
, PPM.PPM_INFORMATION5
, PPM.PPM_INFORMATION6
, PPM.PPM_INFORMATION7
, PPM.PPM_INFORMATION8
, PPM.PPM_INFORMATION9
, PPM.PPM_INFORMATION10
, PPM.PPM_INFORMATION11
, PPM.PPM_INFORMATION12
, PPM.PPM_INFORMATION13
, PPM.PPM_INFORMATION14
, PPM.PPM_INFORMATION15
, PPM.PPM_INFORMATION16
, PPM.PPM_INFORMATION17
, PPM.PPM_INFORMATION18
, PPM.PPM_INFORMATION19
, PPM.PPM_INFORMATION20
, PPM.PPM_INFORMATION21
, PPM.PPM_INFORMATION22
, PPM.PPM_INFORMATION23
, PPM.PPM_INFORMATION24
, PPM.PPM_INFORMATION25
, PPM.PPM_INFORMATION26
, PPM.PPM_INFORMATION27
, PPM.PPM_INFORMATION28
, PPM.PPM_INFORMATION29
, PPM.PPM_INFORMATION30
, PPM.OBJECT_VERSION_NUMBER
FROM PAY_ORG_PAYMENT_METHODS_F_TL OPMTL
, PAY_PERSONAL_PAYMENT_METHODS_F PPM
, PAY_ORG_PAYMENT_METHODS_F OPM
, PAY_PAYMENT_TYPES_TL PTTL
, PAY_PAYMENT_TYPES PT
, HR_COMMENTS C
, PAY_EXTERNAL_ACCOUNTS PEA
, PAY_DEFINED_BALANCES PBD
, PER_ALL_ASSIGNMENTS_F PA
, PAY_LEGISLATION_RULES PLR
, FND_SESSIONS FF
WHERE PT.PAYMENT_TYPE_ID = PTTL.PAYMENT_TYPE_ID
AND PTTL.LANGUAGE = USERENV('LANG')
AND OPM.ORG_PAYMENT_METHOD_ID = OPMTL.ORG_PAYMENT_METHOD_ID
AND OPMTL.LANGUAGE = USERENV('LANG')
AND FF.SESSION_ID = USERENV('SESSIONID')
AND FF.EFFECTIVE_DATE BETWEEN PPM.EFFECTIVE_START_DATE
AND PPM.EFFECTIVE_END_DATE
AND FF.EFFECTIVE_DATE BETWEEN OPM.EFFECTIVE_START_DATE
AND OPM.EFFECTIVE_END_DATE
AND FF.EFFECTIVE_DATE BETWEEN PA.EFFECTIVE_START_DATE
AND PA.EFFECTIVE_END_DATE
AND PPM.ORG_PAYMENT_METHOD_ID = OPM.ORG_PAYMENT_METHOD_ID
AND OPM.PAYMENT_TYPE_ID = PT.PAYMENT_TYPE_ID
AND PPM.COMMENT_ID = C.COMMENT_ID(+)
AND PPM.EXTERNAL_ACCOUNT_ID = PEA.EXTERNAL_ACCOUNT_ID (+)
AND OPM.DEFINED_BALANCE_ID = PBD.DEFINED_BALANCE_ID (+)
AND ( (PPM.ASSIGNMENT_ID IS NOT NULL
AND PPM.ASSIGNMENT_ID = PA.ASSIGNMENT_ID) OR (PPM.PERSON_ID IS NOT NULL
AND PPM.PERSON_ID = PA.PERSON_ID) )
AND PT.TERRITORY_CODE = PLR.LEGISLATION_CODE(+)
AND PLR.RULE_TYPE(+) = 'E'

Columns