Product: | PER - Human Resources |
---|---|
Description: | Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for payment methods |
Implementation/DBA Data: | APPS.HR_H2PI_PAYMENT_METHODS_V |
SELECT PPM.LAST_UPDATE_DATE
, PPM.BUSINESS_GROUP_ID
, PPM.PERSONAL_PAYMENT_METHOD_ID
, PPM.ASSIGNMENT_ID
, ASG.PERSON_ID
, PPM.EFFECTIVE_START_DATE
, PPM.EFFECTIVE_END_DATE
, PPM.ORG_PAYMENT_METHOD_ID
, PPM.AMOUNT
, PPM.PERCENTAGE
, PPM.PRIORITY
, 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.PAYEE_ID
, PPM.PAYEE_TYPE
, EXA.TERRITORY_CODE
, EXA.PRENOTE_DATE
, EXA.SEGMENT1
, EXA.SEGMENT2
, EXA.SEGMENT3
, EXA.SEGMENT4
, EXA.SEGMENT5
, EXA.SEGMENT6
, EXA.SEGMENT7
, EXA.SEGMENT8
, EXA.SEGMENT9
, EXA.SEGMENT10
, EXA.SEGMENT11
, EXA.SEGMENT12
, EXA.SEGMENT13
, EXA.SEGMENT14
, EXA.SEGMENT15
, EXA.SEGMENT16
, EXA.SEGMENT17
, EXA.SEGMENT18
, EXA.SEGMENT19
, EXA.SEGMENT20
, EXA.SEGMENT21
, EXA.SEGMENT22
, EXA.SEGMENT23
, EXA.SEGMENT24
, EXA.SEGMENT25
, EXA.SEGMENT26
, EXA.SEGMENT27
, EXA.SEGMENT28
, EXA.SEGMENT29
, EXA.SEGMENT30
FROM PAY_PERSONAL_PAYMENT_METHODS_F PPM
, PAY_EXTERNAL_ACCOUNTS EXA
, HR_H2PI_ASSIGNMENTS_V ASG
WHERE PPM.EXTERNAL_ACCOUNT_ID = EXA.EXTERNAL_ACCOUNT_ID (+)
AND PPM.EFFECTIVE_START_DATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND ASG.ASSIGNMENT_ID = PPM.ASSIGNMENT_ID