Results for “paylv_assignment_set_name_v”
17 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The view PAYLV_ASSIGNMENT_SET_NAME_V is an APPS-owned database object within the Oracle E-Business Suite Payroll (PAY) product family. It is a read-only view that exposes assignment set definitions alongside a derived business group security indicator, providing a lightweight, joined representation of payroll assignment set data. The view is registered in ETRM 12.2.2 with a status of VALID and is defined over the HR_ASSIGNMENT_SETS table, the HR_BIS package, and the DUAL synonym.
The view is a List of Values (LOV) oriented object. Its name prefix, PAYLV, identifies it as a payroll LOV view, indicating that its primary purpose is to feed selection lists in Oracle Forms-based and OAF-based Payroll and Human Resources user interfaces. Rather than presenting raw assignment set rows, the view augments them with a security flag that reflects whether the current user's security profile grants visibility to the business group owning each assignment set. It also injects a synthetic "null row" entry to support blank or wildcard selections in LOV-driven prompts. Because it is declared WITH READ ONLY, no DML is permitted against the view, and consumers must treat it strictly as a query surface.
Underlying Base Objects
The documented base objects referenced by the view are:
- HR_ASSIGNMENT_SETS (SYNONYM) — the primary source of assignment set records, supplying ASSIGNMENT_SET_ID, ASSIGNMENT_SET_NAME, and BUSINESS_GROUP_ID.
- HR_BIS (PACKAGE) — used to obtain the current security profile's business group identifier via HR_BIS.GET_SEC_PROFILE_BG_ID, which drives the BG_SECURITY_FLAG_CODE calculation.
- DUAL (SYNONYM) — used in a UNION ALL branch to append a synthetic placeholder row (NULL name, -1 identifier, 'Y' flag, blank order key) for LOV flexibility.
The view text selects from HR_ASSIGNMENT_SETS, computes the security flag with a CASE expression, and unions the result with the single-row branch drawn from DUAL, applying WITH READ ONLY. The HR_BIS package dependency makes the view's output dependent on session context, since the returned business group ID varies by the connected user's security profile.
Key Columns
- ASSIGNMENT_SET_NAME — the descriptive name of the assignment set, used as the visible LOV label.
- ASSIGNMENT_SET_ID — the unique identifier of the assignment set; the -1 value from the UNION branch represents the placeholder entry.
- BG_SECURITY_FLAG_CODE — derived flag ('Y' or 'N') indicating whether the current user's security profile business group matches the assignment set's business group, enabling immediate security filtering.
- ORDER_BY — a sort key exposing the assignment set name (and a blank string for the placeholder row) so that LOV results can be ordered predictably.
Common Use Cases and Queries
Typical usage includes populating assignment set LOVs on payroll processes, element entry, and batch assignment screens, and filtering visible assignment sets by security profile. A representative query follows:
SELECT assignment_set_name,
assignment_set_id,
bg_security_flag_code
FROM apps.paylv_assignment_set_name_v
WHERE NVL(bg_security_flag_code,'Y') = 'Y'
ORDER BY order_by;
This pattern is commonly issued when an LOV must restrict results to those assignment sets the user is authorised to see, while still permitting the placeholder row for optional entry. Because the security flag is computed at runtime against HR_BIS, session conditions such as the active responsibility and security profile directly influence which rows return 'Y'.
-
APPS.PAYLV_ASSIGNMENT_SET_NAME_V·↳ HR_ASSIGNMENT_SETS·↳ HR_BIS·↳ DUAL·Explore PAY module →
-
APPS.PAYLV_ASSIGNMENT_SET_NAME_V·↳ HR_ASSIGNMENT_SETS·↳ HR_BIS·↳ DUAL·Explore PAY module →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - PAY Tables and Views 12.1.1
Temporary table used to hold invalid location addresses.
-
SYNONYM: PUBLIC.DUAL 12.2.2
-
SYNONYM: PUBLIC.DUAL 12.1.1
-
eTRM - PAY Tables and Views 12.2.2
Temporary table used to hold invalid location addresses.
-
eTRM - PAY Tables and Views 12.1.1
Temporary table used to hold invalid location addresses.
-
eTRM - PAY Tables and Views 12.2.2
Temporary table used to hold invalid location addresses.