Search Results get_asg_latest_pay

Overview

APPS.PAY_NZ_SOE_PKG is a New Zealand–specific Oracle HRMS PL/SQL package that supports the generation of the Statement of Earnings (SOE) report for New Zealand payroll operations. The package encapsulates the business logic required to retrieve payslip-relevant information — addresses, salary details, tax codes, balances, and run results — and present it in a form suitable for the NZ SOE window and associated reports. The package header comment and revision history place its creation in May 2000, with enhancements through August 2000 that added the get_details and get_asg_latest_pay procedures specifically to support the NZ SOE window. A December 2002 revision (SRRAJAGO, reference 2689221) added nocopy hints to OUT and IN OUT parameters across all procedures for performance reasons. The package owner is APPS, its API classification is OTHER, and it is referenced by three other packages. The source header (pynzsoe.pkh 120.0.12000000.1) indicates the last file revision stamp carries a 2007 date, although the documented change list ends in 2002.

This package is therefore a data-retrieval and calculation layer rather than a self-contained business process. It supplies the NZ SOE forms and concurrent reporting programs with the discrete pieces of payroll data they display or print.

Key Procedures and Functions

ETRM documents ten procedures and functions, of which the user's search term, get_asg_latest_pay, is one:

• GET_HOME_ADDRESS — Returns the formatted home address components (address lines, town/city, postal code, country name) for a given person. Added with a view to NZ SOE window display.
• GET_WORK_ADDRESS — Returns the formatted work address components for a given location.
• GET_TAX_CODE — Returns the tax code applicable to a run assignment action.
• GET_SALARY — Returns salary information based on pay basis, assignment, and effective date.
• BALANCE_TOTALS — Aggregates balance amounts, typically used within balance retrieval logic.
• BUSINESS_CURRENCY_CODE — Returns the business currency code, presumably derived from FND_CURRENCIES.
• RUN_AND_YTD_BALANCES — Retrieves run-level and year-to-date balance values for reporting.
• GET_ASG_LATEST_PAY — Retrieves the most recent pay information for an assignment. Added in August 2000 (by NDOMA) expressly to service the NZ SOE window, and is the procedure associated with the user's search term.
• GET_DETAILS — Returns the detailed SOE line data for the NZ SOE window; added in the same August 2000 enhancement as get_asg_latest_pay.
• FINAL_BALANCE_TOTALS — Added 21 August 2000 to obtain cumulative run balances when prepayments are run for a selected run or set of prepayments.

Tables Accessed

The package reads and writes against a broad set of HRMS and payroll tables through APPS synonyms, consistent with its role in assembling SOE data:

• PER_ALL_ASSIGNMENTS_F, PER_ADDRESSES, HR_ORGANIZATION_INFORMATION — assignment, address, and organization detail used by the address and salary retrieval routines.
• PAY_ASSIGNMENT_ACTIONS, PAY_PAYROLL_ACTIONS, PAY_ACTION_INTERLOCKS — payroll run and assignment action context, including the run assignment action identifier used as input to tax code and balance lookups.
• PAY_BALANCE_TYPES, PAY_RUN_RESULTS, PAY_RUN_RESULT_VALUES — balance definition and run result values underpinning run_and_ytd_balances, balance_totals, and final_balance_totals.
• PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_ELEMENT_TYPES_F, PAY_INPUT_VALUES_F — element and input value data required to render earnings detail lines.
• FND_CURRENCIES, FND_TERRITORIES_TL — currency and territory lookup values used by business_currency_code and address/country formatting.

Usage Notes

PAY_NZ_SOE_PKG is consumed primarily by the New Zealand Statement of Earnings window and any associated concurrent or report processes that generate NZ payslip documentation. It is a repository-level API that is not intended to be modified by customers; the nocopy usage confirms that output parameter values are returned by reference for efficiency.

Because it is referenced by three other packages, changes to it may impact dependent custom or seeded code. The package is best invoked from Oracle Forms or a PL/SQL wrapper that supplies the required identifiers (person, location, assignment, effective date, or run assignment action). Custom code integrating it should treat the procedures as read-only and preserve the existing signatures, as the ETRM classification of OTHER indicates no published extension guarantees beyond the documented entry points.