Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - HRI Tables and Views

TABLE - HRI.HRI_AGE_BANDS

TABLE - HRI.HRI_GEN_HRCHY_SUMMARY

TABLE - HRI.HRI_INV_SPRTN_RSNS

TABLE - HRI.HRI_JOB_CATEGORY_SETS

TABLE - HRI.HRI_ORG_HRCHY_SUMMARY

TABLE - HRI.HRI_ORG_PARAMS

TABLE - HRI.HRI_ORG_PARAM_LIST

TABLE - HRI.HRI_PERSON_TYPE_CMBNS

TABLE - HRI.HRI_PRIMARY_HRCHYS

TABLE - HRI.HRI_RECRUITMENT_STAGES

TABLE - HRI.HRI_SERVICE_BANDS

TABLE - HRI.HRI_SUPV_HRCHY_SUMMARY

VIEW - APPS.HRIBV_ASGMVORGHRCHY

VIEW - APPS.HRIBV_ORG_HRCHY

VIEW - APPS.HRIBV_ORG_HRCHY_ROLLUP

VIEW - APPS.HRIBV_SUPV_HRCHY_ROLLUP_X

VIEW - APPS.HRIBV_SUPV_HRCHY_X

VIEW - APPS.HRIBV_TRNCNTR_HRCHY

VIEW - APPS.HRIBV_TRNCNTR_HRCHY_ROLLUP

VIEW - APPS.HRICV_HR_BIMONTH

VIEW - APPS.HRICV_HR_DAY

VIEW - APPS.HRICV_HR_MONTH

VIEW - APPS.HRICV_HR_QUARTER

VIEW - APPS.HRICV_HR_SEMIYEAR

VIEW - APPS.HRICV_HR_YEAR

VIEW - APPS.HRIFV_GRADE_RATES_BG

VIEW - APPS.HRIFV_PEREIT

VIEW - APPS.HRIFV_SAL_PRO

VIEW - APPS.HRIFV_US_EMPASGDTL_EMPXASG

VIEW - APPS.HRIFV_US_FEDREP_GEN_HRCHY

VIEW - APPS.HRIFV_US_FEDREP_GEN_H_LOCEXP

VIEW - APPS.HRIFV_US_PERDTL

VIEW - APPS.HRI_CL_ASGSTYP_BX_V

VIEW - APPS.HRI_CL_BUDPQH_H_V

VIEW - APPS.HRI_CL_CMPBEN_OBJ_X_V

VIEW - APPS.HRI_CL_CMPTNC_BX_V

VIEW - APPS.HRI_CL_EDU_ESTBMNT_V

VIEW - APPS.HRI_CL_EDU_EST_CAND_V

VIEW - APPS.HRI_CL_EDU_QUAL_AWRDBDY_V

VIEW - APPS.HRI_CL_EDU_QUAL_CAT_HX_V

VIEW - APPS.HRI_CL_EDU_QUAL_TITLE_V

VIEW - APPS.HRI_CL_EDU_QUAL_TYPE_V

VIEW - APPS.HRI_CL_EMPCAT_X_V

VIEW - APPS.HRI_CL_GB_ETHNC_X_V

VIEW - APPS.HRI_CL_GENDER_X_V

VIEW - APPS.HRI_CL_GRADE_BX_V

VIEW - APPS.HRI_CL_JOB_BX_V

VIEW - APPS.HRI_CL_JOB_CAT_X_V

VIEW - APPS.HRI_CL_ORG_BGR_BX_V

VIEW - APPS.HRI_CL_ORG_HRCY_BX_V

VIEW - APPS.HRI_CL_ORG_HR_HX_V

VIEW - APPS.HRI_CL_PER_EMP_HX_V

VIEW - APPS.HRI_CL_PER_HIRMGR_HX_V

VIEW - APPS.HRI_CL_PER_RECMGR_HX_V

VIEW - APPS.HRI_CL_PER_SUP_HX_V

VIEW - APPS.HRI_CL_POSITION_HX_V

VIEW - APPS.HRI_CL_PRF_RTNG_X_V

VIEW - APPS.HRI_CL_PTY_NONPTU_B_V

VIEW - APPS.HRI_CL_RECACT_SRCNAME_V

VIEW - APPS.HRI_CL_RECACT_TYPE_X_V

VIEW - APPS.HRI_CL_RQNVAC_PROFAREA_X_V

VIEW - APPS.HRI_CL_RQNVAC_VACNCY_H_V

