eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PAY_US_FED_TAXES_RBR_V

Source

View Text - Preformatted


SELECT PAA.ASSIGNMENT_ID , PAA.TAX_UNIT_ID , PAA.ASSIGNMENT_ACTION_ID , PAA.ACTION_STATUS , PAA.PAYROLL_ACTION_ID , PPA.ACTION_TYPE , PPA.EFFECTIVE_DATE , PETV.TAX_TYPE_ID , PETV.EE_OR_ER_CODE , PETV.LIMIT_TAX_FLAG , PETV.TAX_DOMAIN_CODE ,PETV.TAX_TYPE_CODE , PETV.BALANCE_CATEGORY_CODE , PETV.USER_REPORTING_NAME , PPA.BUSINESS_GROUP_ID , PAY_US_BALANCE_VIEW_PKG.GET_VIEW_MODE VIEW_MODE , PAY_US_BALANCE_VIEW_PKG.GET_CALC_ALL_TIMETYPES_FLAG CALC_ALL_TIMETYPES , PAY_US_TAXBAL_VIEW_PKG.US_TAX_BALANCE_VM (PETV.BALANCE_CATEGORY_CODE, PETV.TAX_TYPE_CODE, PETV.EE_OR_ER_CODE, 'CURRENT', PAA.TAX_UNIT_ID, '00-000-0000', PAA.ASSIGNMENT_ACTION_ID, PAA.ASSIGNMENT_ID, PPA.DATE_EARNED, PAA.PAYROLL_ACTION_ID) CURRENT_VAL , PAY_US_TAXBAL_VIEW_PKG.US_TAX_BALANCE_VM (PETV.BALANCE_CATEGORY_CODE, PETV.TAX_TYPE_CODE, PETV.EE_OR_ER_CODE, 'RUN', PAA.TAX_UNIT_ID, '00-000-0000', PAA.ASSIGNMENT_ACTION_ID, PAA.ASSIGNMENT_ID, PPA.DATE_EARNED, PAA.PAYROLL_ACTION_ID) RUN_VAL , PAY_US_TAXBAL_VIEW_PKG.US_TAX_BALANCE_VM (PETV.BALANCE_CATEGORY_CODE, PETV.TAX_TYPE_CODE,PETV.EE_OR_ER_CODE, 'QTD', PAA.TAX_UNIT_ID, '00-000-0000', PAA.ASSIGNMENT_ACTION_ID, PAA.ASSIGNMENT_ID, PPA.DATE_EARNED, PAA.PAYROLL_ACTION_ID) QTD_VAL , PAY_US_TAXBAL_VIEW_PKG.US_TAX_BALANCE_VM (PETV.BALANCE_CATEGORY_CODE, PETV.TAX_TYPE_CODE, PETV.EE_OR_ER_CODE, 'YTD', PAA.TAX_UNIT_ID, '00-000-0000', PAA.ASSIGNMENT_ACTION_ID, PAA.ASSIGNMENT_ID, PPA.DATE_EARNED, PAA.PAYROLL_ACTION_ID) YTD_VAL FROM PAY_ASSIGNMENT_ACTIONS PAA , PAY_PAYROLL_ACTIONS PPA , PAY_US_FED_TAX_TYPES_V PETV , PAY_BAL_ATTRIBUTE_DEFINITIONS PBAD , PAY_BALANCE_ATTRIBUTES PBA , PAY_DEFINED_BALANCES PDB WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID AND PPA.ACTION_TYPE IN ('Q', 'R', 'V', 'B', 'I') AND NVL(PPA.DATE_EARNED, PPA.EFFECTIVE_DATE) BETWEEN PETV.EFFECTIVE_START_DATE AND PETV.EFFECTIVE_END_DATE AND pbad.attribute_name = 'PAY_US_TAX_DEDN_FED' AND pbad.business_group_id IS NULL AND pbad.legislation_code = 'US' AND pbad.attribute_id = pba.attribute_id AND PDB.DEFINED_BALANCE_ID = PBA.DEFINED_BALANCE_ID AND PDB.BALANCE_TYPE_ID = PETV.BALANCE_TYPE_ID AND EXISTS (SELECT 'x' FROM pay_balance_feeds_f pbf , pay_input_values_f piv , pay_run_balances prb Where prb.defined_balance_id = pba.defined_balance_id AND prb.assignment_id = paa.assignment_id AND prb.tax_unit_id = paa.tax_unit_id AND prb.effective_date between trunc(ppa.effective_date,'Y') and ppa.effective_date AND prb.defined_balance_id = pdb.defined_balance_id AND pdb.balance_type_id = pbf.balance_type_id AND prb.effective_date between pbf.effective_start_date and pbf.effective_end_date AND pbf.input_value_id = piv.input_value_id AND prb.effective_date between piv.effective_start_date and piv.effective_end_date AND piv.element_type_id = petv.element_type_id )

View Text - HTML Formatted

