VIEW: APPS.PAY_PERSONAL_PAYMENT_METHODS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'