VIEW - APPS.HRI_CL_RSN_SAL_X_V

VIEW - APPS.HRI_CL_RSN_SEP_X_V

VIEW - APPS.HRI_CL_TRAVEL_PERCENT_X_V

VIEW - APPS.HRI_CL_US_ETHNC_X_V

VIEW - APPS.HRI_CL_WAC_GAINTYP_X_V

VIEW - APPS.HRI_CL_WAC_LOSSTYP_X_V

VIEW - APPS.HRI_CL_WAC_SEPCAT_X_V

VIEW - APPS.HRI_CL_WMT_X_V

VIEW - APPS.HRI_CL_WORK_AT_HOME_X_V

VIEW - APPS.HRI_GRD_LOV_V

VIEW - APPS.HRI_JOB_LOV_V

VIEW - APPS.HRI_LOC_LOV_V

VIEW - APPS.HRI_ORG_LOV_V

Table: HRI_AGE_BANDS

[top of page]

HRI.HRI_AGE_BANDS does not reference any database object

HRI.HRI_AGE_BANDS is referenced by following:

HRI

VIEW - HRI_AGE_BANDS#

[top of page]

Table: HRI_GEN_HRCHY_SUMMARY

Primary Key: HRI_GEN_HRCHY_SUMMARY_PK

1. HIERARCHY_ID
2. HIERARCHY_VERSION_ID
3. HIERARCHY_NODE_ID
4. SUB_HIERARCHY_NODE_ID

[top of page]

HRI.HRI_GEN_HRCHY_SUMMARY does not reference any database object

HRI.HRI_GEN_HRCHY_SUMMARY is referenced by following:

HRI

VIEW - HRI_GEN_HRCHY_SUMMARY#

[top of page]

Table: HRI_INV_SPRTN_RSNS

[top of page]

HRI.HRI_INV_SPRTN_RSNS does not reference any database object

HRI.HRI_INV_SPRTN_RSNS is referenced by following:

HRI

VIEW - HRI_INV_SPRTN_RSNS#

[top of page]

Table: HRI_JOB_CATEGORY_SETS

[top of page]

HRI.HRI_JOB_CATEGORY_SETS does not reference any database object

HRI.HRI_JOB_CATEGORY_SETS is referenced by following:

HRI

VIEW - HRI_JOB_CATEGORY_SETS#

[top of page]

Table: HRI_ORG_HRCHY_SUMMARY

Primary Key: HRI_ORG_HRCHY_SUMMARY_PK

1. ORG_STRUCTURE_VERSION_ID
2. ORGANIZATION_ID
3. SUB_ORGANIZATION_ID

[top of page]

HRI.HRI_ORG_HRCHY_SUMMARY does not reference any database object

HRI.HRI_ORG_HRCHY_SUMMARY is referenced by following:

HRI

VIEW - HRI_ORG_HRCHY_SUMMARY#

[top of page]

Table: HRI_ORG_PARAMS

Primary Key: HRI_ORG_PARAMS_PK

1. ORG_PARAM_ID

Primary Key: HRI_ORG_PARAMS_UK1

1. ORGANIZATION_PROCESS
2. ORGANIZATION_ID
3. ORGANIZATION_STRUCTURE_ID

Primary Key: ORP_PK

1. ORG_PARAM_ID

Primary Key: ORP_UK

1. ORGANIZATION_PROCESS
2. ORGANIZATION_ID
3. ORGANIZATION_STRUCTURE_ID

Foreign Keys to this table:

[top of page]

HRI.HRI_ORG_PARAMS does not reference any database object

HRI.HRI_ORG_PARAMS is referenced by following:

HRI

VIEW - HRI_ORG_PARAMS#

[top of page]

Table: HRI_ORG_PARAM_LIST

Primary Key: HRI_ORG_PARAM_LIST_PK

1. ORG_PARAM_ID
2. ORGANIZATION_ID_GROUP
3. ORGANIZATION_ID_CHILD

Primary Key: OPL_PK

1. ORGANIZATION_ID_CHILD
2. ORG_PARAM_ID
3. ORGANIZATION_ID_GROUP

Foreign Keys from this table:

[top of page]

HRI.HRI_ORG_PARAM_LIST does not reference any database object

HRI.HRI_ORG_PARAM_LIST is referenced by following:

HRI

VIEW - HRI_ORG_PARAM_LIST#

[top of page]

Table: HRI_PERSON_TYPE_CMBNS

