Search Results check_grade_ladder_exists

Overview

PQH_EMPLOYEE_SALARY is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and validated in release 12.1.1 and 12.2.2. It belongs to the Public Sector/HR (PQH) product family that supports position management, grade ladder progression, and compensation administration for public sector and general HR deployments. Its principal business function is to resolve salary values attached to employee assignments and proposals, converting pay-period amounts into annualized figures and returning proposed or current salary information for a given assignment. The package therefore acts as a reusable server-side utility that other HR and benefits components call when they require a normalized salary amount rather than reading raw payroll or proposal rows directly.

Key Procedures and Functions

• GET_EMPLOYEE_SALARY — Returns the salary associated with an employee assignment, resolving the applicable assignment record and pay basis to produce a usable salary value.
• CHECK_GRADE_LADDER_EXISTS — Determines whether a grade ladder definition exists for the employee or position context, allowing callers to conditionally enable grade progression logic.
• PGM_TO_ANNUAL — Converts a pay-period or periodic salary amount into an annualized amount using the applicable pay basis and time period definition.
• PGM_TO_ANNUAL1 — A companion annualization routine covering an alternate conversion signature or input variant used where the primary conversion path is not applicable.
• GET_EMP_PROPOSED_SALARY — Retrieves the proposed salary recorded against an employee, typically sourced from salary proposals rather than the active assignment.

The metadata documents six procedures in total; the fifth entry corresponds to the package specification/body construct and does not represent an additional callable routine. No parameter lists are reproduced here because they are not part of the documented metadata.

Tables Accessed

The package reads and writes across compensation, payroll, and benefits tables accessed through APPS synonyms. PER_ALL_ASSIGNMENTS_F supplies the assignment context that anchors salary lookup. PER_PAY_BASES, PER_PAY_PROPOSALS, PER_TIME_PERIOD_TYPES, and FND_CURRENCIES support annualization, pay-basis resolution, proposal retrieval, and currency handling. Payroll components include PAY_ALL_PAYROLLS_F, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_ELEMENT_TYPES_F, and PAY_INPUT_VALUES_F, which provide element entry values used in salary derivation. Benefits tables BEN_ELIG_PER_ELCTBL_CHC, BEN_ENRT_RT, BEN_LER_F, BEN_PER_IN_LER, and BEN_PGM_F support eligibility, enrollment rate, and program lookups where salary feeds benefit calculations. The documented dependency list also cites PER_ALL_ASSIGNMENTS_F explicitly.

Usage Notes

PQH_EMPLOYEE_SALARY is not an end-user-facing object; it is invoked from other PL/SQL packages and from salary-related forms and concurrent processes. The metadata shows it is referenced by HR_EMPL_VERF_UTIL, HR_PAY_RATE_GSP_SS, HR_UTIL_MISC_SS, PQH_GSP_UTILITY, and the view PQH_GSP_ELECTABLE_CHC_V, and it is referenced by five other packages overall. Callers use it to obtain a consistent annualized or proposed salary figure without duplicating conversion logic. Because the package reads date-tracked assignment and payroll tables, results depend on effective dates and the caller's session context. Custom code should call the documented routines rather than querying the underlying tables directly, and any modification to salary entries referenced by this package should be performed through supported compensation or payroll APIs. Note that the search phrase "how to delete salary entry in Zoho payroll" refers to an unrelated third-party product; no deletion procedure for that purpose exists in this Oracle EBS package.