Results for “current_npw_flag”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The HR_FNDSCAUS_PERSON_LOV_V view is an APPS-owned database object residing in the PER (Human Resources) product module of Oracle E-Business Suite. Its documented purpose is to support the Person List of Values (LOV) displayed within the AOL Define User form, FNDSCAUS. When an administrator creates or updates an application user and associates that user with a person record, the form invokes this view to populate the person LOV with valid, searchable person entries.
The view is delivered in VALID status within the APPS schema and functions as a presentation-layer object rather than a transactional one. Its central design concern is the effective-dating model of Oracle HRMS: person records in PER_ALL_PEOPLE_F are date-tracked, so a single person can have multiple historical and future-dated rows. The view consolidates this complexity by applying date logic internally and returning a single, de-normalised row per qualifying person, together with a visual indicator of current employment status. This makes it suitable for direct binding to an LOV region without additional filtering logic in the form or report.
Underlying Base Objects
The documented view text defines the object over two base objects:
- PER_ALL_PEOPLE_F — the primary HRMS person table, supplying name, employee number, e-mail address, person identifier, business group, and the effective date range used for filtering.
- PER_BUSINESS_GROUPS — supplying the business group name associated with each person record.
The ETRM metadata lists HR_ALL_ORGANIZATION_UNITS_TL and PER_ALL_PEOPLE_F as referenced base objects. PER_BUSINESS_GROUPS is itself a synonym or view defined over HR_ALL_ORGANIZATION_UNITS_TL, which reconciles the two perspectives.
The view body is a UNION of two SELECT statements. The first returns all persons whose effective date range brackets the current system date, using TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE AND P.EFFECTIVE_END_DATE. The second returns persons whose earliest effective-dated record begins in the future, joining on a correlated subquery that selects MIN(EFFECTIVE_START_DATE) per PERSON_ID. Together, the branches present both currently effective and not-yet-effective persons, ensuring the LOV does not omit newly hired or future-dated assignments.
Key Columns
- FULL_NAME — the person's complete display name, sourced from PER_ALL_PEOPLE_F; this is the value typically shown in the LOV.
- CURRENT_EMPLOYEE_FLAG — derived via
DECODE(P.CURRENT_EMPLOYEE_FLAG, 'Y', '*', 'Y', '*', ''). Because the underlying column is defined as a VARCHAR2(1) rather than a boolean Y/N value, this construct normalises any value beginning with or equal to Y into an asterisk, and returns null otherwise. The asterisk visually marks current employees in the LOV list, allowing the administrator to distinguish active staff from contingent workers, applicants, or ex-employees. - BUSINESS_GROUP_NAME — projected from
H.NAMEin PER_BUSINESS_GROUPS, identifying the enterprise or legislative business group to which the person belongs. - EMPLOYEE_NUMBER — the system-generated or manually assigned person number, useful for disambiguation where names are duplicated.
- EMAIL_ADDRESS — the work e-mail address held on the person record.
- PERSON_ID — the primary key of the person, used as the hidden return value of the LOV and stored against the FND_USER record.
Common Use Cases and Queries
The principal consumer is the Define User form itself, which queries the view through the standard LOV mechanism. Developers extending the form, building concurrent programs, or constructing custom self-service pages may query the view directly, benefiting from its built-in effective-date handling. Typical patterns include locating persons by partial name, restricting to current employees, and resolving PERSON_ID values from an e-mail address.
- List all current employees:
SELECT person_id, full_name, employee_number FROM apps.hr_fndscaus_person_lov_v WHERE current_employee_flag = '*' ORDER BY full_name; - Fuzzy name search:
SELECT person_id, full_name, email_address FROM apps.hr_fndscaus_person_lov_v WHERE UPPER(full_name) LIKE UPPER('%:search%'); - Resolve a person by e-mail:
SELECT person_id, full_name FROM apps.hr_fndscaus_person_lov_v WHERE UPPER(email_address) = UPPER(:email);
Because the view performs the date-range filtering on PER_ALL_PEOPLE_F, callers should not apply their own effective-date predicates, which could reproduce rows or exclude future-dated entries unexpectedly. For high-volume reporting, joining directly to the base tables with explicit date criteria is preferable, as the UNION and correlated subquery carry a cost not suited to bulk extraction.
-
To support person lov in aol define user form (FNDSCAUS)
APPS.HR_FNDSCAUS_PERSON_LOV_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ PER_ALL_PEOPLE_F·Explore PER module →
-
To support person lov in aol define user form (FNDSCAUS)
APPS.HR_FNDSCAUS_PERSON_LOV_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ PER_ALL_PEOPLE_F·Explore PER module →
-
View: PER_ALL_WORKFORCE_V 12.1.1
View of employees, and contingent workers if profile option setup permits
APPS.PER_ALL_WORKFORCE_V·↳ FND_PROFILE·↳ HR_PERSON_NAME·↳ PER_ALL_PEOPLE_F·Explore PER module →
-
View: PER_ALL_PEOPLE 12.1.1
Date-effective view.
APPS.PER_ALL_PEOPLE·↳ FND_SESSIONS·↳ HR_PERSON_NAME·↳ PER_ALL_PEOPLE_F·Explore PER module →
-
View: PER_WORKFORCE_V2 12.2.2
Date effective view
APPS.PER_WORKFORCE_V2·↳ FND_SESSIONS·↳ HR_GENERAL·↳ HR_SECURITY·Explore PER module →
-
View: PER_WORKFORCE_X 12.1.1
Date-effective view.
APPS.PER_WORKFORCE_X·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PER module →
-
View: PER_PEOPLE_X 12.2.2
Date-effective view.
APPS.PER_PEOPLE_X·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PER module →
-
Used to support user interface
APPS.PER_EXPANDED_ASSIGNMENTS_V1·↳ FND_SESSIONS·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PER module →
-
View: PER_CONT_WORKERS_X 12.2.2
Date-effective view.
APPS.PER_CONT_WORKERS_X·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PER module →
-
View: PER_WORKFORCE_V2 12.1.1
Date effective view
APPS.PER_WORKFORCE_V2·↳ FND_SESSIONS·↳ HR_GENERAL·↳ HR_SECURITY·Explore PER module →
-
View: PER_ALL_WORKFORCE_V 12.2.2
View of employees, and contingent workers if profile option setup permits
APPS.PER_ALL_WORKFORCE_V·↳ FND_PROFILE·↳ HR_PERSON_NAME·↳ PER_ALL_PEOPLE_F·Explore PER module →
-
View: PER_PEOPLE_F 12.2.2
Secure view based on the corresponding _ALL_ table.
APPS.PER_PEOPLE_F·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PER module →
-
Date-effective view.
APPS.PER_WORKFORCE_CURRENT_X·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PER module →
-
View: HR_SUP_LOV_V 12.1.1
Used to support user interface.
APPS.HR_SUP_LOV_V·↳ FND_PROFILE·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_SECURITY·Explore PER module →
-
View: HR_SUP_LOV_V 12.2.2
Used to support user interface.
APPS.HR_SUP_LOV_V·↳ FND_PROFILE·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_SECURITY·Explore PER module →
-
View: PER_PEOPLE_F 12.1.1
Secure view based on the corresponding _ALL_ table.
APPS.PER_PEOPLE_F·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PER module →
-
DateTracked table holding personal information for employees, applicants and other people.
-
Date-effective view.
APPS.PER_CONT_WORKERS_CURRENT_X·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PER module →
-
View: PER_WORKFORCE_X 12.2.2
Date-effective view.
APPS.PER_WORKFORCE_X·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PER module →
-
Used to support user interface
APPS.PER_PEOPLE_ASSIGNMENTS_V1·↳ BEN_PGM_F·↳ FND_SESSIONS·↳ HR_GENERAL·Explore PER module →
-
Used to support user interface
APPS.PER_PEOPLE_ASSIGNMENTS_V1·↳ BEN_PGM_F·↳ FND_SESSIONS·↳ HR_GENERAL·Explore PER module →
-
DateTracked table holding personal information for employees, applicants and other people.
-
View: PER_PEOPLE_X 12.1.1
Date-effective view.
APPS.PER_PEOPLE_X·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PER module →
-
View: PER_PEOPLE 12.1.1
Date-effective view.
APPS.PER_PEOPLE·↳ FND_SESSIONS·↳ HR_GENERAL·↳ HR_PERSON_NAME·Explore PER module →
-
View: PER_PEOPLE 12.2.2
Date-effective view.
APPS.PER_PEOPLE·↳ FND_SESSIONS·↳ HR_GENERAL·↳ HR_PERSON_NAME·Explore PER module →
-
View: PER_ALL_PEOPLE 12.2.2
Date-effective view.
APPS.PER_ALL_PEOPLE·↳ FND_SESSIONS·↳ HR_PERSON_NAME·↳ PER_ALL_PEOPLE_F·Explore PER module →
-
Used to support user interface
APPS.PER_EXPANDED_ASSIGNMENTS_V1·↳ FND_SESSIONS·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PER module →
-
View: PER_ASSIGNMENTS_V3 12.2.2
Used to support user interface
APPS.PER_ASSIGNMENTS_V3·↳ FND_ID_FLEX_STRUCTURES·↳ FND_SESSIONS·↳ HR_ALL_ORGANIZATION_UNITS·Explore PER module →
-
View: PER_PEOPLE_V 12.1.1
Used to support user interface
APPS.PER_PEOPLE_V·↳ BEN_BENFTS_GRP·↳ FND_GLOBAL·↳ FND_LANGUAGES_VL·Explore PER module →
-
View: HR_EMPLOYEE_API_V 12.2.2
APPS.HR_EMPLOYEE_API_V·↳ PER_ADDRESSES·↳ PER_ALL_ASSIGNMENTS_F·↳ PER_ALL_PEOPLE_F·Explore PER module →
-
Date-effective view.
APPS.PER_CONT_WORKERS_CURRENT_X·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PER module →
-
Date-effective view.
APPS.PER_WORKFORCE_CURRENT_X·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PER module →
-
View: PER_CONT_WORKERS_X 12.1.1
Date-effective view.
APPS.PER_CONT_WORKERS_X·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PER module →
-
View: PER_ASSIGNMENTS_V3 12.1.1
Used to support user interface
APPS.PER_ASSIGNMENTS_V3·↳ FND_ID_FLEX_STRUCTURES·↳ FND_SESSIONS·↳ HR_ALL_ORGANIZATION_UNITS·Explore PER module →
-
View: PER_PEOPLE_V 12.2.2
Used to support user interface
APPS.PER_PEOPLE_V·↳ BEN_BENFTS_GRP·↳ FND_LANGUAGES_VL·↳ FND_SESSIONS·Explore PER module →
-
View: HR_EMPLOYEE_API_V 12.1.1
APPS.HR_EMPLOYEE_API_V·↳ PER_ADDRESSES·↳ PER_ALL_ASSIGNMENTS_F·↳ PER_ALL_PEOPLE_F·Explore PER module →
-
VIEW: APPS.PA_EXPENDITURES_V 12.1.1
-
VIEW: APPS.PA_EXPENDITURES_V 12.2.2
-
VIEW: APPS.EGO_PEOPLE_V 12.1.1
-
VIEW: APPS.EGO_PEOPLE_V 12.2.2
-
VIEW: APPS.PER_WORKFORCE_V2 12.2.2