Search Results get_fiscal_rating




Overview
Explore in AI Chat

Overview

PAY_IE_BIK is an Oracle EBS payroll package owned by the APPS schema that supports the Irish statutory reporting of Benefit-in-Kind (BIK). In Ireland, employers are obligated to report the taxable value of non-cash benefits — company cars, employer-provided accommodation, preferential loans, and other benefits — to Revenue. The BIK package supplies the PL/SQL logic that underpins the Irish BIK view objects and any related concurrent processing or form-based inquiries. It is classified as an OTHER API, meaning it is not part of a formally published public interface but is consumed internally by Oracle-delivered components that expose BIK data for reporting.

Within Oracle EBS 12.1.1 and 12.2.2, the package sits alongside the Irish payroll legislative objects that localize the core PAY modules for Revenue requirements. It relies on standard payroll balance and run-result infrastructure rather than maintaining its own persistent tables, and it surfaces results through its dependent BIK views.

Key Procedures and Functions

The documented API exposes eleven procedures and functions, all of which are data-retrieval oriented:

  • GET_GLOBAL_VALUE — returns the value of a specified global from FF_GLOBALS_F, providing a centralized way to read payroll configuration parameters.
  • GET_MAX_START_DATE — determines the latest effective start date relevant to the calling context.
  • GET_MAX_NO_OF_PERIODS — returns the maximum number of payroll periods applicable to the calculation.
  • GET_LEAST_DATE — returns the earliest date among a set of candidate dates, used for effective-dating resolution.
  • GET_BALANCE_VALUES — retrieves balance amounts for an assignment, drawing on the balance and run-result tables.
  • GET_ADDRESS — fetches an address record, typically for the employee or benefit provider.
  • GET_LANDLORD_ADDRESS — returns the landlord address for accommodation-related BIK reporting.
  • GET_INV_UNA_DAYS — calculates the number of days a company vehicle was unavailable for business use.
  • GET_INV_TOT_MLGE — returns total mileage recorded for the vehicle.
  • GET_INV_BUS_MLGE — returns business mileage, which is used to apportion taxable benefit.
  • GET_FISCAL_RATING — returns the fiscal rating applied to a benefit, reflecting the Revenue-prescribed valuation bands.

Together these functions supply the denormalized values needed by the BIK views to compute taxable amounts.

Tables Accessed

PAY_IE_BIK reads from a well-defined set of payroll and HR tables via APPS synonyms. Element and input value definitions are obtained from PAY_ELEMENT_TYPES_F and PAY_INPUT_VALUES_F, with PAY_ELEMENT_ENTRIES_F capturing entry-level data. Balance calculations draw on PAY_BALANCE_TYPES, PAY_BALANCE_DIMENSIONS, PAY_DEFINED_BALANCES, and PAY_RUN_RESULTS / PAY_RUN_RESULT_VALUES. Assignment and payroll context come from PAY_ASSIGNMENT_ACTIONS and PAY_PAYROLL_ACTIONS. Global parameters are read from FF_GLOBALS_F. Organizational and address information is sourced from HR_ALL_ORGANIZATION_UNITS and PER_ADDRESSES. Time dimension logic relies on PER_TIME_PERIODS and PER_TIME_PERIOD_TYPES. The package performs no documented writes, acting purely as a query layer.

Usage Notes

The package is referenced by six dependent objects: PAY_IE_BIK_ACCOMMODATION_V, PAY_IE_BIK_CASH_V, PAY_IE_BIK_COMPANY_VEHICLES_V, PAY_IE_BIK_NON_CASH_V, PAY_IE_BIK_OTHER_BENEFITS_V, and PAY_IE_BIK_PREF_LOANS_V. It is therefore not typically invoked directly by end users but is executed implicitly whenever these views are queried — for example, from Irish BIK reporting concurrent programs, Discoverer worksheets, or custom extracts. Because the functions are pure read operations, they are safe to call from custom PL/SQL where BIK values must be reproduced outside Oracle's shipped views, provided the caller supplies valid assignment, element, and date context.