Results for “pay_grade_rules_v”

40 results




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

Overview

PAY_GRADE_RULES_V is a user-interface support view in the Oracle E-Business Suite Payroll (PAY) product, owned by the APPS schema. Its purpose is to present grade rate rule information in a denormalized, human-readable form suitable for concurrent program parameters, Oracle Forms LOVs, and report queries. Grade rate rules define the monetary or numeric values attached to grades and spinal points within a business group, and are governed by the effective-dating model that EBS uses throughout the HRMS and Payroll schemas.

The view resolves several foreign keys at runtime so that consumers see descriptive values rather than raw IDs. It exposes the rate name, grade name, spinal point, and currency name directly, removing the need for downstream reports to join PAY_RATES, PER_GRADES_TL, PER_SPINAL_POINTS, and FND_CURRENCIES_VL individually. A key design characteristic is the session-based effective date filter: the join to FND_SESSIONS restricts rows so that only the record effective on the current session's effective date is returned, which aligns the view's output with the effective date of the calling form or concurrent request.

Underlying Base Objects

The view is defined over the following documented objects:

  • PAY_GRADE_RULES_F — the driving base table holding grade rule rows, including rate type, grade or spinal point reference, minimum, mid value, maximum, and currency.
  • PAY_RATES — supplies RATE_NAME and RATE_BASIS for the referenced rate. This is an inner join; a grade rule with no matching rate will not be returned.
  • PER_GRADES and PER_GRADES_TL — outer-joined to resolve the grade sequence and the translated grade name (PER_GRADE_NAME) when RATE_TYPE indicates a grade.
  • PER_SPINAL_POINTS — outer-joined to resolve spinal point details, including PER_SPINAL_POINT, SPINAL_POINT_ID, and the spinal point sequence.
  • FND_CURRENCIES_VL — outer-joined to supply CURRENCY_NAME.
  • FND_SESSIONS — provides the effective date used to filter the grade rule row.
  • HR_GENERAL — a PL/SQL package invoked through HR_GENERAL.DECODE_LOOKUP to translate RATE_BASIS into RATE_BASIS_NAME, truncated to 80 characters.

Because PER_GRADES, PER_GRADES_TL, PER_SPINAL_POINTS, and FND_CURRENCIES_VL are outer-joined, a grade rule row is always returned as long as its PAY_RATES and FND_SESSIONS joins resolve, and the DECODE logic on RATE_TYPE determines whether grade or spinal point attributes are populated.

Key Columns

For users searching on rate_name, the relevant column is RATE_NAME, sourced from PAY_RATES.NAME. It carries the descriptive identity of the pay rate associated with the grade rule and is the most common lookup criterion.

  • RATE_NAME — name of the referenced rate; the primary descriptive attribute for identification.
  • RATE_BASIS / RATE_BASIS_NAME — the raw rate basis code and its decoded lookup meaning.
  • RATE_TYPE — indicates whether the rule applies to a grade ('G'), a spinal point ('SP'), or an assignment ('A').
  • GRADE_OR_SPINAL_POINT_ID — polymorphic reference whose target depends on RATE_TYPE.
  • PER_GRADE_NAME, PER_SPINAL_POINT, SEQUENCE — descriptive grade or spinal point context resolved by DECODE.
  • MINIMUM, MID_VALUE, MAXIMUM, VALUE — the rule's numeric or monetary thresholds.
  • CURRENCY_CODE, CURRENCY_NAME — currency of the rule values.
  • EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — date-range boundaries of the row, used with FND_SESSIONS filtering.
  • BUSINESS_GROUP_ID, GRADE_RULE_ID, RATE_ID — key identifiers for joins and filtering.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE — audit columns.

Common Use Cases and Queries

The view is typically queried in reports validating grade rate setup, in concurrent program parameters requiring a rate selection, and in reconciliation extracts between payroll and HR. A representative query filtering by rate name is:

SELECT grade_rule_id, rate_name, per_grade_name, per_spinal_point, minimum, mid_value, maximum, currency_code FROM apps.pay_grade_rules_v WHERE rate_name = :p_rate_name;

To list all rules for a business group with the rate description:

SELECT rate_name, rate_basis_name, per_grade_name, value, effective_start_date, effective_end_date FROM apps.pay_grade_rules_v WHERE business_group_id = :p_bg_id ORDER BY rate_name, sequence;

Because the view filters on FND_SESSIONS.EFFECTIVE_DATE, callers must ensure the session effective date is set appropriately, typically through the standard EBS session initialization. Queries returning no rows may indicate that no grade rule is effective on the session date rather than an absence of setup data.