Primary Key: HRI_PERSON_TYPE_CMBNS_PK

1. PERSON_TYPE_PK

[top of page]

HRI.HRI_PERSON_TYPE_CMBNS does not reference any database object

HRI.HRI_PERSON_TYPE_CMBNS is referenced by following:

HRI

VIEW - HRI_PERSON_TYPE_CMBNS#

[top of page]

Table: HRI_PRIMARY_HRCHYS

Primary Key: HRI_PRIMARY_HRCHYS_PK

1. ORGANIZATION_ID
2. ORGANIZATION_STRUCTURE_ID
3. ORG_STRUCTURE_VERSION_ID

[top of page]

HRI.HRI_PRIMARY_HRCHYS does not reference any database object

HRI.HRI_PRIMARY_HRCHYS is referenced by following:

HRI

VIEW - HRI_PRIMARY_HRCHYS#

[top of page]

Table: HRI_RECRUITMENT_STAGES

Primary Key: HRI_RECRUITMENT_STAGES_PK

1. ASSIGNMENT_ID
2. ASSIGNMENT_START_DATE

[top of page]

HRI.HRI_RECRUITMENT_STAGES does not reference any database object

HRI.HRI_RECRUITMENT_STAGES is referenced by following:

HRI

VIEW - HRI_RECRUITMENT_STAGES#

[top of page]

Table: HRI_SERVICE_BANDS

[top of page]

HRI.HRI_SERVICE_BANDS does not reference any database object

HRI.HRI_SERVICE_BANDS is referenced by following:

HRI

VIEW - HRI_SERVICE_BANDS#

[top of page]

Table: HRI_SUPV_HRCHY_SUMMARY

Primary Key: HRI_SUPV_HRCHY_SUMMARY_PK

1. SUPV_BUSINESS_GROUP_ID
2. SUPV_PERSON_ID
3. SUPV_ASSIGNMENT_ID
4. SUB_PERSON_ID
5. SUB_ASSIGNMENT_ID

[top of page]

HRI.HRI_SUPV_HRCHY_SUMMARY does not reference any database object

HRI.HRI_SUPV_HRCHY_SUMMARY is referenced by following:

HRI

VIEW - HRI_SUPV_HRCHY_SUMMARY#

[top of page]

View: HRIBV_ASGMVORGHRCHY

[top of page]

APPS

SYNONYM - HRI_ORG_HRCHY_SUMMARY

SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL

PACKAGE - HR_BIS

PACKAGE - HR_GENERAL

PACKAGE - HR_SECURITY

SYNONYM - PER_ALL_PEOPLE_F

SYNONYM - PER_ORGANIZATION_STRUCTURES

SYNONYM - PER_ORG_STRUCTURE_VERSIONS

- PER_ASSIGNMENTS_F

APPS.HRIBV_ASGMVORGHRCHY is not referenced by any database object

[top of page]

View: HRIBV_ORG_HRCHY

[top of page]

APPS

SYNONYM - HRI_ORG_HRCHY_SUMMARY

SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL

PACKAGE - HR_BIS

PACKAGE - HR_GENERAL

SYNONYM - PER_ORGANIZATION_STRUCTURES

SYNONYM - PER_ORG_STRUCTURE_VERSIONS

APPS.HRIBV_ORG_HRCHY is not referenced by any database object

[top of page]

View: HRIBV_ORG_HRCHY_ROLLUP

[top of page]

APPS

SYNONYM - HRI_ORG_HRCHY_SUMMARY

SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL

PACKAGE - HR_BIS

PACKAGE - HR_GENERAL

SYNONYM - PER_ORGANIZATION_STRUCTURES

SYNONYM - PER_ORG_STRUCTURE_VERSIONS

APPS.HRIBV_ORG_HRCHY_ROLLUP is not referenced by any database object

[top of page]

View: HRIBV_SUPV_HRCHY_ROLLUP_X

[top of page]

APPS

SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL

PACKAGE - HR_BIS

PACKAGE - HR_GENERAL

PACKAGE - HR_PERSON_NAME

PACKAGE - HR_SECURITY

- PER_PEOPLE_X

- HRI_CS_SUPH_X_V

APPS.HRIBV_SUPV_HRCHY_ROLLUP_X is not referenced by any database object

[top of page]

View: HRIBV_SUPV_HRCHY_X

[top of page]

APPS

SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL

PACKAGE - HR_GENERAL

PACKAGE - HR_PERSON_NAME

