VIEW: APPS.HRFV_BACKFEED_BALANCE_AMOUNTS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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