Product: | PER - Human Resources |
---|---|
Description: | Business view template from which the flexfield view is generated. |
Implementation/DBA Data: |
![]() |
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
, HBE.UNITS))
, NVL(BBT.CURRENCY
, HBE.CURRENCY_CODE)
, HBE.ELEMENT_REPORTING_NAME
, HBE.ELEMENT_NAME
, HBE.INPUT_VALUE_NAME
, HR_GENERAL.DECODE_LOOKUP('BACKFEED_BT_CATEGORY'
, BBT.CATEGORY)
, BBT.DATE_FROM
, BBT.DATE_TO /* FOREIGN KEY RESOLUTIONS */ /* DESCRIPTIVE FLEXFIELD COLUMNS */
, '_DF:PER:PER_BF_BALANCE_AMOUNTS:BBA'
, '_DF:PER:PER_BF_PROCESSED_ASSIGNMENTS:BPA'
, '_DF:PER:PER_BF_PAYROLL_RUNS:BPR' /* ID'S */
, PEO.PERSON_ID
, ASG.ASSIGNMENT_ID
, PPY.PAYROLL_ID
, HBE.INPUT_VALUE_ID
, HBE.ELEMENT_TYPE_ID
, BPR.PAYROLL_RUN_ID
, BPA.PROCESSED_ASSIGNMENT_ID
, BBA.BALANCE_AMOUNT_ID
, BBT.BALANCE_TYPE_ID
FROM HRBV_BACKFEED_BALANCE_ELEMENTS HBE
, PER_PEOPLE_F PEO
, 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 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 = HBE.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