PACKAGE - HR_SECURITY

- PER_PEOPLE_X

- HRI_CS_SUPH_X_V

APPS.HRIBV_SUPV_HRCHY_X is not referenced by any database object

[top of page]

View: HRIBV_TRNCNTR_HRCHY

[top of page]

APPS

SYNONYM - HRI_ORG_HRCHY_SUMMARY

SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL

PACKAGE - HR_BIS

PACKAGE - HR_GENERAL

SYNONYM - HR_ORGANIZATION_INFORMATION

PACKAGE - OTA_GENERAL

SYNONYM - PER_ORGANIZATION_STRUCTURES

SYNONYM - PER_ORG_STRUCTURE_VERSIONS

APPS.HRIBV_TRNCNTR_HRCHY is not referenced by any database object

[top of page]

View: HRIBV_TRNCNTR_HRCHY_ROLLUP

[top of page]

APPS

SYNONYM - HRI_ORG_HRCHY_SUMMARY

SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL

PACKAGE - HR_BIS

PACKAGE - HR_GENERAL

SYNONYM - HR_ORGANIZATION_INFORMATION

PACKAGE - OTA_GENERAL

SYNONYM - PER_ORGANIZATION_STRUCTURES

SYNONYM - PER_ORG_STRUCTURE_VERSIONS

APPS.HRIBV_TRNCNTR_HRCHY_ROLLUP is not referenced by any database object

[top of page]

View: HRICV_HR_BIMONTH

[top of page]

- HR_API

- HR_LOOKUPS

APPS.HRICV_HR_BIMONTH is not referenced by any database object

[top of page]

View: HRICV_HR_DAY

[top of page]

APPS

SYNONYM - FND_NEW_MESSAGES

APPS.HRICV_HR_DAY is not referenced by any database object

[top of page]

View: HRICV_HR_MONTH

[top of page]

- HR_API

- HR_LOOKUPS

APPS.HRICV_HR_MONTH is not referenced by any database object

[top of page]

View: HRICV_HR_QUARTER

[top of page]

- HR_API

- HR_LOOKUPS

APPS.HRICV_HR_QUARTER is not referenced by any database object

[top of page]

View: HRICV_HR_SEMIYEAR

[top of page]

- HR_API

- HR_LOOKUPS

APPS.HRICV_HR_SEMIYEAR is not referenced by any database object

[top of page]

View: HRICV_HR_YEAR

[top of page]

- HR_API

- HR_LOOKUPS

APPS.HRICV_HR_YEAR is not referenced by any database object

[top of page]

View: HRIFV_GRADE_RATES_BG

[top of page]

APPS

PACKAGE - HR_BIS

PACKAGE - HR_GENERAL

SYNONYM - PAY_GRADE_RULES_F

SYNONYM - PAY_RATES

SYNONYM - PER_GRADES

SYNONYM - PER_PAY_BASES

APPS.HRIFV_GRADE_RATES_BG is not referenced by any database object

[top of page]

View: HRIFV_PEREIT

[top of page]

APPS

PACKAGE - HR_BIS

PACKAGE - HR_GENERAL

PACKAGE - HR_PERSON_NAME

PACKAGE - HR_SECURITY

SYNONYM - PER_PEOPLE_EXTRA_INFO

SYNONYM - PER_PEOPLE_INFO_TYPES

- PER_PEOPLE_F

APPS.HRIFV_PEREIT is not referenced by any database object

[top of page]

View: HRIFV_SAL_PRO

[top of page]

APPS

SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL

PACKAGE - HR_BIS

PACKAGE - HR_GENERAL

PACKAGE - HR_SECURITY

SYNONYM - PAY_ELEMENT_TYPES_F

SYNONYM - PAY_INPUT_VALUES_F

SYNONYM - PER_ALL_PEOPLE_F

SYNONYM - PER_PAY_BASES

SYNONYM - PER_PAY_PROPOSALS

SYNONYM - PER_PERIODS_OF_SERVICE

SYNONYM - PER_TIME_PERIOD_TYPES

- PER_ASSIGNMENTS_F

- PAY_PAYROLLS_F

APPS.HRIFV_SAL_PRO is not referenced by any database object

[top of page]

View: HRIFV_US_EMPASGDTL_EMPXASG

[top of page]

APPS

PACKAGE - FND_DATE

SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL

PACKAGE - HR_BIS

PACKAGE - HR_GENERAL

PACKAGE - HR_SECURITY

