Results for “paylv_element_type_v”
19 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PAYLV_ELEMENT_TYPE_V is a read-only view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the PAY (Payroll) product family. It presents a security-filtered, language-aware list of payroll element types defined in the PAY_ELEMENT_TYPES_F and PAY_ELEMENT_TYPES_F_TL tables. Its primary design purpose is to supply an LOV (List of Values) and validation source for payroll and HR setup forms, concurrent processes, and custom reporting or integration layers that must present element types without exposing records outside the caller's Business Group or legislation security profile.
The view is registered as VALID in the ETRM and is available across both 12.1.1 and 12.2.2 releases. Rather than duplicating element type data, it derives presentation attributes and applies row-level security at query time, making it the standard reference for any code needing a constrained element type picklist.
Underlying Base Objects
The view is defined over the following documented objects:
- PAY_ELEMENT_TYPES_F (SYNONYM) — the base element type definition table, holding ELEMENT_TYPE_ID, ELEMENT_NAME, effective dates, BUSINESS_GROUP_ID, LEGISLATION_CODE, and RECALC_EVENT_GROUP_ID.
- PAY_ELEMENT_TYPES_F_TL (SYNONYM) — the translation table supplying the user-facing ELEMENT_NAME in the session language.
- HR_BIS (PACKAGE) — provides GET_LEGISLATION_CODE and GET_SEC_PROFILE_BG_ID, the security context functions driving the BG_SECURITY_FLAG_CODE.
- HR_GENERAL (PACKAGE) — supplies START_OF_TIME and END_OF_TIME for the synthetic "blank" row.
- DUAL (SYNONYM) — used to append the null placeholder row with ELEMENT_TYPE_ID = -1 and ORDER_BY = ' '.
The join between the two base tables is on ELEMENT_TYPE_ID with ELTT.LANGUAGE = USERENV('LANG'), ensuring translated names are returned for the runtime session language. The UNION ALL with DUAL injects a blank selectable entry, a common EBS LOV convention.
Key Columns
- ELEMENT_NAME — the translated element type name from PAY_ELEMENT_TYPES_F_TL; null for the placeholder row.
- ELEMENT_TYPE_ID — primary identifier; -1 on the placeholder row.
- EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — date-tracked validity of the element type; the placeholder row uses HR_GENERAL.START_OF_TIME and END_OF_TIME.
- BG_SECURITY_FLAG_CODE — computed 'Y'/'N' indicating whether the row is accessible given the caller's Business Group and legislation security profile.
- ORDER_BY — exposes the element name for alphabetic ordering of the LOV.
- RECALC_EVENT_GROUP_ID — the recalculation event group associated with the element type. This column, exposed from PAY_ELEMENT_TYPES_F, is the object of the user's search term "recalc_event_group_id" and links element types to the event group governing retroactive recalculation behaviour.
Common Use Cases and Queries
The view is typically queried to build LOVs, to resolve a name from an ID, or to report on recalculation event group assignments. A standard lookup honoring security is:
SELECT element_type_id, element_name FROM apps.paylv_element_type_v WHERE bg_security_flag_code = 'Y' AND element_type_id > 0 ORDER BY order_by;
To investigate recalculation event group assignments specifically, the following joins element types to their group:
SELECT element_name, element_type_id, recalc_event_group_id FROM apps.paylv_element_type_v WHERE recalc_event_group_id IS NOT NULL ORDER BY order_by;
Because the view is read-only (WITH READ ONLY), it must never be used as a DML target. Custom integrations should filter on BG_SECURITY_FLAG_CODE = 'Y' and exclude the -1 placeholder to avoid presenting the blank entry outside an LOV context.
-
View: PAYLV_ELEMENT_TYPE_V 12.1.1
APPS.PAYLV_ELEMENT_TYPE_V·↳ HR_BIS·↳ HR_GENERAL·↳ PAY_ELEMENT_TYPES_F·Explore PAY module →
-
View: PAYLV_ELEMENT_TYPE_V 12.2.2
APPS.PAYLV_ELEMENT_TYPE_V·↳ HR_BIS·↳ HR_GENERAL·↳ PAY_ELEMENT_TYPES_F·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.