SELECT PAA.ASSIGNMENT_ID
, PAA.TAX_UNIT_ID
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ACTION_STATUS
, PAA.PAYROLL_ACTION_ID
, PPA.ACTION_TYPE
, PPA.EFFECTIVE_DATE
, PETV.TAX_TYPE_ID
, PETV.EE_OR_ER_CODE
, PETV.LIMIT_TAX_FLAG
, PETV.TAX_DOMAIN_CODE
, PETV.TAX_TYPE_CODE
, PETV.BALANCE_CATEGORY_CODE
, PETV.USER_REPORTING_NAME
, PPA.BUSINESS_GROUP_ID
, PAY_US_BALANCE_VIEW_PKG.GET_VIEW_MODE VIEW_MODE
, PAY_US_BALANCE_VIEW_PKG.GET_CALC_ALL_TIMETYPES_FLAG CALC_ALL_TIMETYPES
, PAY_US_TAXBAL_VIEW_PKG.US_TAX_BALANCE_VM (PETV.BALANCE_CATEGORY_CODE
, PETV.TAX_TYPE_CODE
, PETV.EE_OR_ER_CODE
, 'CURRENT'
, PAA.TAX_UNIT_ID
, '00-000-0000'
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, PPA.DATE_EARNED
, PAA.PAYROLL_ACTION_ID) CURRENT_VAL
, PAY_US_TAXBAL_VIEW_PKG.US_TAX_BALANCE_VM (PETV.BALANCE_CATEGORY_CODE
, PETV.TAX_TYPE_CODE
, PETV.EE_OR_ER_CODE
, 'RUN'
, PAA.TAX_UNIT_ID
, '00-000-0000'
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, PPA.DATE_EARNED
, PAA.PAYROLL_ACTION_ID) RUN_VAL
, PAY_US_TAXBAL_VIEW_PKG.US_TAX_BALANCE_VM (PETV.BALANCE_CATEGORY_CODE
, PETV.TAX_TYPE_CODE
, PETV.EE_OR_ER_CODE
, 'QTD'
, PAA.TAX_UNIT_ID
, '00-000-0000'
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, PPA.DATE_EARNED
, PAA.PAYROLL_ACTION_ID) QTD_VAL
, PAY_US_TAXBAL_VIEW_PKG.US_TAX_BALANCE_VM (PETV.BALANCE_CATEGORY_CODE
, PETV.TAX_TYPE_CODE
, PETV.EE_OR_ER_CODE
, 'YTD'
, PAA.TAX_UNIT_ID
, '00-000-0000'
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, PPA.DATE_EARNED
, PAA.PAYROLL_ACTION_ID) YTD_VAL
FROM PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
, PAY_US_FED_TAX_TYPES_V PETV
, PAY_BAL_ATTRIBUTE_DEFINITIONS PBAD
, PAY_BALANCE_ATTRIBUTES PBA
, PAY_DEFINED_BALANCES PDB
WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PPA.ACTION_TYPE IN ('Q'
, 'R'
, 'V'
, 'B'
, 'I')
AND NVL(PPA.DATE_EARNED
, PPA.EFFECTIVE_DATE) BETWEEN PETV.EFFECTIVE_START_DATE
AND PETV.EFFECTIVE_END_DATE
AND PBAD.ATTRIBUTE_NAME = 'PAY_US_TAX_DEDN_FED'
AND PBAD.BUSINESS_GROUP_ID IS NULL
AND PBAD.LEGISLATION_CODE = 'US'
AND PBAD.ATTRIBUTE_ID = PBA.ATTRIBUTE_ID
AND PDB.DEFINED_BALANCE_ID = PBA.DEFINED_BALANCE_ID
AND PDB.BALANCE_TYPE_ID = PETV.BALANCE_TYPE_ID
AND EXISTS (SELECT 'X'
FROM PAY_BALANCE_FEEDS_F PBF
, PAY_INPUT_VALUES_F PIV
, PAY_RUN_BALANCES PRB
WHERE PRB.DEFINED_BALANCE_ID = PBA.DEFINED_BALANCE_ID
AND PRB.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND PRB.TAX_UNIT_ID = PAA.TAX_UNIT_ID
AND PRB.EFFECTIVE_DATE BETWEEN TRUNC(PPA.EFFECTIVE_DATE
, 'Y')
AND PPA.EFFECTIVE_DATE
AND PRB.DEFINED_BALANCE_ID = PDB.DEFINED_BALANCE_ID
AND PDB.BALANCE_TYPE_ID = PBF.BALANCE_TYPE_ID
AND PRB.EFFECTIVE_DATE BETWEEN PBF.EFFECTIVE_START_DATE
AND PBF.EFFECTIVE_END_DATE
AND PBF.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID
AND PRB.EFFECTIVE_DATE BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE
AND PIV.ELEMENT_TYPE_ID = PETV.ELEMENT_TYPE_ID )