SYNONYM - PER_ALL_PEOPLE_F

SYNONYM - PER_ASSIGNMENT_STATUS_TYPES

SYNONYM - PER_ASSIGNMENT_STATUS_TYPES_TL

SYNONYM - PER_ASS_STATUS_TYPE_AMENDS

SYNONYM - PER_ASS_STATUS_TYPE_AMENDS_TL

SYNONYM - PER_PERIODS_OF_SERVICE

- PER_ASSIGNMENTS_F

- PER_BUSINESS_GROUPS

APPS.HRIFV_US_EMPASGDTL_EMPXASG is not referenced by any database object

[top of page]

View: HRIFV_US_FEDREP_GEN_HRCHY

[top of page]

APPS

SYNONYM - HRI_GEN_HRCHY_SUMMARY

SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL

PACKAGE - HR_BIS

PACKAGE - HR_GENERAL

SYNONYM - HR_LOCATIONS_ALL

SYNONYM - HR_LOCATIONS_ALL_TL

SYNONYM - HR_LOCATION_EXTRA_INFO

SYNONYM - HR_ORGANIZATION_INFORMATION

SYNONYM - PER_GEN_HIERARCHY

SYNONYM - PER_GEN_HIERARCHY_NODES

SYNONYM - PER_GEN_HIERARCHY_VERSIONS

APPS.HRIFV_US_FEDREP_GEN_HRCHY is not referenced by any database object

[top of page]

View: HRIFV_US_FEDREP_GEN_H_LOCEXP

[top of page]

APPS

SYNONYM - HRI_GEN_HRCHY_SUMMARY

PACKAGE - HR_GENERAL

SYNONYM - HR_LOCATIONS_ALL

SYNONYM - HR_LOCATIONS_ALL_TL

APPS.HRIFV_US_FEDREP_GEN_H_LOCEXP is not referenced by any database object

[top of page]

View: HRIFV_US_PERDTL

[top of page]

APPS

PACKAGE - FND_DATE

PACKAGE - HR_BIS

PACKAGE - HR_GENERAL

PACKAGE - HR_PERSON_NAME

PACKAGE - HR_SECURITY

- PER_BUSINESS_GROUPS

- PER_PEOPLE_F

APPS.HRIFV_US_PERDTL is not referenced by any database object

[top of page]

View: HRI_CL_ASGSTYP_BX_V

[top of page]

APPS

PACKAGE - HR_BIS

PACKAGE - HR_GENERAL

SYNONYM - PER_ASSIGNMENT_STATUS_TYPES

SYNONYM - PER_ASSIGNMENT_STATUS_TYPES_TL

SYNONYM - PER_ASS_STATUS_TYPE_AMENDS

SYNONYM - PER_ASS_STATUS_TYPE_AMENDS_TL

APPS.HRI_CL_ASGSTYP_BX_V is not referenced by any database object

[top of page]

View: HRI_CL_BUDPQH_H_V

[top of page]

APPS

PACKAGE - HR_BIS

SYNONYM - PQH_BUDGETS

APPS.HRI_CL_BUDPQH_H_V is not referenced by any database object

[top of page]

View: HRI_CL_CMPBEN_OBJ_X_V

[top of page]

APPS

PACKAGE - HR_API

PACKAGE - HR_GENERAL

VIEW - HR_LOOKUPS

PUBLIC

SYNONYM - DUAL

- DUAL

APPS.HRI_CL_CMPBEN_OBJ_X_V is not referenced by any database object

[top of page]

View: HRI_CL_CMPTNC_BX_V

[top of page]

APPS

PACKAGE - HR_BIS

PACKAGE - HR_GENERAL

SYNONYM - PER_COMPETENCES

PUBLIC

SYNONYM - DUAL

- DUAL

APPS.HRI_CL_CMPTNC_BX_V is not referenced by any database object

[top of page]

View: HRI_CL_EDU_ESTBMNT_V

[top of page]

APPS

SYNONYM - PER_ESTABLISHMENTS

PUBLIC

SYNONYM - DUAL

- DUAL

APPS.HRI_CL_EDU_ESTBMNT_V is not referenced by any database object

[top of page]

View: HRI_CL_EDU_EST_CAND_V

[top of page]

APPS

SYNONYM - PER_ESTABLISHMENT_ATTENDANCES

PUBLIC

SYNONYM - DUAL

- DUAL

APPS.HRI_CL_EDU_EST_CAND_V is not referenced by any database object

[top of page]

