Results for “weekly_std_rate_cut_off”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PAY_IE_SOE_PAYE_DETAILS_V is a PL/SQL view owned by the APPS schema in Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It belongs to the Payroll (PAY) product family and is documented as being used by the Irish Statement of Earnings (IE SOE) forms. The view aggregates Irish PAYE (Pay As You Earn) attributes associated with payroll run results so that the SOE report and its supporting forms can display statutory tax credit, standard rate cut-off, tax basis, information source, tax assessment basis, and certificate issue date information for a given assignment action.

The view is read-only and exposes data drawn from payroll run results and their linked input values, enriched with lookup decoding. Because it is a reporting view rather than a base table, it does not store data; it presents a denormalized, single-row-per-assignment-action projection suitable for form-driven and ad-hoc reporting.

Underlying Base Objects

The documented base objects referenced by the view are:

• FND_SESSIONS (synonym) — supplies the current application session context used by the driving hint and to scope the query.
• HR_GENERAL (package) — invoked via HR_GENERAL.DECODE_LOOKUP to translate lookup codes into their displayed meanings.
• PAY_ELEMENT_TYPES_F (synonym) — the element type definition table, joined to identify the relevant payroll element types.
• PAY_RUN_RESULTS (synonym) — the core payroll run results table supplying ASSIGNMENT_ACTION_ID and the basis for run result values.
• PAY_INPUT_VALUES_F (synonym) — the input value definitions whose NAME column drives the DECODE aggregation.
• PAY_RUN_RESULT_VALUES (synonym) — the run result value table supplying the actual RESULT_VALUE figures that are pivoted into separate columns.

The view text uses an ORDERED hint with nested-loop joins and explicit indexes (FND_SESSIONS_U1, PAY_ELEMENT_TYPES_F_UK2, PAY_RUN_RESULTS_N50, PAY_INPUT_VALUES_F_N50, PAY_RUN_RESULT_VALUES_PK), confirming an intention to drive the query through the session and payroll run results for performance. Internally, an inline view pivots PAY_INPUT_VALUES_F names into columns via MAX(DECODE(...)), producing one aggregated row per ASSIGNMENT_ACTION_ID. The outer SELECT then applies NVL substitution for the weekly figures and lookup decoding for the descriptive columns.

Key Columns

• assignment_action_id — key linking the row to a specific assignment action in the payroll run.
• weekly_tax_credit — the effective weekly tax credit, produced as NVL(PERIOD_WEEKLY_TAX_CREDIT, WEEKLY_TAX_CREDIT).
• weekly_std_rate_cut_off — the effective weekly standard rate cut-off, produced as NVL(PERIOD_WEEKLY_STD_RATE_CUT_OFF, WEEKLY_STD_RATE_CUT_OFF).
• monthly_tax_credit and monthly_std_rate_cut_off — the monthly equivalents of the above.
• d_tax_basis, d_info_source, d_tax_assess_basis — decoded (display) values for the IE_PAYE_TAX_BASIS, IE_PAYE_INFO_SOURCE, and IE_PAYE_ASSESS_BASIS lookups, truncated to 80 characters.
• certificate_issue_date — the value of the input value named 'CERTIFICATE ISSUE DATE', exposed as the user specifically sought.

Common Use Cases and Queries

Typical usage includes generating the Irish Statement of Earnings, validating tax credit and cut-off figures per assignment action, and extracting certificate issue dates for compliance reporting.

SELECT assignment_action_id,
       weekly_tax_credit,
       weekly_std_rate_cut_off,
       monthly_tax_credit,
       monthly_std_rate_cut_off,
       d_tax_basis,
       certificate_issue_date
  FROM apps.pay_ie_soe_paye_details_v
 WHERE assignment_action_id = :assignment_action_id;

SELECT DISTINCT certificate_issue_date
  FROM apps.pay_ie_soe_paye_details_v
 WHERE certificate_issue_date IS NOT NULL;

Because the view is a simple projection with no bind variables, callers must supply their own WHERE predicates, typically on assignment_action_id, to avoid full scans across payroll run results.