View: PER_BF_BALANCE_AMOUNTS_V2

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

View Text

SELECT /* UNIQUE ATTRIBUTES */ BUS.NAME
, PPY.PAYROLL_NAME
, BPR.PAYROLL_IDENTIFIER
, ASG.ASSIGNMENT_NUMBER
, PEO.EMPLOYEE_NUMBER
, BBT.INTERNAL_NAME /* REGULAR ATTRIBUTES */
, PEO.FULL_NAME
, BPR.PERIOD_START_DATE
, BPR.PERIOD_END_DATE
, BPR.PROCESSING_DATE
, BBA.YTD_AMOUNT
, BBA.FYTD_AMOUNT
, BBA.PTD_AMOUNT
, BBA.MTD_AMOUNT
, BBA.QTD_AMOUNT
, BBA.RUN_AMOUNT
, BBT.DISPLAYED_NAME
, HR_GENERAL.DECODE_LOOKUP('UNITS'
, NVL(BBT.UOM
, PBE.UNITS))
, NVL(BBT.CURRENCY
, PBE.CURRENCY_CODE)
, PBE.ELEMENT_REPORTING_NAME
, PBE.ELEMENT_NAME
, PBE.INPUT_VALUE_NAME
, HR_GENERAL.DECODE_LOOKUP('BACKFEED_BT_CATEGORY'
, BBT.CATEGORY)
, BBT.DATE_FROM
, BBT.DATE_TO /* FOREIGN KEY RESOLUTIONS */ /* ID'S */
, PEO.PERSON_ID
, ASG.ASSIGNMENT_ID
, PPY.PAYROLL_ID
, PBE.INPUT_VALUE_ID
, PBE.ELEMENT_TYPE_ID
, BPR.PAYROLL_RUN_ID
, BPA.PROCESSED_ASSIGNMENT_ID
, BBA.BALANCE_AMOUNT_ID
, BBT.BALANCE_TYPE_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*/
, BBA.BBA_ATTRIBUTE_CATEGORY
, BBA.BBA_ATTRIBUTE1
, BBA.BBA_ATTRIBUTE2
, BBA.BBA_ATTRIBUTE3
, BBA.BBA_ATTRIBUTE4
, BBA.BBA_ATTRIBUTE5
, BBA.BBA_ATTRIBUTE6
, BBA.BBA_ATTRIBUTE7
, BBA.BBA_ATTRIBUTE8
, BBA.BBA_ATTRIBUTE9
, BBA.BBA_ATTRIBUTE10
, BBA.BBA_ATTRIBUTE11
, BBA.BBA_ATTRIBUTE12
, BBA.BBA_ATTRIBUTE13
, BBA.BBA_ATTRIBUTE14
, BBA.BBA_ATTRIBUTE15
, BBA.BBA_ATTRIBUTE16
, BBA.BBA_ATTRIBUTE17
, BBA.BBA_ATTRIBUTE18
, BBA.BBA_ATTRIBUTE19
, BBA.BBA_ATTRIBUTE20
, BBA.BBA_ATTRIBUTE21
, BBA.BBA_ATTRIBUTE22
, BBA.BBA_ATTRIBUTE23
, BBA.BBA_ATTRIBUTE24
, BBA.BBA_ATTRIBUTE25
, BBA.BBA_ATTRIBUTE26
, BBA.BBA_ATTRIBUTE27
, BBA.BBA_ATTRIBUTE28
, BBA.BBA_ATTRIBUTE29
, BBA.BBA_ATTRIBUTE30
FROM PER_BF_BALANCE_ELEMENTS_V PBE
, PER_PEOPLE_F PEO
, PAY_PEOPLE_GROUPS PPG
, PER_ALL_ASSIGNMENTS_F ASG
, PER_BUSINESS_GROUPS BUS
, PER_BF_BALANCE_TYPES BBT
, PER_BF_BALANCE_AMOUNTS BBA
, PER_BF_PROCESSED_ASSIGNMENTS BPA
, PER_BF_PAYROLL_RUNS BPR
, PAY_ALL_PAYROLLS_F PPY
WHERE BUS.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 = BBA.PROCESSED_ASSIGNMENT_ID
AND BBA.BALANCE_TYPE_ID = BBT.BALANCE_TYPE_ID
AND BBT.BALANCE_TYPE_ID = PBE.BALANCE_TYPE_ID (+)
AND TRUNC(SYSDATE) BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.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