Search Results get_home_address

Overview

PAY_SG_SOE is a Singapore-specific Oracle Payroll server-side PL/SQL package owned by APPS and declared with AUTHID CURRENT_USER. Its name reflects its role as a Statement of Earnings (SOE) utility library for the Singapore statutory payroll legislation. The package encapsulates the business logic required to derive salary, accrual, balance, address, tax identifier, and currency information needed to render Singapore payslips and statutory reports, and to support downstream payroll calculations. The source header (pysgsoe.pkh 120.1.12010000.1) indicates the package has been shipped since the 11i/12.0 lineage and remains available in 12.1.1 and 12.2.2 without structural change. It is classified as an OTHER API rather than a public, supported interface, so Oracle does not guarantee its signature across releases; nevertheless, it is referenced by six other packages in the E-Business Suite, which confirms its role as a shared internal utility for Singapore payroll processing.

Key Procedures and Functions

• CURRENT_SALARY — Function returning the current salary as a VARCHAR2 for a given pay basis, assignment, and effective date.
• NET_ACCRUAL — Function returning the net accrual amount for an assignment, accrual plan, payroll, business group, and effective date.
• CURRENT_AND_YTD_BALANCES — Overloaded procedure returning current and year-to-date balances for a named balance type and person; one variant accepts a prepaid tag.
• BALANCE_TOTALS — Procedure returning the current and YTD totals for gross pay, statutory deductions, other deductions, net pay, non-payroll items, and employee CPF.
• GET_EXCHANGE_RATE — Retrieves the exchange rate applicable to a payroll or SOE currency conversion.
• GET_TAX_ID — Returns the tax identifier (Singapore NRIC/FIN reference) for a person.
• GET_HOME_ADDRESS — Returns the person's home address, used on payslips and statutory forms.
• GET_WORK_ADDRESS — Returns the person's work address, used where the employer's place of work must appear on Singapore SOE output.
• BUSINESS_CURRENCY_CODE — Returns the business group's functional currency code.
• GET_ASSIGNMENT_CURRENCY_CODE — Returns the currency associated with an assignment.
• GET_PAYROLL_CURRENCY_CODE — Returns the currency associated with a payroll.

The package specification exposes thirteen documented procedures and functions in total; the balance and address routines are the most frequently called from SOE generation logic.

Tables Accessed

The package reads reference and transactional data through APPS synonyms. Currency and conversion logic draws on FND_CURRENCIES, GL_DAILY_RATES, and GL_DAILY_CONVERSION_TYPES, while FND_TERRITORIES_TL supplies territory descriptions for address formatting. Person, assignment, and address data are read from PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, and PER_ADDRESSES. Payroll balances and accruals are sourced from PAY_BALANCE_TYPES, PAY_ASSIGNMENT_ACTIONS, PAY_PAYROLL_ACTIONS, PAY_ACCRUAL_PLANS, and PAY_ELEMENT_ENTRIES_F, with PAY_USER_COLUMNS providing balance classification attributes. PER_PAY_BASES and PER_TIME_PERIODS support salary and effective-date derivation. The package is predominantly read-only, returning values to its callers rather than writing to these tables.

Usage Notes

PAY_SG_SOE is invoked from Singapore payroll legislation code, SOE/payslip concurrent programs, and the payroll forms layer, and it is called by six other packages within the application. The GET_WORK_ADDRESS function, which the user searched for, is typically used when generating Singapore Statement of Earnings output that must display the employer's work location alongside employee details; it returns the work address for the person identified by the calling context. Because this is an OTHER-classified API, custom code should call it defensively and validate results, and implementers should confirm the signature against the target release, as Oracle does not warrant backward compatibility for unsupported internal APIs.