Results for “p_assignment_id”

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

Overview

PAY_GB_P11D_CAR_EXTRACT is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified as an OTHER API. It supports statutory United Kingdom payroll reporting obligations relating to the P11D and P11D(b) end-of-year benefit-in-kind returns, specifically the company car and car fuel benefit elements that employers must report to HM Revenue & Customs. The package exposes a family of extraction functions that return formatted character values describing an employee's primary company car for a given assignment. These values are consumed by the corresponding P11D business process to populate the car and car fuel benefit sections of the return.

The package header is versioned at 120.0.12010000.1, reflecting the standard EBS 12.1.1 file naming convention, and the object remains present and documented in ETRM 12.2.2. It is a read-only extraction utility: it does not create or update benefit-in-kind records, but rather resolves attribute values from the originating Oracle Advanced Benefits records and assignment data.

Key Procedures and Functions

The 38 documented functions fall into paired accessors. Each benefit attribute has both a wrapper function (prefixed GET_) and a core function of the same logical name, both accepting an assignment identifier and returning a VARCHAR2 result.

• Assignment date functions — GET_PRIM_ASG_START_DATE and GET_PRIM_ASG_END_DATE return the start and end dates of the primary assignment, establishing the period during which a car was held.
• Benefit date functions — GET_PRIM_BEN_START_DATE, PRIM_BEN_START_DATE, GET_PRIM_BEN_END_DATE, and PRIM_BEN_END_DATE return the benefit period start and end dates for the primary car benefit.
• Vehicle identification functions — GET_PRIM_VIN and PRIM_VIN return the Vehicle Identification Number of the primary car, which is the search term that led to this object.
• Vehicle description functions — GET_PRIM_MAKE and PRIM_MAKE, GET_PRIM_MODEL and PRIM_MODEL, GET_PRIM_FUEL_TYPE and PRIM_FUEL_TYPE, and GET_PRIM_CO2_EMI and PRIM_CO2_EMI return the manufacturer, model, fuel category, and CO2 emissions figure used to determine the appropriate benefit-in-kind percentage.
• Valuation functions — GET_PRIM_PRICE and PRIM_PRICE return the list price of the car; GET_PRIM_DFR and PRIM_DFR return the date first registered.
• Accessory and contribution functions — GET_PRIM_OPTIONAL_ACC and PRIM_OPTIONAL_ACC return optional accessories; GET_PRIM_ACC_ADDED_AFTER returns accessories added after the relevant date; GET_PRIM_CAPITAL_CONTRIB and PRIM_CAPITAL_CONTRIB return capital contributions made by the employee toward the car.

Tables Accessed

The package reads through APPS synonyms across the benefits, HR, and payroll schemas. Benefit definition and result data are sourced from BEN_EXT_DFN, BEN_EXT_RCD, BEN_EXT_RCD_IN_FILE, BEN_EXT_RSLT, and BEN_EXT_RSLT_DTL, which supply the extracted car attributes. Assignment and person context is drawn from PER_ALL_ASSIGNMENTS_F, PER_ALL_PEOPLE_F, PER_ASSIGNMENT_STATUS_TYPES, and PQP_ASSIGNMENT_ATTRIBUTES_F. Assignment grouping and amendment history comes from HR_ASSIGNMENT_SETS, HR_ASSIGNMENT_SET_AMENDMENTS, HR_ORGANIZATION_INFORMATION, and HR_SOFT_CODING_KEYFLEX. Payroll and consolidation context is provided by PAY_ALL_PAYROLLS_F and PAY_CONSOLIDATION_SETS.

Usage Notes

This package is an internal extraction layer invoked by the UK P11D car benefit concurrent program and its associated report logic during end-of-year processing. It is not exposed through a standard EBS form and is not referenced by any other documented package, indicating a narrow, process-specific role. Customizations should treat it as read-only and avoid modifying its logic, since the returned string formats feed directly into statutory report output.