VIEW: APPS.HR_H2PI_PAYMENT_METHODS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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