View: HRI_CL_EDU_QUAL_AWRDBDY_V

[top of page]

APPS

SYNONYM - PER_QUALIFICATIONS

PUBLIC

SYNONYM - DUAL

- DUAL

APPS.HRI_CL_EDU_QUAL_AWRDBDY_V is not referenced by any database object

[top of page]

View: HRI_CL_EDU_QUAL_CAT_HX_V

[top of page]

APPS

PACKAGE - HR_API

PACKAGE - HR_GENERAL

VIEW - HR_LOOKUPS

PUBLIC

SYNONYM - DUAL

- DUAL

APPS.HRI_CL_EDU_QUAL_CAT_HX_V is not referenced by any database object

[top of page]

View: HRI_CL_EDU_QUAL_TITLE_V

[top of page]

APPS

SYNONYM - PER_QUALIFICATIONS

PUBLIC

SYNONYM - DUAL

- DUAL

APPS.HRI_CL_EDU_QUAL_TITLE_V is not referenced by any database object

[top of page]

View: HRI_CL_EDU_QUAL_TYPE_V

[top of page]

APPS

SYNONYM - PER_QUALIFICATION_TYPES

PUBLIC

SYNONYM - DUAL

- DUAL

APPS.HRI_CL_EDU_QUAL_TYPE_V is not referenced by any database object

[top of page]

View: HRI_CL_EMPCAT_X_V

[top of page]

APPS

PACKAGE - HR_API

PACKAGE - HR_GENERAL

VIEW - HR_LOOKUPS

PUBLIC

SYNONYM - DUAL

- DUAL

APPS.HRI_CL_EMPCAT_X_V is not referenced by any database object

[top of page]

View: HRI_CL_GB_ETHNC_X_V

[top of page]

APPS

PACKAGE - HR_GENERAL

PUBLIC

SYNONYM - DUAL

- HR_API

- DUAL

- HR_LOOKUPS

APPS.HRI_CL_GB_ETHNC_X_V is not referenced by any database object

[top of page]

View: HRI_CL_GENDER_X_V

[top of page]

APPS

PACKAGE - HR_GENERAL

PUBLIC

SYNONYM - DUAL

- HR_API

- DUAL

- HR_LOOKUPS

APPS.HRI_CL_GENDER_X_V is not referenced by any database object

[top of page]

View: HRI_CL_GRADE_BX_V

[top of page]

APPS

PACKAGE - HR_BIS

PACKAGE - HR_GENERAL

SYNONYM - PER_GRADES

PUBLIC

SYNONYM - DUAL

- DUAL

APPS.HRI_CL_GRADE_BX_V is not referenced by any database object

[top of page]

View: HRI_CL_JOB_BX_V

[top of page]

APPS

PACKAGE - HR_BIS

PACKAGE - HR_GENERAL

SYNONYM - PER_JOBS

PUBLIC

SYNONYM - DUAL

- DUAL

APPS.HRI_CL_JOB_BX_V is not referenced by any database object

[top of page]

View: HRI_CL_JOB_CAT_X_V

[top of page]

APPS

PACKAGE - HR_GENERAL

PUBLIC

SYNONYM - DUAL

- HR_API

- DUAL

- HR_LOOKUPS

APPS.HRI_CL_JOB_CAT_X_V is not referenced by any database object

[top of page]

View: HRI_CL_ORG_BGR_BX_V

[top of page]

APPS

PACKAGE - FND_GLOBAL

SYNONYM - HR_ALL_ORGANIZATION_UNITS

SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL

PACKAGE - HR_BIS

PACKAGE - HR_GENERAL

SYNONYM - HR_ORGANIZATION_INFORMATION

PUBLIC

SYNONYM - DUAL

- DUAL

APPS.HRI_CL_ORG_BGR_BX_V is not referenced by any database object

[top of page]

View: HRI_CL_ORG_HRCY_BX_V

[top of page]

APPS

PACKAGE - FND_GLOBAL

PACKAGE - HRI_OLTP_VIEW_SECURITY

PACKAGE - HR_BIS

PACKAGE - HR_GENERAL

- HRI_CL_ORG_HRCY_N_V

APPS.HRI_CL_ORG_HRCY_BX_V is not referenced by any database object

[top of page]

View: HRI_CL_ORG_HR_HX_V

[top of page]

APPS

PACKAGE - FND_GLOBAL

PACKAGE - HR_BIS

PACKAGE - HR_GENERAL

