VIEW: APPS.PAY_US_GTN_DEDUCT_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, deduct.element_name, deduct.element_type_id, deduct.classification_name, deduct.business_group_id, deduct.effective_start_date, deduct.effective_end_date, deduct.legislation_code, deduct.element_information10, deduct.processing_priority, deduct.reporting_name, deduct.reporting_name_alt, pbt.balance_name, pbt.balance_type_id, pbt.balance_uom, 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_named_balance_vm( upper(pbt.balance_name), 'ASG_GRE_RUN', paa.assignment_action_id, paa.assignment_id, ppa.date_earned, paa.tax_unit_id, deduct.business_group_id, null) run_value from pay_assignment_actions paa, pay_payroll_actions ppa, pay_balance_types pbt, pay_us_deduction_types_v deduct WHERE ppa.payroll_action_id = paa.payroll_action_id and deduct.element_information10 is not null and deduct.element_information10 = pbt.balance_type_id and ppa.action_type in('Q', 'R', 'V', 'B', 'I') /* Bug 12637772 : 'B', 'I' have been included in the check. */ and nvl(ppa.date_earned, ppa.effective_date) between deduct.effective_start_date and deduct.effective_end_date and exists( select null from pay_run_results prr where prr.assignment_action_id = paa.assignment_action_id and prr.element_type_id = deduct.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
, DEDUCT.ELEMENT_NAME
, DEDUCT.ELEMENT_TYPE_ID
, DEDUCT.CLASSIFICATION_NAME
, DEDUCT.BUSINESS_GROUP_ID
, DEDUCT.EFFECTIVE_START_DATE
, DEDUCT.EFFECTIVE_END_DATE
, DEDUCT.LEGISLATION_CODE
, DEDUCT.ELEMENT_INFORMATION10
, DEDUCT.PROCESSING_PRIORITY
, DEDUCT.REPORTING_NAME
, DEDUCT.REPORTING_NAME_ALT
, PBT.BALANCE_NAME
, PBT.BALANCE_TYPE_ID
, PBT.BALANCE_UOM
, 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_NAMED_BALANCE_VM( UPPER(PBT.BALANCE_NAME)
, 'ASG_GRE_RUN'
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, PPA.DATE_EARNED
, PAA.TAX_UNIT_ID
, DEDUCT.BUSINESS_GROUP_ID
, NULL) RUN_VALUE
FROM PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
, PAY_BALANCE_TYPES PBT
, PAY_US_DEDUCTION_TYPES_V DEDUCT
WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND DEDUCT.ELEMENT_INFORMATION10 IS NOT NULL
AND DEDUCT.ELEMENT_INFORMATION10 = PBT.BALANCE_TYPE_ID
AND PPA.ACTION_TYPE IN('Q'
, 'R'
, 'V'
, 'B'
, 'I') /* BUG 12637772 : 'B'
, 'I' HAVE BEEN INCLUDED IN THE CHECK. */
AND NVL(PPA.DATE_EARNED
, PPA.EFFECTIVE_DATE) BETWEEN DEDUCT.EFFECTIVE_START_DATE
AND DEDUCT.EFFECTIVE_END_DATE
AND EXISTS( SELECT NULL
FROM PAY_RUN_RESULTS PRR
WHERE PRR.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
AND PRR.ELEMENT_TYPE_ID = DEDUCT.ELEMENT_TYPE_ID)