View: PER_BF_PAYMENT_DETAILS_V

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

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 /*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
, 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 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