SYNONYM - HR_ORGANIZATION_INFORMATION

PACKAGE - HR_SECURITY

PUBLIC

SYNONYM - DUAL

- HR_ORGANIZATION_UNITS

- DUAL

APPS.HRI_CL_ORG_HR_HX_V is not referenced by any database object

[top of page]

View: HRI_CL_PER_EMP_HX_V

[top of page]

APPS

PACKAGE - HR_BIS

PACKAGE - HR_GENERAL

PACKAGE - HR_PERSON_NAME

PACKAGE - HR_SECURITY

PUBLIC

SYNONYM - DUAL

- PER_PEOPLE_X

- DUAL

APPS.HRI_CL_PER_EMP_HX_V is not referenced by any database object

[top of page]

View: HRI_CL_PER_HIRMGR_HX_V

[top of page]

APPS

PACKAGE - HR_GENERAL

PACKAGE - HR_PERSON_NAME

PACKAGE - HR_SECURITY

SYNONYM - PER_ALL_VACANCIES

PUBLIC

SYNONYM - DUAL

- DUAL

- PER_PEOPLE_F

APPS.HRI_CL_PER_HIRMGR_HX_V is not referenced by any database object

[top of page]

View: HRI_CL_PER_RECMGR_HX_V

[top of page]

APPS

PACKAGE - HR_GENERAL

PACKAGE - HR_PERSON_NAME

PACKAGE - HR_SECURITY

SYNONYM - PER_ALL_VACANCIES

PUBLIC

SYNONYM - DUAL

- DUAL

- PER_PEOPLE_F

APPS.HRI_CL_PER_RECMGR_HX_V is not referenced by any database object

[top of page]

View: HRI_CL_PER_SUP_HX_V

[top of page]

APPS

PACKAGE - HR_GENERAL

PACKAGE - HR_PERSON_NAME

PACKAGE - HR_SECURITY

PUBLIC

SYNONYM - DUAL

- PER_ASSIGNMENTS_X

- DUAL

- PER_PEOPLE_X

APPS.HRI_CL_PER_SUP_HX_V is not referenced by any database object

[top of page]

View: HRI_CL_POSITION_HX_V

[top of page]

APPS

PACKAGE - HR_BIS

PACKAGE - HR_GENERAL

PACKAGE - HR_SECURITY

PUBLIC

SYNONYM - DUAL

- PER_POSITIONS

- DUAL

APPS.HRI_CL_POSITION_HX_V is not referenced by any database object

[top of page]

View: HRI_CL_PRF_RTNG_X_V

[top of page]

APPS

PACKAGE - HR_GENERAL

PUBLIC

SYNONYM - DUAL

- HR_API

- DUAL

- HR_LOOKUPS

APPS.HRI_CL_PRF_RTNG_X_V is not referenced by any database object

[top of page]

View: HRI_CL_PTY_NONPTU_B_V

[top of page]

APPS

PACKAGE - HR_BIS

SYNONYM - PER_PERSON_TYPES

SYNONYM - PER_PERSON_TYPES_TL

APPS.HRI_CL_PTY_NONPTU_B_V is not referenced by any database object

[top of page]

View: HRI_CL_RECACT_SRCNAME_V

[top of page]

APPS

PACKAGE - HR_GENERAL

SYNONYM - PER_ALL_ASSIGNMENTS_F

PUBLIC

SYNONYM - DUAL

- DUAL

APPS.HRI_CL_RECACT_SRCNAME_V is not referenced by any database object

[top of page]

View: HRI_CL_RECACT_TYPE_X_V

[top of page]

APPS

PACKAGE - HR_API

PACKAGE - HR_GENERAL

VIEW - HR_LOOKUPS

PUBLIC

SYNONYM - DUAL

- DUAL

APPS.HRI_CL_RECACT_TYPE_X_V is not referenced by any database object

[top of page]

View: HRI_CL_RQNVAC_PROFAREA_X_V

[top of page]

APPS

PACKAGE - HR_API

PACKAGE - HR_GENERAL

VIEW - HR_LOOKUPS

PUBLIC

SYNONYM - DUAL

- DUAL

APPS.HRI_CL_RQNVAC_PROFAREA_X_V is not referenced by any database object

[top of page]

View: HRI_CL_RQNVAC_VACNCY_H_V

[top of page]

APPS

PACKAGE - HR_GENERAL

PACKAGE - HR_SECURITY

PUBLIC

SYNONYM - DUAL

- DUAL

