Search Results gre_jd




Overview
Explore in AI Chat

Overview

APPS.PQP_US_FF_FUNCTIONS is a PL/SQL package body belonging to the Oracle EBS Payroll (PQP) product family. It provides a library of Fast Formula helper functions used exclusively within the United States legislative and alien tax-processing context. Its principal business responsibility is to supply payroll Fast Formulas with derived values that cannot be obtained through standard database items, particularly for alien (non-resident) tax withholding, treaty eligibility, state tax reciprocity, and non-W-2 balance reporting.

Because fast formulas execute within the payroll run and pre-payment processing cycle, this package bridges the gap between formula-level logic and the underlying payroll balance, element, and alien-tracking data model. It is classified in the ETRM as an "OTHER" API, meaning Oracle does not publish it as a supported public interface; it is instead a supporting utility invoked internally by Fast Formula functions and by peer packages. The package is documented against 12.2.2 and shares the same body structure in 12.1.1 (header revision pqusfffn.pkb 115.19).

Notably, the user search term "gre_jd" does not correspond to any documented function or table within this package metadata. Practitioners searching that term should verify whether it refers to a customer-defined Fast Formula or a custom object outside the delivered PQP schema.

Key Procedures and Functions

The package exposes eleven documented functions:

  • GET_COL_VAL — Returns a single column value from the analyzed alien data and alien details tables for a given assignment, payroll action, column name, and income code, defaulting to zero when no row is found.
  • STATE_HONORS_TREATY — Determines whether a specific state honors an alien tax treaty, using the state code and treaty-honored flag held in the alien state treaties table.
  • ALIEN_TREATY_VALID — Validates whether a treaty claim is currently valid for the employee and period under evaluation.
  • GET_ALIEN_BAL — Retrieves an alien-related balance amount, supporting withholding calculations during the payroll run.
  • IS_WINDSTAR and PQP_IS_WINDSTAR — Determine whether the installation or the specific processing context uses the Windstar third-party tax engine, allowing formulas to branch accordingly.
  • GET_NONW2_BAL — Returns balance values for payments that are not reportable on Form W-2, such as certain treaty-exempt or foreign-source income.
  • GET_PREV_CONTRIB — Retrieves a prior-period contribution amount, typically for annual limits and cumulative withholding testing.
  • PQP_PROCESS_EVENTS_EXIST — Tests whether payroll process events exist for the assignment, used to gate formula logic.
  • PQP_ALIEN_TAX_ELE_EXIST — Establishes whether alien tax elements are linked and available for the assignment.
  • GET_TRR_NONW2_BAL — Returns non-W-2 balance amounts specifically for treaty-reporting requirements.

Tables Accessed

The package reads the alien data model through PQP_ALIEN_STATE_TREATIES_F, which stores the state-by-state treaty honored flags, and through the analyzed alien data and detail structures referenced by GET_COL_VAL. Payroll balance information is sourced from PAY_BALANCE_TYPES, PAY_BALANCE_DIMENSIONS, and PAY_DEFINED_BALANCES, with element metadata drawn from PAY_ELEMENT_TYPES_F, PAY_ELEMENT_CLASSIFICATIONS, PAY_ELEMENT_LINKS_F, and PAY_ELEMENT_ENTRIES_F. Assignment and person context come from PER_ALL_ASSIGNMENTS_F and PER_PEOPLE_EXTRA_INFO. State tax logic relies on PAY_STATE_RULES, while PAY_PROCESS_EVENTS supports the process-event existence checks and HR_SOFT_CODING_KEYFLEX supplies key flexfield data. DUAL is used for trivial single-row evaluations. Writes are not documented; the package is primarily a read-only utility layer.

Usage Notes

PQP_US_FF_FUNCTIONS is invoked indirectly rather than through Oracle Forms or standard concurrent programs directly. It is called by Fast Formula functions registered in the payroll function library, and is referenced by four other packages, indicating it is a shared dependency within the PQP schema. Typical invocation points are the payroll run, pre-payments, and year-end alien tax reporting processes. Because it is not a published API, any custom formula or code that calls it must be regression-tested on upgrade, since function signatures and internal SQL are subject to change without a published compatibility guarantee.