View: PER_BF_PAYMENT_DETAILS_V2

Product:	PER - Human Resources
Description:
Implementation/DBA Data:	APPS.PER_BF_PAYMENT_DETAILS_V2

View Text

SELECT /* UNIQUE ATTRIBUTES */ ORG.NAME
, PPY.PAYROLL_NAME
, BPR.PAYROLL_IDENTIFIER
, ASG.ASSIGNMENT_NUMBER
, PEO.EMPLOYEE_NUMBER /* REGULAR ATTRIBUTES */
, PEO.FULL_NAME
, BPR.PERIOD_START_DATE
, BPR.PERIOD_END_DATE
, BPR.PROCESSING_DATE
, BPD.CHECK_NUMBER
, BPD.PAYMENT_DATE
, BPD.AMOUNT
, HR_GENERAL.DECODE_LOOKUP('BACKFEED_PD_CHECK_TYPE'
, BPD.CHECK_TYPE)
, POPM.ORG_PAYMENT_METHOD_NAME
, PPT.PAYMENT_TYPE_NAME
, POPM.CURRENCY_CODE /* FOREIGN KEY RESOLUTIONS */ /* ID'S */
, PEO.PERSON_ID
, ASG.ASSIGNMENT_ID
, PPY.PAYROLL_ID
, BPR.PAYROLL_RUN_ID
, BPD.PAYMENT_DETAIL_ID
, PPM.PERSONAL_PAYMENT_METHOD_ID
, ASG.ORGANIZATION_ID
, ASG.LOCATION_ID
, ASG.PEOPLE_GROUP_ID
, ASG.JOB_ID
, ASG.GRADE_ID
, ASG.POSITION_ID
, PPG.SEGMENT1
, PPG.SEGMENT2
, PPG.SEGMENT3
, PPG.SEGMENT4
, PPG.SEGMENT5
, PPG.SEGMENT6
, PPG.SEGMENT7
, PPG.SEGMENT8
, PPG.SEGMENT9
, PPG.SEGMENT10
, PPG.SEGMENT11
, PPG.SEGMENT12
, PPG.SEGMENT13
, PPG.SEGMENT14
, PPG.SEGMENT15
, PPG.SEGMENT16
, PPG.SEGMENT17
, PPG.SEGMENT18
, PPG.SEGMENT19
, PPG.SEGMENT20
, PPG.SEGMENT21
, PPG.SEGMENT22
, PPG.SEGMENT23
, PPG.SEGMENT24
, PPG.SEGMENT25
, PPG.SEGMENT26
, PPG.SEGMENT27
, PPG.SEGMENT28
, PPG.SEGMENT29
, PPG.SEGMENT30 /*DESCRIPTIVE FLEXFIELD COLUMNS*/
, BPD.BPD_ATTRIBUTE_CATEGORY
, BPD.BPD_ATTRIBUTE1
, BPD.BPD_ATTRIBUTE2
, BPD.BPD_ATTRIBUTE3
, BPD.BPD_ATTRIBUTE4
, BPD.BPD_ATTRIBUTE5
, BPD.BPD_ATTRIBUTE6
, BPD.BPD_ATTRIBUTE7
, BPD.BPD_ATTRIBUTE8
, BPD.BPD_ATTRIBUTE9
, BPD.BPD_ATTRIBUTE10
, BPD.BPD_ATTRIBUTE11
, BPD.BPD_ATTRIBUTE12
, BPD.BPD_ATTRIBUTE13
, BPD.BPD_ATTRIBUTE14
, BPD.BPD_ATTRIBUTE15
, BPD.BPD_ATTRIBUTE16
, BPD.BPD_ATTRIBUTE17
, BPD.BPD_ATTRIBUTE18
, BPD.BPD_ATTRIBUTE19
, BPD.BPD_ATTRIBUTE20
, BPD.BPD_ATTRIBUTE21
, BPD.BPD_ATTRIBUTE22
, BPD.BPD_ATTRIBUTE23
, BPD.BPD_ATTRIBUTE24
, BPD.BPD_ATTRIBUTE25
, BPD.BPD_ATTRIBUTE26
, BPD.BPD_ATTRIBUTE27
, BPD.BPD_ATTRIBUTE28
, BPD.BPD_ATTRIBUTE29
, BPD.BPD_ATTRIBUTE30
FROM PER_PEOPLE_F PEO
, PAY_PEOPLE_GROUPS PPG
, PER_ALL_ASSIGNMENTS_F ASG
, PER_BUSINESS_GROUPS ORG
, PAY_PAYMENT_TYPES PPT
, PAY_ORG_PAYMENT_METHODS_F POPM
, PAY_PERSONAL_PAYMENT_METHODS_F PPM
, PER_BF_PAYMENT_DETAILS BPD
, PER_BF_PROCESSED_ASSIGNMENTS BPA
, PER_BF_PAYROLL_RUNS BPR
, PAY_ALL_PAYROLLS_F PPY
WHERE ORG.BUSINESS_GROUP_ID = BPR.BUSINESS_GROUP_ID
AND PPY.PAYROLL_ID = BPR.PAYROLL_ID
AND BPR.PAYROLL_RUN_ID = BPA.PAYROLL_RUN_ID
AND BPA.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID
AND PPG.PEOPLE_GROUP_ID (+) = ASG.PEOPLE_GROUP_ID
AND PEO.PERSON_ID = ASG.PERSON_ID
AND BPA.PROCESSED_ASSIGNMENT_ID = BPD.PROCESSED_ASSIGNMENT_ID
AND BPD.PERSONAL_PAYMENT_METHOD_ID = PPM.PERSONAL_PAYMENT_METHOD_ID
AND PPM.ORG_PAYMENT_METHOD_ID = POPM.ORG_PAYMENT_METHOD_ID
AND POPM.PAYMENT_TYPE_ID = PPT.PAYMENT_TYPE_ID
AND TRUNC(SYSDATE) BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN POPM.EFFECTIVE_START_DATE
AND POPM.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN PPM.EFFECTIVE_START_DATE
AND PPM.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN PPY.EFFECTIVE_START_DATE
AND PPY.EFFECTIVE_END_DATE WITH READ ONLY

Columns