- PER_VACANCIES

APPS.HRI_CL_RQNVAC_VACNCY_H_V is not referenced by any database object

[top of page]

View: HRI_CL_RSN_SAL_X_V

[top of page]

APPS

PACKAGE - HR_GENERAL

PUBLIC

SYNONYM - DUAL

- HR_API

- DUAL

- HR_LOOKUPS

APPS.HRI_CL_RSN_SAL_X_V is not referenced by any database object

[top of page]

View: HRI_CL_RSN_SEP_X_V

[top of page]

APPS

PACKAGE - HRI_OLTP_VIEW_MESSAGE

SYNONYM - HRI_UNASSIGNED

PACKAGE - HR_GENERAL

- HR_STANDARD_LOOKUPS

APPS.HRI_CL_RSN_SEP_X_V is not referenced by any database object

[top of page]

View: HRI_CL_TRAVEL_PERCENT_X_V

[top of page]

APPS

PACKAGE - HR_API

PACKAGE - HR_GENERAL

VIEW - HR_LOOKUPS

PUBLIC

SYNONYM - DUAL

- DUAL

APPS.HRI_CL_TRAVEL_PERCENT_X_V is not referenced by any database object

[top of page]

View: HRI_CL_US_ETHNC_X_V

[top of page]

APPS

PACKAGE - HR_GENERAL

PUBLIC

SYNONYM - DUAL

- HR_API

- DUAL

- HR_LOOKUPS

APPS.HRI_CL_US_ETHNC_X_V is not referenced by any database object

[top of page]

View: HRI_CL_WAC_GAINTYP_X_V

[top of page]

APPS

PACKAGE - HR_API

PACKAGE - HR_GENERAL

VIEW - HR_LOOKUPS

PUBLIC

SYNONYM - DUAL

- DUAL

APPS.HRI_CL_WAC_GAINTYP_X_V is not referenced by any database object

[top of page]

View: HRI_CL_WAC_LOSSTYP_X_V

[top of page]

APPS

PACKAGE - HR_API

PACKAGE - HR_GENERAL

VIEW - HR_LOOKUPS

PUBLIC

SYNONYM - DUAL

- DUAL

APPS.HRI_CL_WAC_LOSSTYP_X_V is not referenced by any database object

[top of page]

View: HRI_CL_WAC_SEPCAT_X_V

[top of page]

APPS

PACKAGE - HR_API

PACKAGE - HR_GENERAL

VIEW - HR_LOOKUPS

PUBLIC

SYNONYM - DUAL

- DUAL

APPS.HRI_CL_WAC_SEPCAT_X_V is not referenced by any database object

[top of page]

View: HRI_CL_WMT_X_V

[top of page]

APPS

PACKAGE - HR_API

PACKAGE - HR_GENERAL

VIEW - HR_LOOKUPS

APPS.HRI_CL_WMT_X_V is not referenced by any database object

[top of page]

View: HRI_CL_WORK_AT_HOME_X_V

[top of page]

APPS

PACKAGE - HR_API

PACKAGE - HR_GENERAL

VIEW - HR_LOOKUPS

PUBLIC

SYNONYM - DUAL

- DUAL

APPS.HRI_CL_WORK_AT_HOME_X_V is not referenced by any database object

[top of page]

View: HRI_GRD_LOV_V

[top of page]

APPS

PACKAGE - HR_BIS

SYNONYM - PER_GRADES

SYNONYM - PER_GRADES_TL

APPS.HRI_GRD_LOV_V is not referenced by any database object

[top of page]

View: HRI_JOB_LOV_V

[top of page]

APPS

PACKAGE - HR_BIS

SYNONYM - PER_JOBS

SYS

TABLE - DUAL

APPS.HRI_JOB_LOV_V is not referenced by any database object

[top of page]

View: HRI_LOC_LOV_V

[top of page]

APPS

PACKAGE - HR_BIS

SYNONYM - HR_LOCATIONS_ALL

SYNONYM - HR_LOCATIONS_ALL_TL

APPS.HRI_LOC_LOV_V is not referenced by any database object

[top of page]

View: HRI_ORG_LOV_V

[top of page]

APPS

PACKAGE - HRBISORGPARAMS

SYNONYM - HRI_ORG_PARAM_LIST

PACKAGE - HR_GENERAL

PACKAGE - HR_SECURITY

- HR_ORGANIZATION_UNITS

APPS.HRI_ORG_LOV_V is not referenced by any database object

[top of page]