Search Results total_amount_ipv_id

Overview

APPS.PAY_GB_TAX_CREDITS_V is a supplementary Oracle EBS view owned by the APPS schema and registered under FND Design Data as PAY.PAY_GB_TAX_CREDITS_V. It belongs to the Oracle Payroll localization for the United Kingdom and exposes tax credit element entries — such as Working Tax Credit and Child Tax Credit — captured against employee assignments. The view is classified as VALID and is a "supplementary view used to simplify forms coding," meaning it was created to service the Oracle Forms-based payroll entry screens rather than to provide a supported, stable reporting interface.

The view returns one row per element entry and flattens the associated input values into denormalized VARCHAR2 columns, retaining the numeric IPV identifiers alongside each value. Because it is a forms-support object, the view name carries the Oracle warning that it "may change dramatically in subsequent minor or major releases," and Oracle explicitly does not recommend querying or altering data through it. The object also filters on the current session, since FND_SESSIONS and HR_API are among its dependencies, so effective-dated and session-scoped business group context is applied within the view definition.

Underlying Base Objects

The documented dependencies are APPS.FND_SESSIONS (SYNONYM), APPS.HR_API (PACKAGE), APPS.HR_LOOKUPS (VIEW), APPS.PAY_ELEMENT_ENTRIES_F (SYNONYM), APPS.PAY_ELEMENT_ENTRY_VALUES_F (SYNONYM), APPS.PAY_ELEMENT_LINKS_F (SYNONYM), APPS.PAY_ELEMENT_TYPES_F (SYNONYM), and APPS.PAY_INPUT_VALUES_F (SYNONYM). Each maps to a _F or _F_V synonym over the corresponding _F base table.

• PAY_ELEMENT_ENTRIES_F — supplies ELEMENT_ENTRY_ID, ASSIGNMENT_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, and OBJECT_VERSION_NUMBER.
• PAY_ELEMENT_ENTRY_VALUES_F — supplies the input value rows joined through ELEMENT_ENTRY_ID to yield the *_IPV_ID columns and their formatted values.
• PAY_INPUT_VALUES_F — provides the input value definitions and display sequence.
• PAY_ELEMENT_LINKS_F / PAY_ELEMENT_TYPES_F — supply ELEMENT_LINK_ID and element classification used to restrict the rowset to UK tax credit elements.
• HR_LOOKUPS — resolves lookup meanings, and IPV_DATE_FORMAT carries the date mask applied to the date input values.
• FND_SESSIONS / HR_API — apply session and business group filtering and utility logic.

The view is not referenced by any database object, confirming its role as a terminal forms-only presentation layer.

Key Columns

• DAILY_AMOUNT (VARCHAR2(60)) and DAILY_AMOUNT_IPV_ID (NUMBER) — the per-day tax credit amount entered for the element entry, stored as a character string in the view while the underlying value is a number. This is the column most commonly sought when users search for "daily_amount."
• REFERENCE / REFERENCE_IPV_ID — the statutory reference or certificate number quoted by the employee.
• START_DATE / END_DATE / STOP_DATE and their IPV IDs — the tax credit period boundaries, formatted per IPV_DATE_FORMAT.
• TOTAL_AMOUNT / TOTAL_AMOUNT_IPV_ID — the aggregate tax credit amount over the period.
• ASSIGNMENT_ID — the assignment to which the tax credit entry belongs.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — date-track columns on the element entry row.

Common Use Cases and Queries

The principal use case is validation and troubleshooting of UK tax credit entries via the payroll forms, and ad hoc reporting on daily amounts. Note that since the view depends on FND_SESSIONS, a session must be established (typically via the EBS forms session) for rows to be returned.

SELECT assignment_id
     , daily_amount
     , reference
     , start_date
     , end_date
     , total_amount
  FROM apps.pay_gb_tax_credits_v
 WHERE assignment_id = :p_assignment_id;

To compare entered daily amounts across elements for a business group, join the IPV identifiers back to PAY_ELEMENT_ENTRY_VALUES_F, which is generally safer than relying on the view's formatted VARCHAR2 output.