VIEW: APPS.PAY_US_FED_LIABILITIES_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 , PETV.ELEMENT_NAME , PETV.ELEMENT_TYPE_ID , PETV.EFFECTIVE_START_DATE , PETV.EFFECTIVE_END_DATE , PETV.BUSINESS_GROUP_ID , PETV.PROCESSING_PRIORITY , PETV.LEGISLATION_CODE , 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_LIABILITY_TYPES_V PETV 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 EXISTS (SELECT 'x' FROM pay_run_balances prb, pay_bal_attribute_definitions pbad, pay_balance_attributes pba Where 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 = pba.defined_balance_id AND pba.attribute_id = pbad.attribute_id AND pbad.attribute_name = 'PAY_US_FED_LIABILITIES' AND pbad.business_group_id IS NULL AND pbad.legislation_code = 'US' )

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
, PETV.ELEMENT_NAME
, PETV.ELEMENT_TYPE_ID
, PETV.EFFECTIVE_START_DATE
, PETV.EFFECTIVE_END_DATE
, PETV.BUSINESS_GROUP_ID
, PETV.PROCESSING_PRIORITY
, PETV.LEGISLATION_CODE
, 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_LIABILITY_TYPES_V PETV
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 EXISTS (SELECT 'X'
FROM PAY_RUN_BALANCES PRB
, PAY_BAL_ATTRIBUTE_DEFINITIONS PBAD
, PAY_BALANCE_ATTRIBUTES PBA
WHERE 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 = PBA.DEFINED_BALANCE_ID
AND PBA.ATTRIBUTE_ID = PBAD.ATTRIBUTE_ID
AND PBAD.ATTRIBUTE_NAME = 'PAY_US_FED_LIABILITIES'
AND PBAD.BUSINESS_GROUP_ID IS NULL
AND PBAD.LEGISLATION_CODE = 'US' )