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 - PQH Tables and Views

TABLE - HR.PQH_ACCOMMODATIONS_F
TABLE - HR.PQH_ASSIGN_ACCOMMODATIONS_F
TABLE - HR.PQH_ATTRIBUTES
TABLE - HR.PQH_ATTRIBUTES_TL
TABLE - HR.PQH_ATTRIBUTE_RANGES
TABLE - HR.PQH_BDGT_CMMTMNT_ELMNTS
TABLE - HR.PQH_BDGT_POOL_REALLOCTIONS
TABLE - HR.PQH_BDGT_POOL_REALLOCTIONS_EFC
TABLE - HR.PQH_BUDGETS
TABLE - HR.PQH_BUDGETS_EFC
TABLE - HR.PQH_BUDGET_DETAILS
TABLE - HR.PQH_BUDGET_DETAILS_EFC
TABLE - HR.PQH_BUDGET_ELEMENTS
TABLE - HR.PQH_BUDGET_FUND_SRCS
TABLE - HR.PQH_BUDGET_GL_FLEX_MAPS
TABLE - HR.PQH_BUDGET_PERIODS
TABLE - HR.PQH_BUDGET_PERIODS_EFC
TABLE - HR.PQH_BUDGET_POOLS
TABLE - HR.PQH_BUDGET_SETS
TABLE - HR.PQH_BUDGET_SETS_EFC
TABLE - HR.PQH_BUDGET_VERSIONS
TABLE - HR.PQH_BUDGET_VERSIONS_EFC
TABLE - HR.PQH_COPY_ENTITY_ATTRIBS
TABLE - HR.PQH_COPY_ENTITY_CONTEXTS
TABLE - HR.PQH_COPY_ENTITY_FUNCTIONS
TABLE - HR.PQH_COPY_ENTITY_PREFS
TABLE - HR.PQH_COPY_ENTITY_RESULTS
TABLE - HR.PQH_COPY_ENTITY_TXNS
TABLE - HR.PQH_CORPS_DEFINITIONS
TABLE - HR.PQH_CORPS_EXTRA_INFO
TABLE - HR.PQH_CORPS_INFO_TYPES
TABLE - HR.PQH_CRITERIA_RATE_DEFN
TABLE - HR.PQH_CRITERIA_RATE_DEFN_TL
TABLE - HR.PQH_CRITERIA_RATE_ELEMENTS
TABLE - HR.PQH_CRITERIA_RATE_FACTORS
TABLE - HR.PQH_DE_CASE_GROUPS
TABLE - HR.PQH_DE_INS_END_REASONS
TABLE - HR.PQH_DE_LEVEL_CODES
TABLE - HR.PQH_DE_LEVEL_NUMBERS
TABLE - HR.PQH_DE_OPERATIONS
TABLE - HR.PQH_DE_RESULT_SETS
TABLE - HR.PQH_DE_TATIGKEIT_DETAILS
TABLE - HR.PQH_DE_WRKPLC_VLDTNS
TABLE - HR.PQH_DE_WRKPLC_VLDTN_JOBFTRS
TABLE - HR.PQH_DE_WRKPLC_VLDTN_JOBS
TABLE - HR.PQH_DE_WRKPLC_VLDTN_LVLNUMS
TABLE - HR.PQH_DE_WRKPLC_VLDTN_OPS
TABLE - HR.PQH_DE_WRKPLC_VLDTN_VERS
TABLE - HR.PQH_DFLT_BUDGET_ELEMENTS
TABLE - HR.PQH_DFLT_BUDGET_SETS
TABLE - HR.PQH_DFLT_FUND_SRCS
TABLE - HR.PQH_DOCUMENTS_F
TABLE - HR.PQH_DOCUMENT_ATTRIBUTES_F
TABLE - HR.PQH_ELEMENT_COMMITMENTS
TABLE - HR.PQH_ELEMENT_COMMITMENTS_EFC
TABLE - HR.PQH_FR_EMP_STAT_SITUATIONS
TABLE - HR.PQH_FR_GLOBAL_INDICES_F
TABLE - HR.PQH_FR_STAT_SITUATIONS
TABLE - HR.PQH_FR_STAT_SITUATION_RULES
TABLE - HR.PQH_FR_VALIDATIONS
TABLE - HR.PQH_FR_VALIDATION_EVENTS
TABLE - HR.PQH_FR_VALIDATION_PERIODS
TABLE - HR.PQH_FYI_NOTIFY
TABLE - HR.PQH_GL_INTERFACE
TABLE - HR.PQH_GL_INTERFACE_EFC
TABLE - HR.PQH_GMS_EXCESS
TABLE - HR.PQH_PA_WHATIF_RESULTS
TABLE - HR.PQH_POSITION_TRANSACTIONS
TABLE - HR.PQH_PROCESS_LOG
TABLE - HR.PQH_PTE_SHADOW
TABLE - HR.PQH_PTX_DPF_DF
TABLE - HR.PQH_PTX_DPF_DF_SHADOW
TABLE - HR.PQH_PTX_EXTRA_INFO
TABLE - HR.PQH_PTX_INFO_TYPES
TABLE - HR.PQH_PTX_SHADOW
TABLE - HR.PQH_RATE_ELEMENT_RELATIONS
TABLE - HR.PQH_RATE_FACTOR_ON_ELMNTS
TABLE - HR.PQH_RATE_MATRIX_NODES
TABLE - HR.PQH_RATE_MATRIX_RATES_F
TABLE - HR.PQH_REF_TEMPLATES
TABLE - HR.PQH_ROLES
TABLE - HR.PQH_ROLE_EXTRA_INFO
TABLE - HR.PQH_ROLE_INFO_TYPES
TABLE - HR.PQH_ROLE_TEMPLATES
TABLE - HR.PQH_ROUTING_CATEGORIES
TABLE - HR.PQH_ROUTING_HISTORY
TABLE - HR.PQH_ROUTING_HIST_ATTRIBS
TABLE - HR.PQH_ROUTING_LISTS
TABLE - HR.PQH_ROUTING_LIST_MEMBERS
TABLE - HR.PQH_RT_MATRIX_NODE_VALUES
TABLE - HR.PQH_RULES
TABLE - HR.PQH_RULE_ATTRIBUTES
TABLE - HR.PQH_RULE_SETS
TABLE - HR.PQH_RULE_SETS_TL
TABLE - HR.PQH_SITUATIONS
TABLE - HR.PQH_SPECIAL_ATTRIBUTES
TABLE - HR.PQH_SS_APPROVAL_HISTORY
TABLE - HR.PQH_SS_PRINT_DATA
TABLE - HR.PQH_SS_PRINT_LABEL_TEMP
TABLE - HR.PQH_SS_STEP_HISTORY
TABLE - HR.PQH_SS_TRANSACTION_HISTORY
TABLE - HR.PQH_SS_VALUE_HISTORY
TABLE - HR.PQH_TABLE_ROUTE
TABLE - HR.PQH_TABLE_ROUTE_TL
TABLE - HR.PQH_TEMPLATES
TABLE - HR.PQH_TEMPLATES_TL
TABLE - HR.PQH_TEMPLATE_ATTRIBUTES
TABLE - HR.PQH_TJR_SHADOW
TABLE - HR.PQH_TRANSACTION_CATEGORIES
TABLE - HR.PQH_TRANSACTION_CATEGORIES_TL
TABLE - HR.PQH_TRANSACTION_TEMPLATES
TABLE - HR.PQH_TXN_CATEGORY_ATTRIBUTES
TABLE - HR.PQH_TXN_CATEGORY_DOCUMENTS
TABLE - HR.PQH_TXN_JOB_REQUIREMENTS
TABLE - HR.PQH_WIZARD_CANVASES
TABLE - HR.PQH_WORKSHEETS
TABLE - HR.PQH_WORKSHEET_BDGT_ELMNTS
TABLE - HR.PQH_WORKSHEET_BUDGET_SETS
TABLE - HR.PQH_WORKSHEET_BUDGET_SETS_EFC
TABLE - HR.PQH_WORKSHEET_DETAILS
TABLE - HR.PQH_WORKSHEET_DETAILS_EFC
TABLE - HR.PQH_WORKSHEET_FUND_SRCS
TABLE - HR.PQH_WORKSHEET_PERIODS
TABLE - HR.PQH_WORKSHEET_PERIODS_EFC
VIEW - APPS.PQH_ATTRIBUTES_VL
VIEW - APPS.PQH_ATTRIBUTE_RANGES_V1
VIEW - APPS.PQH_ATTRIBUTE_RANGES_V2
VIEW - APPS.PQH_ATTRIBUTE_RANGES_V3
VIEW - APPS.PQH_ATTRIBUTE_RANGES_V4
VIEW - APPS.PQH_BDGT_CMMTMNT_ELMNTS_V
VIEW - APPS.PQH_BDGT_POOL_REALLOCTIONS_V
VIEW - APPS.PQH_BDGT_REALLOC_FOLDERS_V
VIEW - APPS.PQH_BUDGETS_V
VIEW - APPS.PQH_BUDGET_DETAILS_V
VIEW - APPS.PQH_BUDGET_POOLS_V
VIEW - APPS.PQH_CMMTMNT_ENTITIES_V
VIEW - APPS.PQH_COPY_ENTITY_CONTEXTS_V
VIEW - APPS.PQH_COPY_ENTITY_POSITIONS_V
VIEW - APPS.PQH_COPY_ENTITY_POSUPD_V
VIEW - APPS.PQH_COPY_ENTITY_PREFS_V
VIEW - APPS.PQH_CORPS_CAREER_PATHS_V
VIEW - APPS.PQH_CORPS_DEFINITIONS_V
VIEW - APPS.PQH_CORPS_DOCUMENTS_V
VIEW - APPS.PQH_CORPS_EXAMS_V
VIEW - APPS.PQH_CORPS_FILERES_V
VIEW - APPS.PQH_CORPS_GRADES_V
VIEW - APPS.PQH_CORPS_NATURE_HGRID_V
VIEW - APPS.PQH_CORPS_ORGANIZATIONS_V
VIEW - APPS.PQH_CORPS_RULES_V
VIEW - APPS.PQH_CORPS_TRAININGS_V
VIEW - APPS.PQH_DE_CS_GRADES_V
VIEW - APPS.PQH_ENTITY_ELEMENT_TYPES_V
VIEW - APPS.PQH_FR_CAGR_ENTITLEMENTS_V
VIEW - APPS.PQH_FR_STAT_SITUATIONS_V
VIEW - APPS.PQH_INFO_TYPE_SECURITY_RIT_V
VIEW - APPS.PQH_ORGANIZATION_BUDGETS_V
VIEW - APPS.PQH_PC_ORG_HIERARCHIES_V
VIEW - APPS.PQH_PC_ORG_SUMMARY_V
VIEW - APPS.PQH_POSITION_BUDGETS_V
VIEW - APPS.PQH_POSITION_ELEMENT_TYPES_V
VIEW - APPS.PQH_POSITION_EXTRA_INFO_V
VIEW - APPS.PQH_POSITION_ROLES_V
VIEW - APPS.PQH_POSITION_TRANSACTIONS_V
VIEW - APPS.PQH_POSN_CTL_HIERARCHY_V
VIEW - APPS.PQH_PTX_HISTORY_V
VIEW - APPS.PQH_REALLOC_FOLDER_TXN_V
VIEW - APPS.PQH_REALLOC_TXN_DETAILS_V
VIEW - APPS.PQH_REALLOC_TXN_PERIODS_V
VIEW - APPS.PQH_REF_TEMPLATES_V
VIEW - APPS.PQH_ROLES_V
VIEW - APPS.PQH_ROLE_PEOPLE_V
VIEW - APPS.PQH_ROLE_TEMPLATES_V
VIEW - APPS.PQH_ROLE_USERS_V
VIEW - APPS.PQH_ROLE_USERS_V1
VIEW - APPS.PQH_ROUTING_CATEGORIES_V
VIEW - APPS.PQH_ROUTING_HISTORY_V
VIEW - APPS.PQH_ROUTING_HIST_ATTRIBS_V
VIEW - APPS.PQH_ROUTING_LIST_MEMBERS_V
VIEW - APPS.PQH_RULES_V
VIEW - APPS.PQH_RULE_SETS_V
VIEW - APPS.PQH_RULE_SETS_VL
VIEW - APPS.PQH_SPECIAL_ATTRIBUTES_V
VIEW - APPS.PQH_TABLE_ROUTE_VL
VIEW - APPS.PQH_TEMPLATES_V
VIEW - APPS.PQH_TEMPLATES_VL
VIEW - APPS.PQH_TEMPLATE_ATTRIBUTES_V
VIEW - APPS.PQH_TRANSACTIONS_V
VIEW - APPS.PQH_TRANSACTION_CATEGORIES_V
VIEW - APPS.PQH_TRANSACTION_CATEGORIES_VL
VIEW - APPS.PQH_TRANSACTION_TEMPLATES_V
VIEW - APPS.PQH_TXN_CATEGORY_ATTRIBUTES_V
VIEW - APPS.PQH_TXN_JOB_REQUIREMENTS_V
VIEW - APPS.PQH_WORKSHEET_ORGANIZATIONS_V

Table: PQH_ACCOMMODATIONS_F

Description: Information Related to Accomodation
Primary Key: PQH_ACCOMMODATIONS_F_PK
  1. ACCOMMODATION_ID
  2. EFFECTIVE_START_DATE
  3. EFFECTIVE_END_DATE

[top of page]

HR.PQH_ACCOMMODATIONS_F does not reference any database object

HR.PQH_ACCOMMODATIONS_F is referenced by following:

APPS
SYNONYM - PQH_ACCOMMODATIONS_F
TRIGGER - PQH_ACCOMMODATIONS_F_WHO
PUBLIC
SYNONYM - PQH_ACCOMMODATIONS_F

[top of page]

Table: PQH_ASSIGN_ACCOMMODATIONS_F

Description: Information Related to Accomodation Assigned
Primary Key: PQH_ASSIGN_ACCOMMODATIONS_PK
  1. ASSIGNMENT_ACCO_ID
  2. EFFECTIVE_START_DATE
  3. EFFECTIVE_END_DATE

[top of page]

HR.PQH_ASSIGN_ACCOMMODATIONS_F does not reference any database object

HR.PQH_ASSIGN_ACCOMMODATIONS_F is referenced by following:

APPS
SYNONYM - PQH_ASSIGN_ACCOMMODATIONS_F
TRIGGER - PQH_ASSIGN_ACCOMMODATIONS_WHO
PUBLIC
SYNONYM - PQH_ASSIGN_ACCOMMODATIONS_F

[top of page]

Table: PQH_ATTRIBUTES

Description: ATTRIBUTE stores the information about attributes being used in transactions.
Primary Key: PQH_ATTRIBUTES_PK
  1. ATTRIBUTE_ID
Primary Key: PQH_ATTRIBUTES_UK
  1. MASTER_TABLE_ROUTE_ID
  2. COLUMN_NAME
  3. LEGISLATION_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_ATTRIBUTES.MASTER_ATTRIBUTE_ID PQH_ATTRIBUTES
PQH_ATTRIBUTES.MASTER_TABLE_ROUTE_ID PQH_TABLE_ROUTE
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_ATTRIBUTES.MASTER_ATTRIBUTE_ID PQH_ATTRIBUTES
PQH_ATTRIBUTE_RANGES.ATTRIBUTE_ID PQH_ATTRIBUTES
PQH_DOCUMENT_ATTRIBUTES_F.ATTRIBUTE_ID PQH_ATTRIBUTES
PQH_ROUTING_HIST_ATTRIBS.ATTRIBUTE_ID PQH_ATTRIBUTES
PQH_TEMPLATE_ATTRIBUTES.ATTRIBUTE_ID PQH_ATTRIBUTES
PQH_TXN_CATEGORY_ATTRIBUTES.ATTRIBUTE_ID PQH_ATTRIBUTES

[top of page]

HR.PQH_ATTRIBUTES does not reference any database object

HR.PQH_ATTRIBUTES is referenced by following:

APPS
SYNONYM - PQH_ATTRIBUTES
TRIGGER - PQH_ATTRIBUTES_WHO
PUBLIC
SYNONYM - PQH_ATTRIBUTES

[top of page]

Table: PQH_ATTRIBUTES_TL

Description: Attribute information used in transactions. Stores translated values.
Primary Key: PQH_ATTRIBUTES_TL_PK
  1. ATTRIBUTE_ID
  2. LANGUAGE

[top of page]

HR.PQH_ATTRIBUTES_TL does not reference any database object

HR.PQH_ATTRIBUTES_TL is referenced by following:

APPS
SYNONYM - PQH_ATTRIBUTES_TL
TRIGGER - PQH_ATTRIBUTES_TL041337_WHO
PUBLIC
SYNONYM - PQH_ATTRIBUTES_TL

[top of page]

Table: PQH_ATTRIBUTE_RANGES

Description: PQH_ATTRIBUTE_RANGES stores routing / authorization rules for transaction categories.
Primary Key: PQH_ATTRIBUTE_RANGES_PK
  1. ATTRIBUTE_RANGE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_ATTRIBUTE_RANGES.ATTRIBUTE_ID PQH_ATTRIBUTES
PQH_ATTRIBUTE_RANGES.ROUTING_LIST_MEMBER_ID PQH_ROUTING_LIST_MEMBERS
PQH_ATTRIBUTE_RANGES.ROUTING_CATEGORY_ID PQH_ROUTING_CATEGORIES

[top of page]

HR.PQH_ATTRIBUTE_RANGES does not reference any database object

HR.PQH_ATTRIBUTE_RANGES is referenced by following:

APPS
SYNONYM - PQH_ATTRIBUTE_RANGES
TRIGGER - PQH_ATTRIBUTE_RANGES_WHO
PUBLIC
SYNONYM - PQH_ATTRIBUTE_RANGES

[top of page]

Table: PQH_BDGT_CMMTMNT_ELMNTS

Description: Elements for computing commitments for a budget
Primary Key: PQH_BDGT_CMMTMNT_ELMNTS_PK
  1. BDGT_CMMTMNT_ELMNT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_BDGT_CMMTMNT_ELMNTS.DFLT_ELMNT_FREQUENCY PER_TIME_PERIOD_TYPES

[top of page]

HR.PQH_BDGT_CMMTMNT_ELMNTS does not reference any database object

HR.PQH_BDGT_CMMTMNT_ELMNTS is referenced by following:

APPS
SYNONYM - PQH_BDGT_CMMTMNT_ELMNTS
TRIGGER - PQH_BDGT_CMMTMNT_ELMNTS_WHO
PUBLIC
SYNONYM - PQH_BDGT_CMMTMNT_ELMNTS

[top of page]

Table: PQH_BDGT_POOL_REALLOCTIONS

Description: Resource reallocation information for position
Primary Key: PQH_BDGT_POOL_REALLOCTIONS
  1. REALLOCATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_BDGT_POOL_REALLOCTIONS.POOL_ID PQH_BUDGET_POOLS

[top of page]

HR.PQH_BDGT_POOL_REALLOCTIONS does not reference any database object

HR.PQH_BDGT_POOL_REALLOCTIONS is referenced by following:

APPS
SYNONYM - PQH_BDGT_POOL_REALLOCTIONS
TRIGGER - PQH_BDGT_POOL_REALLOCTIONS_WHO

[top of page]

Table: PQH_BDGT_POOL_REALLOCTIONS_EFC

Description: This is a Copy of PQH_BDGT_POOL_REALLOCATIONS table populated by EFC (Euro as functinoal currency) process.
Primary Key: PQH_BDGT_POOL_REALLOCT_EFC_PK
  1. REALLOCATION_ID
  2. EFC_ACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_BDGT_POOL_REALLOCTIONS_EFC.EFC_ACTION_ID HR_EFC_ACTIONS

[top of page]

HR.PQH_BDGT_POOL_REALLOCTIONS_EFC does not reference any database object

HR.PQH_BDGT_POOL_REALLOCTIONS_EFC is referenced by following:

APPS
SYNONYM - PQH_BDGT_POOL_REALLOCTIONS_EFC

[top of page]

Table: PQH_BUDGETS

Description: Stores information on budgets
Primary Key: PQH_BUDGETS_PK
  1. BUDGET_ID
Primary Key: PQH_BUDGETS_UK
  1. BUDGET_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_BUDGETS.PERIOD_SET_NAME PAY_CALENDARS
PQH_BUDGETS.BUDGET_UNIT1_ID PER_SHARED_TYPES
PQH_BUDGETS.BUDGET_UNIT2_ID PER_SHARED_TYPES
PQH_BUDGETS.BUDGET_UNIT3_ID PER_SHARED_TYPES
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_BUDGET_VERSIONS.BUDGET_ID PQH_BUDGETS
PQH_WORKSHEETS.BUDGET_ID PQH_BUDGETS

[top of page]

HR.PQH_BUDGETS does not reference any database object

HR.PQH_BUDGETS is referenced by following:

APPS
SYNONYM - PQH_BUDGETS
TRIGGER - PQH_BUDGETS_WHO
PUBLIC
SYNONYM - PQH_BUDGETS

[top of page]

Table: PQH_BUDGETS_EFC

Description: This is a Copy of PQH_BUDGETS table populated by EFC (Euro as functinoal currency) process.
Primary Key: PQH_BUDGETS_EFC_PK
  1. BUDGET_ID
  2. EFC_ACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_BUDGETS_EFC.EFC_ACTION_ID HR_EFC_ACTIONS

[top of page]

HR.PQH_BUDGETS_EFC does not reference any database object

HR.PQH_BUDGETS_EFC is referenced by following:

APPS
SYNONYM - PQH_BUDGETS_EFC
PUBLIC
SYNONYM - PQH_BUDGETS_EFC

[top of page]

Table: PQH_BUDGET_DETAILS

Description: Budget Details for hr entities
Primary Key: PQH_BUDGET_DETAILS_PK
  1. BUDGET_DETAIL_ID
Primary Key: PQH_BUDGET_DETAILS_UK
  1. BUDGET_VERSION_ID
  2. GRADE_ID
  3. JOB_ID
  4. ORGANIZATION_ID
  5. POSITION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_BUDGET_DETAILS.ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
PQH_BUDGET_DETAILS.BUDGET_VERSION_ID PQH_BUDGET_VERSIONS
PQH_BUDGET_DETAILS.JOB_ID PER_JOBS
PQH_BUDGET_DETAILS.GRADE_ID PER_GRADES
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_BUDGET_PERIODS.BUDGET_DETAIL_ID PQH_BUDGET_DETAILS
PQH_WORKSHEET_DETAILS.BUDGET_DETAIL_ID PQH_BUDGET_DETAILS

[top of page]

HR.PQH_BUDGET_DETAILS does not reference any database object

HR.PQH_BUDGET_DETAILS is referenced by following:

APPS
SYNONYM - PQH_BUDGET_DETAILS
TRIGGER - PQH_BUDGET_DETAILS_WHO
PUBLIC
SYNONYM - PQH_BUDGET_DETAILS

[top of page]

Table: PQH_BUDGET_DETAILS_EFC

Description: This is a Copy of PQH_BUDGET_DETAILS table populated by EFC (Euro as functinoal currency) process.
Primary Key: PQH_BUDGET_DETAILS_EFC_PK
  1. BUDGET_DETAIL_ID
  2. EFC_ACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_BUDGET_DETAILS_EFC.EFC_ACTION_ID HR_EFC_ACTIONS

[top of page]

HR.PQH_BUDGET_DETAILS_EFC does not reference any database object

HR.PQH_BUDGET_DETAILS_EFC is referenced by following:

APPS
SYNONYM - PQH_BUDGET_DETAILS_EFC
PUBLIC
SYNONYM - PQH_BUDGET_DETAILS_EFC

[top of page]

Table: PQH_BUDGET_ELEMENTS

Description: Element wise distribution of budget
Primary Key: PQH_BUDGET_ELEMENTS_PK
  1. BUDGET_ELEMENT_ID
Primary Key: PQH_BUDGET_ELEMENTS_UK
  1. BUDGET_SET_ID
  2. ELEMENT_TYPE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_BUDGET_ELEMENTS.BUDGET_SET_ID PQH_BUDGET_SETS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_BUDGET_FUND_SRCS.BUDGET_ELEMENT_ID PQH_BUDGET_ELEMENTS

[top of page]

HR.PQH_BUDGET_ELEMENTS does not reference any database object

HR.PQH_BUDGET_ELEMENTS is referenced by following:

APPS
SYNONYM - PQH_BUDGET_ELEMENTS
TRIGGER - PQH_BUDGET_ELEMENTS_WHO
PUBLIC
SYNONYM - PQH_BUDGET_ELEMENTS

[top of page]

Table: PQH_BUDGET_FUND_SRCS

Description: Budget Cost Allocation information
Primary Key: PQH_BUDGET_FUND_SRCS_PK
  1. BUDGET_FUND_SRC_ID
Primary Key: PQH_BUDGET_FUND_SRCS_UK
  1. BUDGET_ELEMENT_ID
  2. COST_ALLOCATION_KEYFLEX_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_BUDGET_FUND_SRCS.BUDGET_ELEMENT_ID PQH_BUDGET_ELEMENTS
PQH_BUDGET_FUND_SRCS.COST_ALLOCATION_KEYFLEX_ID PAY_COST_ALLOCATION_KEYFLEX

[top of page]

HR.PQH_BUDGET_FUND_SRCS does not reference any database object

HR.PQH_BUDGET_FUND_SRCS is referenced by following:

APPS
SYNONYM - PQH_BUDGET_FUND_SRCS
TRIGGER - PQH_BUDGET_FUND_SRCS_WHO
PUBLIC
SYNONYM - PQH_BUDGET_FUND_SRCS

[top of page]

Table: PQH_BUDGET_GL_FLEX_MAPS

Description: Mapping Cost allocation with GL code combinations
Primary Key: PQH_BUDGET_GL_FLEX_MAPS_PK
  1. BUDGET_GL_FLEX_MAP_ID

[top of page]

HR.PQH_BUDGET_GL_FLEX_MAPS does not reference any database object

HR.PQH_BUDGET_GL_FLEX_MAPS is referenced by following:

APPS
SYNONYM - PQH_BUDGET_GL_FLEX_MAPS
TRIGGER - PQH_BUDGET_GL_FLEX_MAPS_WHO
PUBLIC
SYNONYM - PQH_BUDGET_GL_FLEX_MAPS

[top of page]

Table: PQH_BUDGET_PERIODS

Description: Period details for budget
Primary Key: PQH_BUDGET_PERIODS_PK
  1. BUDGET_PERIOD_ID
Primary Key: PQH_BUDGET_PERIODS_UK
  1. BUDGET_DETAIL_ID
  2. END_TIME_PERIOD_ID
  3. START_TIME_PERIOD_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_BUDGET_PERIODS.BUDGET_DETAIL_ID PQH_BUDGET_DETAILS
PQH_BUDGET_PERIODS.START_TIME_PERIOD_ID PER_TIME_PERIODS
PQH_BUDGET_PERIODS.END_TIME_PERIOD_ID PER_TIME_PERIODS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_BUDGET_SETS.BUDGET_PERIOD_ID PQH_BUDGET_PERIODS

[top of page]

HR.PQH_BUDGET_PERIODS does not reference any database object

HR.PQH_BUDGET_PERIODS is referenced by following:

APPS
SYNONYM - PQH_BUDGET_PERIODS
TRIGGER - PQH_BUDGET_PERIODS_WHO
PUBLIC
SYNONYM - PQH_BUDGET_PERIODS

[top of page]

Table: PQH_BUDGET_PERIODS_EFC

Description: This is a Copy of PQH_BUDGET_PERIODS table populated by EFC (Euro as functinoal currency) process.
Primary Key: PQH_BUDGET_PERIODS_EFC_PK
  1. BUDGET_PERIOD_ID
  2. EFC_ACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_BUDGET_PERIODS_EFC.EFC_ACTION_ID HR_EFC_ACTIONS

[top of page]

HR.PQH_BUDGET_PERIODS_EFC does not reference any database object

HR.PQH_BUDGET_PERIODS_EFC is referenced by following:

APPS
SYNONYM - PQH_BUDGET_PERIODS_EFC
PUBLIC
SYNONYM - PQH_BUDGET_PERIODS_EFC

[top of page]

Table: PQH_BUDGET_POOLS

Description: Reallocation pool for a budget version and for a specific budget mesurement unit
Primary Key: PQH_BUDGET_POOLS_PK
  1. POOL_ID
Primary Key: PQH_BUDGET_POOLS_UK1
  1. BUDGET_UNIT_ID
  2. BUDGET_VERSION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_BUDGET_POOLS.BUDGET_VERSION_ID PQH_BUDGET_VERSIONS
PQH_BUDGET_POOLS.BUDGET_UNIT_ID PER_SHARED_TYPES
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_BDGT_POOL_REALLOCTIONS.POOL_ID PQH_BUDGET_POOLS

[top of page]

HR.PQH_BUDGET_POOLS does not reference any database object

HR.PQH_BUDGET_POOLS is referenced by following:

APPS
SYNONYM - PQH_BUDGET_POOLS
TRIGGER - PQH_BUDGET_POOLS_WHO
PUBLIC
SYNONYM - PQH_BUDGET_POOLS

[top of page]

Table: PQH_BUDGET_SETS

Description: Grouping of elements with default distribution
Primary Key: PQH_BUDGET_SETS_PK
  1. BUDGET_SET_ID
Primary Key: PQH_BUDGET_SETS_UK
  1. DFLT_BUDGET_SET_ID
  2. BUDGET_PERIOD_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_BUDGET_SETS.DFLT_BUDGET_SET_ID PQH_DFLT_BUDGET_SETS
PQH_BUDGET_SETS.BUDGET_PERIOD_ID PQH_BUDGET_PERIODS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_BUDGET_ELEMENTS.BUDGET_SET_ID PQH_BUDGET_SETS

[top of page]

HR.PQH_BUDGET_SETS does not reference any database object

HR.PQH_BUDGET_SETS is referenced by following:

APPS
SYNONYM - PQH_BUDGET_SETS
TRIGGER - PQH_BUDGET_SETS_WHO
PUBLIC
SYNONYM - PQH_BUDGET_SETS

[top of page]

Table: PQH_BUDGET_SETS_EFC

Description: This is a Copy of PQH_BUDGET_SETS table populated by EFC (Euro as functinoal currency) process.
Primary Key: PQH_BUDGET_SETS_EFC_PK
  1. BUDGET_SET_ID

[top of page]

HR.PQH_BUDGET_SETS_EFC does not reference any database object

HR.PQH_BUDGET_SETS_EFC is referenced by following:

APPS
SYNONYM - PQH_BUDGET_SETS_EFC
PUBLIC
SYNONYM - PQH_BUDGET_SETS_EFC

[top of page]

Table: PQH_BUDGET_VERSIONS

Description: Budget for a date range
Primary Key: PQH_BUDGET_VERSIONS_PK
  1. BUDGET_VERSION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_BUDGET_VERSIONS.BUDGET_ID PQH_BUDGETS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_BUDGET_DETAILS.BUDGET_VERSION_ID PQH_BUDGET_VERSIONS
PQH_BUDGET_POOLS.BUDGET_VERSION_ID PQH_BUDGET_VERSIONS
PQH_ELEMENT_COMMITMENTS.BUDGET_VERSION_ID PQH_BUDGET_VERSIONS
PQH_WORKSHEETS.BUDGET_VERSION_ID PQH_BUDGET_VERSIONS

[top of page]

HR.PQH_BUDGET_VERSIONS does not reference any database object

HR.PQH_BUDGET_VERSIONS is referenced by following:

APPS
SYNONYM - PQH_BUDGET_VERSIONS
TRIGGER - PQH_BUDGET_VERSIONS_WHO
PUBLIC
SYNONYM - PQH_BUDGET_VERSIONS

[top of page]

Table: PQH_BUDGET_VERSIONS_EFC

Description: This is a Copy of PQH_BUDGET_VERSIONS table populated by EFC (Euro as functinoal currency) process.
Primary Key: PQH_BUDGET_VERSIONS_EFC_PK
  1. BUDGET_VERSION_ID
  2. EFC_ACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_BUDGET_VERSIONS_EFC.EFC_ACTION_ID HR_EFC_ACTIONS

[top of page]

HR.PQH_BUDGET_VERSIONS_EFC does not reference any database object

HR.PQH_BUDGET_VERSIONS_EFC is referenced by following:

APPS
SYNONYM - PQH_BUDGET_VERSIONS_EFC
PUBLIC
SYNONYM - PQH_BUDGET_VERSIONS_EFC

[top of page]

Table: PQH_COPY_ENTITY_ATTRIBS

Description: Criteria and Change list for mass process functionality is stored
Primary Key: PQH_COPY_ENTITY_ATTRIBS_PK
  1. COPY_ENTITY_ATTRIB_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_COPY_ENTITY_ATTRIBS.COPY_ENTITY_TXN_ID PQH_COPY_ENTITY_TXNS

[top of page]

HR.PQH_COPY_ENTITY_ATTRIBS does not reference any database object

HR.PQH_COPY_ENTITY_ATTRIBS is referenced by following:

APPS
SYNONYM - PQH_COPY_ENTITY_ATTRIBS
TRIGGER - PQH_COPY_ENTITY_ATTRIBS_WHO
PUBLIC
SYNONYM - PQH_COPY_ENTITY_ATTRIBS

[top of page]

Table: PQH_COPY_ENTITY_CONTEXTS

Description: Adjusting Display/criteria/change to Application/Legislation/Responsibility
Primary Key: PQH_COPY_ENTITY_CONTEXTS_PK
  1. CONTEXT
Primary Key: PQH_COPY_ENTITY_CONTEXTS_UK
  1. APPLICATION_SHORT_NAME
  2. LEGISLATION_CODE
  3. RESPONSIBILITY_KEY
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_COPY_ENTITY_FUNCTIONS.CONTEXT PQH_COPY_ENTITY_CONTEXTS
PQH_COPY_ENTITY_TXNS.CONTEXT PQH_COPY_ENTITY_CONTEXTS
PQH_SPECIAL_ATTRIBUTES.CONTEXT PQH_COPY_ENTITY_CONTEXTS

[top of page]

HR.PQH_COPY_ENTITY_CONTEXTS does not reference any database object

HR.PQH_COPY_ENTITY_CONTEXTS is referenced by following:

APPS
SYNONYM - PQH_COPY_ENTITY_CONTEXTS
TRIGGER - PQH_COPY_ENTITY_CONTEXTS_WHO
PUBLIC
SYNONYM - PQH_COPY_ENTITY_CONTEXTS

[top of page]

Table: PQH_COPY_ENTITY_FUNCTIONS

Description: For a context Pre / Post and event functions for table is listed
Primary Key: PQH_COPY_ENTITY_FUNCTIONS_PK
  1. COPY_ENTITY_FUNCTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_COPY_ENTITY_FUNCTIONS.TABLE_ROUTE_ID PQH_TABLE_ROUTE
PQH_COPY_ENTITY_FUNCTIONS.CONTEXT PQH_COPY_ENTITY_CONTEXTS

[top of page]

HR.PQH_COPY_ENTITY_FUNCTIONS does not reference any database object

HR.PQH_COPY_ENTITY_FUNCTIONS is referenced by following:

APPS
SYNONYM - PQH_COPY_ENTITY_FUNCTIONS
TRIGGER - PQH_COPY_ENTITY_FUNCTIONS_WHO
PUBLIC
SYNONYM - PQH_COPY_ENTITY_FUNCTIONS

[top of page]

Table: PQH_COPY_ENTITY_PREFS

Description: User preference of including dependent entity associated with the transaction
Primary Key: PQH_COPY_ENTITY_PREFS_PK
  1. COPY_ENTITY_PREF_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_COPY_ENTITY_PREFS.COPY_ENTITY_TXN_ID PQH_COPY_ENTITY_TXNS
PQH_COPY_ENTITY_PREFS.TABLE_ROUTE_ID PQH_TABLE_ROUTE

[top of page]

HR.PQH_COPY_ENTITY_PREFS does not reference any database object

HR.PQH_COPY_ENTITY_PREFS is referenced by following:

APPS
SYNONYM - PQH_COPY_ENTITY_PREFS
TRIGGER - PQH_COPY_ENTITY_PREFS_WHO
PUBLIC
SYNONYM - PQH_COPY_ENTITY_PREFS

[top of page]

Table: PQH_COPY_ENTITY_RESULTS

Description: Transaction entity which holds process data
Primary Key: PQH_COPY_ENTITY_RESULTS_PK
  1. COPY_ENTITY_RESULT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_COPY_ENTITY_RESULTS.COPY_ENTITY_TXN_ID PQH_COPY_ENTITY_TXNS
PQH_COPY_ENTITY_RESULTS.SRC_COPY_ENTITY_RESULT_ID PQH_COPY_ENTITY_RESULTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_COPY_ENTITY_RESULTS.SRC_COPY_ENTITY_RESULT_ID PQH_COPY_ENTITY_RESULTS

[top of page]

HR.PQH_COPY_ENTITY_RESULTS does not reference any database object

HR.PQH_COPY_ENTITY_RESULTS is referenced by following:

APPS
SYNONYM - PQH_COPY_ENTITY_RESULTS
TRIGGER - PQH_COPY_ENTITY_RESULTS_WHO
PUBLIC
SYNONYM - PQH_COPY_ENTITY_RESULTS

[top of page]

Table: PQH_COPY_ENTITY_TXNS

Description: Batch details for Mass Processes
Primary Key: PQH_COPY_ENTITY_TXNS_PK
  1. COPY_ENTITY_TXN_ID
Primary Key: PQH_COPY_ENTITY_TXNS_UK
  1. TRANSACTION_CATEGORY_ID
  2. CONTEXT_BUSINESS_GROUP_ID
  3. DISPLAY_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_COPY_ENTITY_TXNS.TRANSACTION_CATEGORY_ID PQH_TRANSACTION_CATEGORIES
PQH_COPY_ENTITY_TXNS.TXN_CATEGORY_ATTRIBUTE_ID PQH_TXN_CATEGORY_ATTRIBUTES
PQH_COPY_ENTITY_TXNS.CONTEXT PQH_COPY_ENTITY_CONTEXTS
PQH_COPY_ENTITY_TXNS.CONTEXT_BUSINESS_GROUP_ID HR_ALL_ORGANIZATION_UNITS
PQH_COPY_ENTITY_TXNS.WF_TRANSACTION_CATEGORY_ID PQH_TRANSACTION_CATEGORIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_COPY_ENTITY_ATTRIBS.COPY_ENTITY_TXN_ID PQH_COPY_ENTITY_TXNS
PQH_COPY_ENTITY_PREFS.COPY_ENTITY_TXN_ID PQH_COPY_ENTITY_TXNS
PQH_COPY_ENTITY_RESULTS.COPY_ENTITY_TXN_ID PQH_COPY_ENTITY_TXNS

[top of page]

HR.PQH_COPY_ENTITY_TXNS does not reference any database object

HR.PQH_COPY_ENTITY_TXNS is referenced by following:

APPS
SYNONYM - PQH_COPY_ENTITY_TXNS
TRIGGER - PQH_COPY_ENTITY_TXNS_WHO
PUBLIC
SYNONYM - PQH_COPY_ENTITY_TXNS

[top of page]

Table: PQH_CORPS_DEFINITIONS

Description: Corp Definition
Primary Key: PQH_CORPS_DEFINITION_PK
  1. CORPS_DEFINITION_ID

[top of page]

HR.PQH_CORPS_DEFINITIONS does not reference any database object

HR.PQH_CORPS_DEFINITIONS is referenced by following:

APPS
SYNONYM - PQH_CORPS_DEFINITIONS
TRIGGER - PQH_CORPS_DEFINITIONS_WHO
PUBLIC
SYNONYM - PQH_CORPS_DEFINITIONS

[top of page]

Table: PQH_CORPS_EXTRA_INFO

Description: Corp Extra Information details
Primary Key: PQH_CORPS_EXTRA_INFO_PK
  1. CORPS_EXTRA_INFO_ID

[top of page]

HR.PQH_CORPS_EXTRA_INFO does not reference any database object

HR.PQH_CORPS_EXTRA_INFO is referenced by following:

APPS
SYNONYM - PQH_CORPS_EXTRA_INFO
TRIGGER - PQH_CORPS_EXTRA_INFO_WHO
PUBLIC
SYNONYM - PQH_CORPS_EXTRA_INFO

[top of page]

Table: PQH_CORPS_INFO_TYPES

Description: Corp Extra Information Types

[top of page]

HR.PQH_CORPS_INFO_TYPES does not reference any database object

HR.PQH_CORPS_INFO_TYPES is referenced by following:

APPS
SYNONYM - PQH_CORPS_INFO_TYPES
TRIGGER - PQH_CORPS_INFO_TYPES_WHO
PUBLIC
SYNONYM - PQH_CORPS_INFO_TYPES

[top of page]

Table: PQH_CRITERIA_RATE_DEFN

Description: Table to store different criteria rate definitions.
Primary Key: PQH_CRITERIA_RATE_DEFN_PK
  1. CRITERIA_RATE_DEFN_ID
Primary Key: PQH_CRITERIA_RATE_DEFN_UK1
  1. SHORT_NAME
  2. BUSINESS_GROUP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_CRITERIA_RATE_DEFN.BUSINESS_GROUP_ID HR_ALL_ORGANIZATION_UNITS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_CRITERIA_RATE_ELEMENTS.CRITERIA_RATE_DEFN_ID PQH_CRITERIA_RATE_DEFN
PQH_CRITERIA_RATE_FACTORS.CRITERIA_RATE_DEFN_ID PQH_CRITERIA_RATE_DEFN
PQH_CRITERIA_RATE_FACTORS.PARENT_CRITERIA_RATE_DEFN_ID PQH_CRITERIA_RATE_DEFN
PQH_RATE_MATRIX_RATES_F.CRITERIA_RATE_DEFN_ID PQH_CRITERIA_RATE_DEFN

[top of page]

HR.PQH_CRITERIA_RATE_DEFN does not reference any database object

HR.PQH_CRITERIA_RATE_DEFN is referenced by following:

APPS
SYNONYM - PQH_CRITERIA_RATE_DEFN
TRIGGER - PQH_CRITERIA_RATE_DEFN_WHO
PUBLIC
SYNONYM - PQH_CRITERIA_RATE_DEFN

[top of page]

Table: PQH_CRITERIA_RATE_DEFN_TL

Description: Table to store translatable information for a criteria rate definition.
Primary Key: PQH_CRITERIA_RT_DEFN_TL_PK
  1. CRITERIA_RATE_DEFN_ID
  2. LANGUAGE

[top of page]

HR.PQH_CRITERIA_RATE_DEFN_TL does not reference any database object

HR.PQH_CRITERIA_RATE_DEFN_TL is referenced by following:

APPS
TRIGGER - PQH_CRITERIA_RATE_DE041317_WHO
SYNONYM - PQH_CRITERIA_RATE_DEFN_TL
PUBLIC
SYNONYM - PQH_CRITERIA_RATE_DEFN_TL

[top of page]

Table: PQH_CRITERIA_RATE_ELEMENTS

Description: Define elements that take their rate value from a criteria rate definition.
Primary Key: PQH_CRITERIA_RATE_ELEMENTS_PK
  1. CRITERIA_RATE_ELEMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_CRITERIA_RATE_ELEMENTS.CRITERIA_RATE_DEFN_ID PQH_CRITERIA_RATE_DEFN
PQH_CRITERIA_RATE_ELEMENTS.BUSINESS_GROUP_ID HR_ALL_ORGANIZATION_UNITS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_RATE_ELEMENT_RELATIONS.CRITERIA_RATE_ELEMENT_ID PQH_CRITERIA_RATE_ELEMENTS

[top of page]

HR.PQH_CRITERIA_RATE_ELEMENTS does not reference any database object

HR.PQH_CRITERIA_RATE_ELEMENTS is referenced by following:

APPS
SYNONYM - PQH_CRITERIA_RATE_ELEMENTS
TRIGGER - PQH_CRITERIA_RATE_ELEMENTS_WHO
PUBLIC
SYNONYM - PQH_CRITERIA_RATE_ELEMENTS

[top of page]

Table: PQH_CRITERIA_RATE_FACTORS

Description: This is a child table of pqh_criteria_rate_defn table. Values will exist in this table if the rate_calculation_method of a criteria rate defn is ADD_TO/ PERCENT / SUM.
Primary Key: PQH_CRITERIA_RATE_FACTORS_PK
  1. CRITERIA_RATE_FACTOR_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_CRITERIA_RATE_FACTORS.CRITERIA_RATE_DEFN_ID PQH_CRITERIA_RATE_DEFN
PQH_CRITERIA_RATE_FACTORS.PARENT_CRITERIA_RATE_DEFN_ID PQH_CRITERIA_RATE_DEFN
PQH_CRITERIA_RATE_FACTORS.BUSINESS_GROUP_ID HR_ALL_ORGANIZATION_UNITS

[top of page]

HR.PQH_CRITERIA_RATE_FACTORS does not reference any database object

HR.PQH_CRITERIA_RATE_FACTORS is referenced by following:

APPS
SYNONYM - PQH_CRITERIA_RATE_FACTORS
TRIGGER - PQH_CRITERIA_RATE_FACTORS_WHO
PUBLIC
SYNONYM - PQH_CRITERIA_RATE_FACTORS

[top of page]

Table: PQH_DE_CASE_GROUPS

Description: De - Case Groups
Primary Key: PQH_DE_CASE_GROUPS_PK
  1. CASE_GROUP_ID

[top of page]

HR.PQH_DE_CASE_GROUPS does not reference any database object

HR.PQH_DE_CASE_GROUPS is referenced by following:

APPS
SYNONYM - PQH_DE_CASE_GROUPS
TRIGGER - PQH_DE_CASE_GROUPS_WHO
PUBLIC
SYNONYM - PQH_DE_CASE_GROUPS

[top of page]

Table: PQH_DE_INS_END_REASONS

Description:
Primary Key: PQH_DE_INS_END_REASONS_PK
  1. INS_END_REASON_ID

[top of page]

HR.PQH_DE_INS_END_REASONS does not reference any database object

HR.PQH_DE_INS_END_REASONS is referenced by following:

APPS
SYNONYM - PQH_DE_INS_END_REASONS
TRIGGER - PQH_DE_INS_END_REASONS_WHO
PUBLIC
SYNONYM - PQH_DE_INS_END_REASONS

[top of page]

Table: PQH_DE_LEVEL_CODES

Description: DE - Level Codes
Primary Key: PQH_DE_LEVEL_CODES_PK
  1. LEVEL_CODE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_DE_LEVEL_CODES.LEVEL_NUMBER_ID %

[top of page]

HR.PQH_DE_LEVEL_CODES does not reference any database object

HR.PQH_DE_LEVEL_CODES is referenced by following:

APPS
SYNONYM - PQH_DE_LEVEL_CODES
TRIGGER - PQH_DE_LEVEL_CODES_WHO
PUBLIC
SYNONYM - PQH_DE_LEVEL_CODES

[top of page]

Table: PQH_DE_LEVEL_NUMBERS

Description: DE - Level Numbers
Primary Key: PQH_DE_LEVEL_NUMBERS_PK
  1. LEVEL_NUMBER_ID

[top of page]

HR.PQH_DE_LEVEL_NUMBERS does not reference any database object

HR.PQH_DE_LEVEL_NUMBERS is referenced by following:

APPS
SYNONYM - PQH_DE_LEVEL_NUMBERS
TRIGGER - PQH_DE_LEVEL_NUMBERS_WHO
PUBLIC
SYNONYM - PQH_DE_LEVEL_NUMBERS

[top of page]

Table: PQH_DE_OPERATIONS

Description: DE - Operations
Primary Key: PQH_DE_OPERATIONS_PK
  1. OPERATION_ID

[top of page]

HR.PQH_DE_OPERATIONS does not reference any database object

HR.PQH_DE_OPERATIONS is referenced by following:

APPS
SYNONYM - PQH_DE_OPERATIONS
TRIGGER - PQH_DE_OPERATIONS_WHO
PUBLIC
SYNONYM - PQH_DE_OPERATIONS

[top of page]

Table: PQH_DE_RESULT_SETS

Description: DE - Result Sets
Primary Key: PQH_DE_RESULT_SETS_PK
  1. RESULT_SET_ID

[top of page]

HR.PQH_DE_RESULT_SETS does not reference any database object

HR.PQH_DE_RESULT_SETS is referenced by following:

APPS
SYNONYM - PQH_DE_RESULT_SETS
TRIGGER - PQH_DE_RESULT_SETS_WHO
PUBLIC
SYNONYM - PQH_DE_RESULT_SETS

[top of page]

Table: PQH_DE_TATIGKEIT_DETAILS

Description: DE - Tatigkeit Details
Primary Key: PQH_DE_TATIGKEIT_DETAILS_PK
  1. TATIGKEIT_DETAIL_ID

[top of page]

HR.PQH_DE_TATIGKEIT_DETAILS does not reference any database object

HR.PQH_DE_TATIGKEIT_DETAILS is referenced by following:

APPS
SYNONYM - PQH_DE_TATIGKEIT_DETAILS
TRIGGER - PQH_DE_TATIGKEIT_DETAILS_WHO
PUBLIC
SYNONYM - PQH_DE_TATIGKEIT_DETAILS

[top of page]

Table: PQH_DE_WRKPLC_VLDTNS

Description: DE - Workplace Validations
Primary Key: PQH_DE_WRKPLC_VLDTNS_PK
  1. WRKPLC_VLDTN_ID

[top of page]

HR.PQH_DE_WRKPLC_VLDTNS does not reference any database object

HR.PQH_DE_WRKPLC_VLDTNS is referenced by following:

APPS
SYNONYM - PQH_DE_WRKPLC_VLDTNS
TRIGGER - PQH_DE_WRKPLC_VLDTNS_WHO
PUBLIC
SYNONYM - PQH_DE_WRKPLC_VLDTNS

[top of page]

Table: PQH_DE_WRKPLC_VLDTN_JOBFTRS

Description: DE - Workplace Validation jobfeatures
Primary Key: PQH_DE_WRKPLC_VLDTN_JOBFTRS_PK
  1. WRKPLC_VLDTN_JOBFTR_ID

[top of page]

HR.PQH_DE_WRKPLC_VLDTN_JOBFTRS does not reference any database object

HR.PQH_DE_WRKPLC_VLDTN_JOBFTRS is referenced by following:

APPS
SYNONYM - PQH_DE_WRKPLC_VLDTN_JOBFTRS
TRIGGER - PQH_DE_WRKPLC_VLDTN_JOBFTR_WHO
PUBLIC
SYNONYM - PQH_DE_WRKPLC_VLDTN_JOBFTRS

[top of page]

Table: PQH_DE_WRKPLC_VLDTN_JOBS

Description: DE - Workplace Validation jobdetails
Primary Key: PQH_DE_WRKPLC_VLDTN_JOBS_PK
  1. WRKPLC_VLDTN_JOB_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_DE_WRKPLC_VLDTN_JOBS.WRKPLC_VLDTN_OP_ID PQH_DE_WRKPLC_VLDTN_OPS

[top of page]

HR.PQH_DE_WRKPLC_VLDTN_JOBS does not reference any database object

HR.PQH_DE_WRKPLC_VLDTN_JOBS is referenced by following:

APPS
SYNONYM - PQH_DE_WRKPLC_VLDTN_JOBS
TRIGGER - PQH_DE_WRKPLC_VLDTN_JOBS_WHO
PUBLIC
SYNONYM - PQH_DE_WRKPLC_VLDTN_JOBS

[top of page]

Table: PQH_DE_WRKPLC_VLDTN_LVLNUMS

Description: DE - Workplace Validation Level Numbers
Primary Key: PQH_DE_WRKPLC_VLDTN_LVLNUMS_PK
  1. WRKPLC_VLDTN_LVLNUM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_DE_WRKPLC_VLDTN_LVLNUMS.WRKPLC_VLDTN_VER_ID PQH_DE_WRKPLC_VLDTN_VERS

[top of page]

HR.PQH_DE_WRKPLC_VLDTN_LVLNUMS does not reference any database object

HR.PQH_DE_WRKPLC_VLDTN_LVLNUMS is referenced by following:

APPS
SYNONYM - PQH_DE_WRKPLC_VLDTN_LVLNUMS
TRIGGER - PQH_DE_WRKPLC_VLDTN_LVLNUM_WHO
PUBLIC
SYNONYM - PQH_DE_WRKPLC_VLDTN_LVLNUMS

[top of page]

Table: PQH_DE_WRKPLC_VLDTN_OPS

Description: DE - Workplace Validation operations
Primary Key: PQH_DE_WRKPLC_VLDTN_OPS_PK
  1. WRKPLC_VLDTN_OP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_DE_WRKPLC_VLDTN_OPS.WRKPLC_VLDTN_VER_ID PQH_DE_WRKPLC_VLDTN_VERS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_DE_WRKPLC_VLDTN_JOBS.WRKPLC_VLDTN_OP_ID PQH_DE_WRKPLC_VLDTN_OPS

[top of page]

HR.PQH_DE_WRKPLC_VLDTN_OPS does not reference any database object

HR.PQH_DE_WRKPLC_VLDTN_OPS is referenced by following:

APPS
SYNONYM - PQH_DE_WRKPLC_VLDTN_OPS
TRIGGER - PQH_DE_WRKPLC_VLDTN_OPS_WHO
PUBLIC
SYNONYM - PQH_DE_WRKPLC_VLDTN_OPS

[top of page]

Table: PQH_DE_WRKPLC_VLDTN_VERS

Description: DE - Workplace Validation Versions
Primary Key: PQH_DE_WRKPLC_VLDTN_VERS_PK
  1. WRKPLC_VLDTN_VER_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_DE_WRKPLC_VLDTN_LVLNUMS.WRKPLC_VLDTN_VER_ID PQH_DE_WRKPLC_VLDTN_VERS
PQH_DE_WRKPLC_VLDTN_OPS.WRKPLC_VLDTN_VER_ID PQH_DE_WRKPLC_VLDTN_VERS

[top of page]

HR.PQH_DE_WRKPLC_VLDTN_VERS does not reference any database object

HR.PQH_DE_WRKPLC_VLDTN_VERS is referenced by following:

APPS
SYNONYM - PQH_DE_WRKPLC_VLDTN_VERS
TRIGGER - PQH_DE_WRKPLC_VLDTN_VERS_WHO
PUBLIC
SYNONYM - PQH_DE_WRKPLC_VLDTN_VERS

[top of page]

Table: PQH_DFLT_BUDGET_ELEMENTS

Description: Budget elements for the budget set
Primary Key: PQH_DFLT_BUDGET_ELEMENTS_PK
  1. DFLT_BUDGET_ELEMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_DFLT_BUDGET_ELEMENTS.DFLT_BUDGET_SET_ID PQH_DFLT_BUDGET_SETS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_DFLT_FUND_SRCS.DFLT_BUDGET_ELEMENT_ID PQH_DFLT_BUDGET_ELEMENTS

[top of page]

HR.PQH_DFLT_BUDGET_ELEMENTS does not reference any database object

HR.PQH_DFLT_BUDGET_ELEMENTS is referenced by following:

APPS
SYNONYM - PQH_DFLT_BUDGET_ELEMENTS
TRIGGER - PQH_DFLT_BUDGET_ELEMENTS_WHO
PUBLIC
SYNONYM - PQH_DFLT_BUDGET_ELEMENTS

[top of page]

Table: PQH_DFLT_BUDGET_SETS

Description: Grouping of elements and funding sources
Primary Key: PQH_DFLT_BUDGET_SETS_PK
  1. DFLT_BUDGET_SET_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_DFLT_BUDGET_SETS.BUSINESS_GROUP_ID HR_ALL_ORGANIZATION_UNITS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_BUDGET_SETS.DFLT_BUDGET_SET_ID PQH_DFLT_BUDGET_SETS
PQH_DFLT_BUDGET_ELEMENTS.DFLT_BUDGET_SET_ID PQH_DFLT_BUDGET_SETS
PQH_WORKSHEET_BUDGET_SETS.DFLT_BUDGET_SET_ID PQH_DFLT_BUDGET_SETS

[top of page]

HR.PQH_DFLT_BUDGET_SETS does not reference any database object

HR.PQH_DFLT_BUDGET_SETS is referenced by following:

APPS
SYNONYM - PQH_DFLT_BUDGET_SETS
TRIGGER - PQH_DFLT_BUDGET_SETS_WHO
PUBLIC
SYNONYM - PQH_DFLT_BUDGET_SETS

[top of page]

Table: PQH_DFLT_FUND_SRCS

Description: Cost allocation information for budget elements
Primary Key: PQH_DFLT_FUND_SRCS_PK
  1. DFLT_FUND_SRC_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_DFLT_FUND_SRCS.DFLT_BUDGET_ELEMENT_ID PQH_DFLT_BUDGET_ELEMENTS
PQH_DFLT_FUND_SRCS.COST_ALLOCATION_KEYFLEX_ID PAY_COST_ALLOCATION_KEYFLEX

[top of page]

HR.PQH_DFLT_FUND_SRCS does not reference any database object

HR.PQH_DFLT_FUND_SRCS is referenced by following:

APPS
SYNONYM - PQH_DFLT_FUND_SRCS
TRIGGER - PQH_DFLT_FUND_SRCS_WHO
PUBLIC
SYNONYM - PQH_DFLT_FUND_SRCS

[top of page]

Table: PQH_DOCUMENTS_F

Description: Document management Table; for mainly for self service pdf print
Primary Key: PQH_DOCUMENTS_F_PK
  1. DOCUMENT_ID
  2. EFFECTIVE_START_DATE
  3. EFFECTIVE_END_DATE
Primary Key: PQH_DOCUMENTS_F_UK
  1. SHORT_NAME

[top of page]

HR.PQH_DOCUMENTS_F does not reference any database object

HR.PQH_DOCUMENTS_F is referenced by following:

APPS
SYNONYM - PQH_DOCUMENTS_F
TRIGGER - PQH_DOCUMENTS_F_WHO
PUBLIC
SYNONYM - PQH_DOCUMENTS_F

[top of page]

Table: PQH_DOCUMENT_ATTRIBUTES_F

Description: Mapping attributes of document with known transaction attributes
Primary Key: PQH_DOCUMENT_ATTRIBUTES_F_PK
  1. DOCUMENT_ATTRIBUTE_ID
  2. EFFECTIVE_START_DATE
  3. EFFECTIVE_END_DATE
Primary Key: PQH_DOCUMENT_ATTRIBUTES_F_UK
  1. DOCUMENT_ID
  2. TAG_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_DOCUMENT_ATTRIBUTES_F.ATTRIBUTE_ID PQH_ATTRIBUTES

[top of page]

HR.PQH_DOCUMENT_ATTRIBUTES_F does not reference any database object

HR.PQH_DOCUMENT_ATTRIBUTES_F is referenced by following:

APPS
SYNONYM - PQH_DOCUMENT_ATTRIBUTES_F
TRIGGER - PQH_DOCUMENT_ATTRIBUTES_F_WHO
PUBLIC
SYNONYM - PQH_DOCUMENT_ATTRIBUTES_F

[top of page]

Table: PQH_ELEMENT_COMMITMENTS

Description: Element Commitment for a specific period
Primary Key: PQH_ELEMENT_COMMITMENTS_PK
  1. ELEMENT_COMMITMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_ELEMENT_COMMITMENTS.BUDGET_VERSION_ID PQH_BUDGET_VERSIONS

[top of page]

HR.PQH_ELEMENT_COMMITMENTS does not reference any database object

HR.PQH_ELEMENT_COMMITMENTS is referenced by following:

APPS
SYNONYM - PQH_ELEMENT_COMMITMENTS
TRIGGER - PQH_ELEMENT_COMMITMENTS_WHO
PUBLIC
SYNONYM - PQH_ELEMENT_COMMITMENTS

[top of page]

Table: PQH_ELEMENT_COMMITMENTS_EFC

Description: This is a Copy of PQH_ELEMENT_COMMITMENTS table populated by EFC (Euro as functinoal currency) process.
Primary Key: PQH_ELEMENT_COMMITMENTS_EF_PK
  1. ELEMENT_COMMITMENT_ID
  2. EFC_ACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_ELEMENT_COMMITMENTS_EFC.EFC_ACTION_ID HR_EFC_ACTIONS

[top of page]

HR.PQH_ELEMENT_COMMITMENTS_EFC does not reference any database object

HR.PQH_ELEMENT_COMMITMENTS_EFC is referenced by following:

APPS
SYNONYM - PQH_ELEMENT_COMMITMENTS_EFC
PUBLIC
SYNONYM - PQH_ELEMENT_COMMITMENTS_EFC

[top of page]

Table: PQH_FR_EMP_STAT_SITUATIONS

Description: Holds the statutory situations for a civil servant in French Public Sector

[top of page]

HR.PQH_FR_EMP_STAT_SITUATIONS does not reference any database object

HR.PQH_FR_EMP_STAT_SITUATIONS is referenced by following:

APPS
SYNONYM - PQH_FR_EMP_STAT_SITUATIONS
TRIGGER - PQH_FR_EMP_STAT_SITUATIONS_WHO
PUBLIC
SYNONYM - PQH_FR_EMP_STAT_SITUATIONS

[top of page]

Table: PQH_FR_GLOBAL_INDICES_F

Description: French global Indices

[top of page]

HR.PQH_FR_GLOBAL_INDICES_F does not reference any database object

HR.PQH_FR_GLOBAL_INDICES_F is referenced by following:

APPS
SYNONYM - PQH_FR_GLOBAL_INDICES_F
TRIGGER - PQH_FR_GLOBAL_INDICES_F_WHO
PUBLIC
SYNONYM - PQH_FR_GLOBAL_INDICES_F

[top of page]

Table: PQH_FR_STAT_SITUATIONS

Description: Stores details on Statutory Situations
Primary Key: PQH_FR_STAT_SITUATIONS_PK
  1. STATUTORY_SITUATION_ID

[top of page]

HR.PQH_FR_STAT_SITUATIONS does not reference any database object

HR.PQH_FR_STAT_SITUATIONS is referenced by following:

APPS
SYNONYM - PQH_FR_STAT_SITUATIONS
TRIGGER - PQH_FR_STAT_SITUATIONS_WHO
PUBLIC
SYNONYM - PQH_FR_STAT_SITUATIONS

[top of page]

Table: PQH_FR_STAT_SITUATION_RULES

Description: Stores details on Statutory Situation Criteria
Primary Key: PQH_FR_STAT_SITUATION_RULES_PK
  1. STAT_SITUATION_RULE_ID

[top of page]

HR.PQH_FR_STAT_SITUATION_RULES does not reference any database object

HR.PQH_FR_STAT_SITUATION_RULES is referenced by following:

APPS
SYNONYM - PQH_FR_STAT_SITUATION_RULES
TRIGGER - PQH_FR_STAT_SITUATION_RULE_WHO
PUBLIC
SYNONYM - PQH_FR_STAT_SITUATION_RULES

[top of page]

Table: PQH_FR_VALIDATIONS

Description: Table that keeps the details regarding the validations available for a person.
Primary Key: PQH_FR_VALIDATIONS_PK
  1. VALIDATION_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_FR_VALIDATION_EVENTS.VALIDATION_ID PQH_FR_VALIDATIONS
PQH_FR_VALIDATION_PERIODS.VALIDATION_ID PQH_FR_VALIDATIONS

[top of page]

HR.PQH_FR_VALIDATIONS does not reference any database object

HR.PQH_FR_VALIDATIONS is referenced by following:

APPS
SYNONYM - PQH_FR_VALIDATIONS
TRIGGER - PQH_FR_VALIDATIONS_WHO
PUBLIC
SYNONYM - PQH_FR_VALIDATIONS

[top of page]

Table: PQH_FR_VALIDATION_EVENTS

Description: Table that keeps the details regarding the events for a particular validations.
Primary Key: PQH_FR_VALIDATION_EVENTS_PK
  1. VALIDATION_EVENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_FR_VALIDATION_EVENTS.VALIDATION_ID PQH_FR_VALIDATIONS

[top of page]

HR.PQH_FR_VALIDATION_EVENTS does not reference any database object

HR.PQH_FR_VALIDATION_EVENTS is referenced by following:

APPS
SYNONYM - PQH_FR_VALIDATION_EVENTS
TRIGGER - PQH_FR_VALIDATION_EVENTS_WHO
PUBLIC
SYNONYM - PQH_FR_VALIDATION_EVENTS

[top of page]

Table: PQH_FR_VALIDATION_PERIODS

Description: Table that keeps the period details for a particular validation of an individual
Primary Key: PQH_FR_VALIDATION_PERIOS_PK
  1. VALIDATION_PERIOD_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_FR_VALIDATION_PERIODS.VALIDATION_ID PQH_FR_VALIDATIONS

[top of page]

HR.PQH_FR_VALIDATION_PERIODS does not reference any database object

HR.PQH_FR_VALIDATION_PERIODS is referenced by following:

APPS
SYNONYM - PQH_FR_VALIDATION_PERIODS
TRIGGER - PQH_FR_VALIDATION_PERIODS_WHO
PUBLIC
SYNONYM - PQH_FR_VALIDATION_PERIODS

[top of page]

Table: PQH_FYI_NOTIFY

Description: FYI Notification Details
Primary Key: PQH_FYI_NOTIFY_PK
  1. FYI_NOTIFIED_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_FYI_NOTIFY.TRANSACTION_CATEGORY_ID PQH_TRANSACTION_CATEGORIES

[top of page]

HR.PQH_FYI_NOTIFY does not reference any database object

HR.PQH_FYI_NOTIFY is referenced by following:

APPS
SYNONYM - PQH_FYI_NOTIFY
TRIGGER - PQH_FYI_NOTIFY_WHO
PUBLIC
SYNONYM - PQH_FYI_NOTIFY

[top of page]

Table: PQH_GL_INTERFACE

Description: Interface entity containing budget and commitment information used to post to GL
Primary Key: PQH_GL_INTERFACE_PK
  1. GL_INTERFACE_ID

[top of page]

HR.PQH_GL_INTERFACE does not reference any database object

HR.PQH_GL_INTERFACE is referenced by following:

APPS
SYNONYM - PQH_GL_INTERFACE
TRIGGER - PQH_GL_INTERFACE_WHO
PUBLIC
SYNONYM - PQH_GL_INTERFACE

[top of page]

Table: PQH_GL_INTERFACE_EFC

Description: This is a Copy of PQH_GL_INTERFACE table populated by EFC (Euro as functinoal currency) process.
Primary Key: PQH_GL_INTERFACE_EFC_PK
  1. GL_INTERFACE_ID
  2. EFC_ACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_GL_INTERFACE_EFC.EFC_ACTION_ID HR_EFC_ACTIONS

[top of page]

HR.PQH_GL_INTERFACE_EFC does not reference any database object

HR.PQH_GL_INTERFACE_EFC is referenced by following:

APPS
SYNONYM - PQH_GL_INTERFACE_EFC
PUBLIC
SYNONYM - PQH_GL_INTERFACE_EFC

[top of page]

Table: PQH_GMS_EXCESS

Description:

[top of page]

HR.PQH_GMS_EXCESS does not reference any database object

HR.PQH_GMS_EXCESS is referenced by following:

APPS
SYNONYM - PQH_GMS_EXCESS
TRIGGER - PQH_GMS_EXCESS_WHO
PUBLIC
SYNONYM - PQH_GMS_EXCESS

[top of page]

Table: PQH_PA_WHATIF_RESULTS

Description: Stores the comparative results of the current and the ?What If? benefits.

[top of page]

HR.PQH_PA_WHATIF_RESULTS does not reference any database object

HR.PQH_PA_WHATIF_RESULTS is referenced by following:

APPS
SYNONYM - PQH_PA_WHATIF_RESULTS
TRIGGER - PQH_PA_WHATIF_RESULTS_WHO
PUBLIC
SYNONYM - PQH_PA_WHATIF_RESULTS

[top of page]

Table: PQH_POSITION_TRANSACTIONS

Description: POSITION_TRANSACTION is used to maintain and create positions. Each transaction needs to be approved by pre-identified approvers. On approval these transactions are applied to database.Each transaction can have a combination of one or more
Primary Key: PQH_POSITION_TRANSACTIONS_PK
  1. POSITION_TRANSACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_POSITION_TRANSACTIONS.ENTRY_GRADE_ID PER_GRADES
PQH_POSITION_TRANSACTIONS.AVAILABILITY_STATUS_ID PER_SHARED_TYPES
PQH_POSITION_TRANSACTIONS.PAY_BASIS_ID PER_PAY_BASES
PQH_POSITION_TRANSACTIONS.WF_TRANSACTION_CATEGORY_ID PQH_TRANSACTION_CATEGORIES
PQH_POSITION_TRANSACTIONS.LOCATION_ID HR_LOCATIONS_ALL
PQH_POSITION_TRANSACTIONS.JOB_ID PER_JOBS
PQH_POSITION_TRANSACTIONS.POSITION_DEFINITION_ID PER_POSITION_DEFINITIONS
PQH_POSITION_TRANSACTIONS.BUSINESS_GROUP_ID HR_ALL_ORGANIZATION_UNITS
PQH_POSITION_TRANSACTIONS.ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_PTX_DPF_DF.POSITION_TRANSACTION_ID PQH_POSITION_TRANSACTIONS
PQH_PTX_EXTRA_INFO.POSITION_TRANSACTION_ID PQH_POSITION_TRANSACTIONS
PQH_PTX_SHADOW.POSITION_TRANSACTION_ID PQH_POSITION_TRANSACTIONS
PQH_TXN_JOB_REQUIREMENTS.POSITION_TRANSACTION_ID PQH_POSITION_TRANSACTIONS
PQH_WORKSHEET_DETAILS.POSITION_TRANSACTION_ID PQH_POSITION_TRANSACTIONS

[top of page]

HR.PQH_POSITION_TRANSACTIONS does not reference any database object

HR.PQH_POSITION_TRANSACTIONS is referenced by following:

APPS
SYNONYM - PQH_POSITION_TRANSACTIONS
TRIGGER - PQH_POSITION_TRANSACTIONS_WHO
PUBLIC
SYNONYM - PQH_POSITION_TRANSACTIONS

[top of page]

Table: PQH_PROCESS_LOG

Description: Log table
Primary Key: PQH_PROCESS_LOG_PK
  1. PROCESS_LOG_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_PROCESS_LOG.MASTER_PROCESS_LOG_ID PQH_PROCESS_LOG
PQH_PROCESS_LOG.TXN_TABLE_ROUTE_ID PQH_TABLE_ROUTE
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_PROCESS_LOG.MASTER_PROCESS_LOG_ID PQH_PROCESS_LOG

[top of page]

HR.PQH_PROCESS_LOG does not reference any database object

HR.PQH_PROCESS_LOG is referenced by following:

APPS
SYNONYM - PQH_PROCESS_LOG
TRIGGER - PQH_PROCESS_LOG_WHO
PUBLIC
SYNONYM - PQH_PROCESS_LOG

[top of page]

Table: PQH_PTE_SHADOW

Description: Copy of the Position Transaction Table. This is used for position transaction refresh.
Primary Key: PQH_PTE_SHADOW_PK
  1. PTX_EXTRA_INFO_ID

[top of page]

HR.PQH_PTE_SHADOW does not reference any database object

HR.PQH_PTE_SHADOW is referenced by following:

APPS
SYNONYM - PQH_PTE_SHADOW
TRIGGER - PQH_PTE_SHADOW_WHO
PUBLIC
SYNONYM - PQH_PTE_SHADOW

[top of page]

Table: PQH_PTX_DPF_DF

Description: Deployment factors for Position Transaction records are stored until the transaction is applied to PER_DEPLOYMENT_FACTORS
Primary Key: PQH_PTX_DPF_DF_PK
  1. PTX_DEPLOYMENT_FACTOR_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_PTX_DPF_DF.POSITION_TRANSACTION_ID PQH_POSITION_TRANSACTIONS
PQH_PTX_DPF_DF.DEPLOYMENT_FACTOR_ID PER_DEPLOYMENT_FACTORS

[top of page]

HR.PQH_PTX_DPF_DF does not reference any database object

HR.PQH_PTX_DPF_DF is referenced by following:

APPS
SYNONYM - PQH_PTX_DPF_DF
TRIGGER - PQH_PTX_DPF_DF_WHO
PUBLIC
SYNONYM - PQH_PTX_DPF_DF

[top of page]

Table: PQH_PTX_DPF_DF_SHADOW

Description: Deployment factors shadow for Position Transaction
Primary Key: PDS_PK
  1. PTX_DEPLOYMENT_FACTOR_ID

[top of page]

HR.PQH_PTX_DPF_DF_SHADOW does not reference any database object

HR.PQH_PTX_DPF_DF_SHADOW is referenced by following:

APPS
SYNONYM - PQH_PTX_DPF_DF_SHADOW
TRIGGER - PQH_PTX_DPF_DF_SHADOW_WHO
PUBLIC
SYNONYM - PQH_PTX_DPF_DF_SHADOW

[top of page]

Table: PQH_PTX_EXTRA_INFO

Description: Extra information details for Position transaction.
Primary Key: PQH_PTX_EXTRA_INFO_PK
  1. PTX_EXTRA_INFO_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_PTX_EXTRA_INFO.POSITION_TRANSACTION_ID PQH_POSITION_TRANSACTIONS

[top of page]

HR.PQH_PTX_EXTRA_INFO does not reference any database object

HR.PQH_PTX_EXTRA_INFO is referenced by following:

APPS
SYNONYM - PQH_PTX_EXTRA_INFO
TRIGGER - PQH_PTX_EXTRA_INFO_WHO
PUBLIC
SYNONYM - PQH_PTX_EXTRA_INFO

[top of page]

Table: PQH_PTX_INFO_TYPES

Description: Internal Use
Primary Key: PQH_PTX_INFO_TYPES_PK
  1. INFORMATION_TYPE

[top of page]

HR.PQH_PTX_INFO_TYPES does not reference any database object

HR.PQH_PTX_INFO_TYPES is referenced by following:

APPS
SYNONYM - PQH_PTX_INFO_TYPES
TRIGGER - PQH_PTX_INFO_TYPES_WHO
PUBLIC
SYNONYM - PQH_PTX_INFO_TYPES

[top of page]

Table: PQH_PTX_SHADOW

Description: Position Extra information shadow used for refreshing position transaction extra information.
Primary Key: PQH_PTX_SHADOW_PK
  1. POSITION_TRANSACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_PTX_SHADOW.POSITION_TRANSACTION_ID PQH_POSITION_TRANSACTIONS

[top of page]

HR.PQH_PTX_SHADOW does not reference any database object

HR.PQH_PTX_SHADOW is referenced by following:

APPS
SYNONYM - PQH_PTX_SHADOW
TRIGGER - PQH_PTX_SHADOW_WHO
PUBLIC
SYNONYM - PQH_PTX_SHADOW

[top of page]

Table: PQH_RATE_ELEMENT_RELATIONS

Description: Rate Element Relations
Primary Key: PQH_RATE_ELEMENT_RELATIONS_PK
  1. RATE_ELEMENT_RELATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_RATE_ELEMENT_RELATIONS.CRITERIA_RATE_ELEMENT_ID PQH_CRITERIA_RATE_ELEMENTS
PQH_RATE_ELEMENT_RELATIONS.BUSINESS_GROUP_ID HR_ALL_ORGANIZATION_UNITS

[top of page]

HR.PQH_RATE_ELEMENT_RELATIONS does not reference any database object

HR.PQH_RATE_ELEMENT_RELATIONS is referenced by following:

APPS
SYNONYM - PQH_RATE_ELEMENT_RELATIONS
TRIGGER - PQH_RATE_ELEMENT_RELATIONS_WHO
PUBLIC
SYNONYM - PQH_RATE_ELEMENT_RELATIONS

[top of page]

Table: PQH_RATE_FACTOR_ON_ELMNTS

Description: Table to store information about where rate factors values used to calculate a criteria rate definition must be recorded on a element
Primary Key: PQH_RATE_FACTOR_ON_ELMNTS_PK
  1. RATE_FACTOR_ON_ELMNT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_RATE_FACTOR_ON_ELMNTS.CRITERIA_RATE_ELEMENT_ID %
PQH_RATE_FACTOR_ON_ELMNTS.CRITERIA_RATE_FACTOR_ID %
PQH_RATE_FACTOR_ON_ELMNTS.BUSINESS_GROUP_ID HR_ALL_ORGANIZATION_UNITS

[top of page]

HR.PQH_RATE_FACTOR_ON_ELMNTS does not reference any database object

HR.PQH_RATE_FACTOR_ON_ELMNTS is referenced by following:

APPS
SYNONYM - PQH_RATE_FACTOR_ON_ELMNTS
TRIGGER - PQH_RATE_FACTOR_ON_ELMNTS_WHO
PUBLIC
SYNONYM - PQH_RATE_FACTOR_ON_ELMNTS

[top of page]

Table: PQH_RATE_MATRIX_NODES

Description: Table to store the nodes in a rate matrix hierarchy
Primary Key: PQH_RATE_MATRIX_NODES_PK
  1. RATE_MATRIX_NODE_ID
Primary Key: PQH_RATE_MATRIX_NODES_UK1
  1. SHORT_CODE
  2. BUSINESS_GROUP_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_RATE_MATRIX_RATES_F.RATE_MATRIX_NODE_ID PQH_RATE_MATRIX_NODES
PQH_RT_MATRIX_NODE_VALUES.RATE_MATRIX_NODE_ID PQH_RATE_MATRIX_NODES

[top of page]

HR.PQH_RATE_MATRIX_NODES does not reference any database object

HR.PQH_RATE_MATRIX_NODES is referenced by following:

APPS
SYNONYM - PQH_RATE_MATRIX_NODES
TRIGGER - PQH_RATE_MATRIX_NODES_WHO
PUBLIC
SYNONYM - PQH_RATE_MATRIX_NODES

[top of page]

Table: PQH_RATE_MATRIX_RATES_F

Description: Datetracked table to store the rate value associated with each node in a rate matrix hierarchy.
Primary Key: PQH_RATE_MATRIX_RATES_F_PK
  1. RATE_MATRIX_RATE_ID
  2. EFFECTIVE_START_DATE
  3. EFFECTIVE_END_DATE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_RATE_MATRIX_RATES_F.RATE_MATRIX_NODE_ID PQH_RATE_MATRIX_NODES
PQH_RATE_MATRIX_RATES_F.CRITERIA_RATE_DEFN_ID PQH_CRITERIA_RATE_DEFN

[top of page]

HR.PQH_RATE_MATRIX_RATES_F does not reference any database object

HR.PQH_RATE_MATRIX_RATES_F is referenced by following:

APPS
SYNONYM - PQH_RATE_MATRIX_RATES_F
TRIGGER - PQH_RATE_MATRIX_RATES_F_WHO
PUBLIC
SYNONYM - PQH_RATE_MATRIX_RATES_F

[top of page]

Table: PQH_REF_TEMPLATES

Description: Lists copy and reference templates for a template
Primary Key: PQH_REF_TEMPLATES_PK
  1. REF_TEMPLATE_ID
Primary Key: PQH_REF_TEMPLATES_UK
  1. PARENT_TEMPLATE_ID
  2. BASE_TEMPLATE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_REF_TEMPLATES.PARENT_TEMPLATE_ID PQH_TEMPLATES
PQH_REF_TEMPLATES.BASE_TEMPLATE_ID PQH_TEMPLATES

[top of page]

HR.PQH_REF_TEMPLATES does not reference any database object

HR.PQH_REF_TEMPLATES is referenced by following:

APPS
SYNONYM - PQH_REF_TEMPLATES
TRIGGER - PQH_REF_TEMPLATES_WHO
PUBLIC
SYNONYM - PQH_REF_TEMPLATES

[top of page]

Table: PQH_ROLES

Description: Roles used for position control workflow and security
Primary Key: PQH_ROLES_PK
  1. ROLE_ID
Primary Key: PQH_ROLES_UK
  1. ROLE_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_ROLES.BUSINESS_GROUP_ID HR_ALL_ORGANIZATION_UNITS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_ROLE_EXTRA_INFO.ROLE_ID PQH_ROLES
PQH_ROLE_TEMPLATES.ROLE_ID PQH_ROLES
PQH_ROUTING_CATEGORIES.OVERRIDE_ROLE_ID PQH_ROLES
PQH_ROUTING_HISTORY.FORWARDED_TO_ROLE_ID PQH_ROLES
PQH_ROUTING_HISTORY.FORWARDED_BY_ROLE_ID PQH_ROLES
PQH_ROUTING_LIST_MEMBERS.ROLE_ID PQH_ROLES

[top of page]

HR.PQH_ROLES does not reference any database object

HR.PQH_ROLES is referenced by following:

APPS
SYNONYM - PQH_ROLES
TRIGGER - PQH_ROLES_WHO
PUBLIC
SYNONYM - PQH_ROLES

[top of page]

Table: PQH_ROLE_EXTRA_INFO

Description:
Primary Key: PQH_ROLE_EXTRA_INFO_PK
  1. ROLE_EXTRA_INFO_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_ROLE_EXTRA_INFO.INFORMATION_TYPE %
PQH_ROLE_EXTRA_INFO.ROLE_ID PQH_ROLES

[top of page]

HR.PQH_ROLE_EXTRA_INFO does not reference any database object

HR.PQH_ROLE_EXTRA_INFO is referenced by following:

APPS
SYNONYM - PQH_ROLE_EXTRA_INFO
TRIGGER - PQH_ROLE_EXTRA_INFO_WHO
PUBLIC
SYNONYM - PQH_ROLE_EXTRA_INFO

[top of page]

Table: PQH_ROLE_INFO_TYPES

Description:
Primary Key: PQH_ROLE_INFO_TYPES_PK
  1. INFORMATION_TYPE

[top of page]

HR.PQH_ROLE_INFO_TYPES does not reference any database object

HR.PQH_ROLE_INFO_TYPES is referenced by following:

APPS
SYNONYM - PQH_ROLE_INFO_TYPES
TRIGGER - PQH_ROLE_INFO_TYPES_WHO
PUBLIC
SYNONYM - PQH_ROLE_INFO_TYPES

[top of page]

Table: PQH_ROLE_TEMPLATES

Description: Tempalte for a transaction category attached to a role
Primary Key: PQH_ROLE_TEMPLATES_PK
  1. ROLE_TEMPLATE_ID
Primary Key: PQH_ROLE_TEMPLATES_UK1
  1. ROLE_ID
  2. TRANSACTION_CATEGORY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_ROLE_TEMPLATES.ROLE_ID PQH_ROLES
PQH_ROLE_TEMPLATES.TRANSACTION_CATEGORY_ID PQH_TRANSACTION_CATEGORIES
PQH_ROLE_TEMPLATES.TEMPLATE_ID PQH_TEMPLATES

[top of page]

HR.PQH_ROLE_TEMPLATES does not reference any database object

HR.PQH_ROLE_TEMPLATES is referenced by following:

APPS
SYNONYM - PQH_ROLE_TEMPLATES
TRIGGER - PQH_ROLE_TEMPLATES_WHO
PUBLIC
SYNONYM - PQH_ROLE_TEMPLATES

[top of page]

Table: PQH_ROUTING_CATEGORIES

Description: Transaction Routing Information
Primary Key: PQH_ROUTING_CATEGORIES_PK
  1. ROUTING_CATEGORY_ID
Primary Key: PQH_ROUTING_CATEGORIES_UK1
  1. TRANSACTION_CATEGORY_ID
  2. DEFAULT_FLAG
  3. ROUTING_LIST_ID
  4. POSITION_STRUCTURE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_ROUTING_CATEGORIES.ROUTING_LIST_ID PQH_ROUTING_LISTS
PQH_ROUTING_CATEGORIES.TRANSACTION_CATEGORY_ID PQH_TRANSACTION_CATEGORIES
PQH_ROUTING_CATEGORIES.POSITION_STRUCTURE_ID PER_POSITION_STRUCTURES
PQH_ROUTING_CATEGORIES.OVERRIDE_ROLE_ID PQH_ROLES
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_ATTRIBUTE_RANGES.ROUTING_CATEGORY_ID PQH_ROUTING_CATEGORIES
PQH_ROUTING_HISTORY.ROUTING_CATEGORY_ID PQH_ROUTING_CATEGORIES

[top of page]

HR.PQH_ROUTING_CATEGORIES does not reference any database object

HR.PQH_ROUTING_CATEGORIES is referenced by following:

APPS
SYNONYM - PQH_ROUTING_CATEGORIES
TRIGGER - PQH_ROUTING_CATEGORIES_WHO
PUBLIC
SYNONYM - PQH_ROUTING_CATEGORIES

[top of page]

Table: PQH_ROUTING_HISTORY

Description: Keeps track of each hop during the routing / approver process. It also has some pre-identified attributes stored with new values
Primary Key: PQH_ROUTING_HISTORY_PK
  1. ROUTING_HISTORY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_ROUTING_HISTORY.ROUTING_CATEGORY_ID PQH_ROUTING_CATEGORIES
PQH_ROUTING_HISTORY.TRANSACTION_CATEGORY_ID PQH_TRANSACTION_CATEGORIES
PQH_ROUTING_HISTORY.FORWARDED_BY_MEMBER_ID PQH_ROUTING_LIST_MEMBERS
PQH_ROUTING_HISTORY.FORWARDED_TO_MEMBER_ID PQH_ROUTING_LIST_MEMBERS
PQH_ROUTING_HISTORY.POS_STRUCTURE_VERSION_ID PER_POS_STRUCTURE_VERSIONS
PQH_ROUTING_HISTORY.FORWARDED_TO_ROLE_ID PQH_ROLES
PQH_ROUTING_HISTORY.FORWARDED_BY_ROLE_ID PQH_ROLES
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_ROUTING_HIST_ATTRIBS.ROUTING_HISTORY_ID PQH_ROUTING_HISTORY

[top of page]

HR.PQH_ROUTING_HISTORY does not reference any database object

HR.PQH_ROUTING_HISTORY is referenced by following:

APPS
SYNONYM - PQH_ROUTING_HISTORY
TRIGGER - PQH_ROUTING_HISTORY_WHO
PUBLIC
SYNONYM - PQH_ROUTING_HISTORY

[top of page]

Table: PQH_ROUTING_HIST_ATTRIBS

Description: Attribute values for each step of routing
Primary Key: PQH_ROUTING_HIST_ATTRIBS_PK
  1. ROUTING_HIST_ATTRIB_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_ROUTING_HIST_ATTRIBS.ROUTING_HISTORY_ID PQH_ROUTING_HISTORY
PQH_ROUTING_HIST_ATTRIBS.ATTRIBUTE_ID PQH_ATTRIBUTES

[top of page]

HR.PQH_ROUTING_HIST_ATTRIBS does not reference any database object

HR.PQH_ROUTING_HIST_ATTRIBS is referenced by following:

APPS
SYNONYM - PQH_ROUTING_HIST_ATTRIBS
TRIGGER - PQH_ROUTING_HIST_ATTRIBS_WHO
PUBLIC
SYNONYM - PQH_ROUTING_HIST_ATTRIBS

[top of page]

Table: PQH_ROUTING_LISTS

Description: Routing list used for position controlled workflow
Primary Key: PQH_ROUTING_LISTS_PK
  1. ROUTING_LIST_ID
Primary Key: PQH_ROUTING_LISTS_UK
  1. ROUTING_LIST_NAME
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_ROUTING_CATEGORIES.ROUTING_LIST_ID PQH_ROUTING_LISTS
PQH_ROUTING_LIST_MEMBERS.ROUTING_LIST_ID PQH_ROUTING_LISTS

[top of page]

HR.PQH_ROUTING_LISTS does not reference any database object

HR.PQH_ROUTING_LISTS is referenced by following:

APPS
SYNONYM - PQH_ROUTING_LISTS
TRIGGER - PQH_ROUTING_LISTS_WHO
PUBLIC
SYNONYM - PQH_ROUTING_LISTS

[top of page]

Table: PQH_ROUTING_LIST_MEMBERS

Description: Roles and role users that constitute the routing list
Primary Key: PQH_ROUTING_LIST_MEMBERS_PK
  1. ROUTING_LIST_MEMBER_ID
Primary Key: PQH_ROUTING_LIST_MEMBERS_UK
  1. ROUTING_LIST_ID
  2. ROLE_ID
  3. USER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_ROUTING_LIST_MEMBERS.ROLE_ID PQH_ROLES
PQH_ROUTING_LIST_MEMBERS.ROUTING_LIST_ID PQH_ROUTING_LISTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_ATTRIBUTE_RANGES.ROUTING_LIST_MEMBER_ID PQH_ROUTING_LIST_MEMBERS
PQH_ROUTING_HISTORY.FORWARDED_BY_MEMBER_ID PQH_ROUTING_LIST_MEMBERS
PQH_ROUTING_HISTORY.FORWARDED_TO_MEMBER_ID PQH_ROUTING_LIST_MEMBERS

[top of page]

HR.PQH_ROUTING_LIST_MEMBERS does not reference any database object

HR.PQH_ROUTING_LIST_MEMBERS is referenced by following:

APPS
SYNONYM - PQH_ROUTING_LIST_MEMBERS
TRIGGER - PQH_ROUTING_LIST_MEMBERS_WHO
PUBLIC
SYNONYM - PQH_ROUTING_LIST_MEMBERS

[top of page]

Table: PQH_RT_MATRIX_NODE_VALUES

Description: Table to store criteria values for a particular rate matrix node.
Primary Key: PQH_RT_MATRIX_NODE_VALUES_PK
  1. NODE_VALUE_ID
Primary Key: PQH_RT_MATRIX_NODE_VALUES_UK1
  1. SHORT_CODE
  2. BUSINESS_GROUP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_RT_MATRIX_NODE_VALUES.RATE_MATRIX_NODE_ID PQH_RATE_MATRIX_NODES

[top of page]

HR.PQH_RT_MATRIX_NODE_VALUES does not reference any database object

HR.PQH_RT_MATRIX_NODE_VALUES is referenced by following:

APPS
SYNONYM - PQH_RT_MATRIX_NODE_VALUES
TRIGGER - PQH_RT_MATRIX_NODE_VALUES_WHO
PUBLIC
SYNONYM - PQH_RT_MATRIX_NODE_VALUES

[top of page]

Table: PQH_RULES

Description: Configurable business rules
Primary Key: PQH_RULES_PK
  1. RULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_RULES.RULE_SET_ID PQH_RULE_SETS

[top of page]

HR.PQH_RULES does not reference any database object

HR.PQH_RULES is referenced by following:

APPS
SYNONYM - PQH_RULES
TRIGGER - PQH_RULES_WHO
PUBLIC
SYNONYM - PQH_RULES

[top of page]

Table: PQH_RULE_ATTRIBUTES

Description: Details regarding the attributes for which the rule is mapped is stored.
Primary Key: PQH_RULE_ATTRIBUTES_PK
  1. RULE_ATTRIBUTE_ID

[top of page]

HR.PQH_RULE_ATTRIBUTES does not reference any database object

HR.PQH_RULE_ATTRIBUTES is referenced by following:

APPS
SYNONYM - PQH_RULE_ATTRIBUTES
TRIGGER - PQH_RULE_ATTRIBUTES_WHO
PUBLIC
SYNONYM - PQH_RULE_ATTRIBUTES

[top of page]

Table: PQH_RULE_SETS

Description: Set of one or more configurable business rule
Primary Key: PQH_RULE_SETS_PK
  1. RULE_SET_ID
Primary Key: PQH_RULE_SETS_UK
  1. SHORT_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_RULE_SETS.REFERENCED_RULE_SET_ID PQH_RULE_SETS
PQH_RULE_SETS.ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
PQH_RULE_SETS.BUSINESS_GROUP_ID HR_ALL_ORGANIZATION_UNITS
PQH_RULE_SETS.ORGANIZATION_STRUCTURE_ID PER_ORGANIZATION_STRUCTURES
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_RULES.RULE_SET_ID PQH_RULE_SETS
PQH_RULE_SETS.REFERENCED_RULE_SET_ID PQH_RULE_SETS

[top of page]

HR.PQH_RULE_SETS does not reference any database object

HR.PQH_RULE_SETS is referenced by following:

APPS
SYNONYM - PQH_RULE_SETS
TRIGGER - PQH_RULE_SETS_WHO
PUBLIC
SYNONYM - PQH_RULE_SETS

[top of page]

Table: PQH_RULE_SETS_TL

Description: Translated Rule set information
Primary Key: PQH_RULE_SETS_TL_PK
  1. RULE_SET_ID
  2. LANGUAGE

[top of page]

HR.PQH_RULE_SETS_TL does not reference any database object

HR.PQH_RULE_SETS_TL is referenced by following:

APPS
SYNONYM - PQH_RULE_SETS_TL
TRIGGER - PQH_RULE_SETS_TL041339_WHO
PUBLIC
SYNONYM - PQH_RULE_SETS_TL

[top of page]

Table: PQH_SITUATIONS

Description: Situation Information

[top of page]

HR.PQH_SITUATIONS does not reference any database object

HR.PQH_SITUATIONS is referenced by following:

APPS
SYNONYM - PQH_SITUATIONS
TRIGGER - PQH_SITUATIONS_WHO
PUBLIC
SYNONYM - PQH_SITUATIONS

[top of page]

Table: PQH_SPECIAL_ATTRIBUTES

Description: Identifies attributes with special functions
Primary Key: PQH_SPECIAL_ATTRIBUTES_PK
  1. SPECIAL_ATTRIBUTE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_SPECIAL_ATTRIBUTES.TXN_CATEGORY_ATTRIBUTE_ID PQH_TXN_CATEGORY_ATTRIBUTES
PQH_SPECIAL_ATTRIBUTES.CONTEXT PQH_COPY_ENTITY_CONTEXTS

[top of page]

HR.PQH_SPECIAL_ATTRIBUTES does not reference any database object

HR.PQH_SPECIAL_ATTRIBUTES is referenced by following:

APPS
SYNONYM - PQH_SPECIAL_ATTRIBUTES
TRIGGER - PQH_SPECIAL_ATTRIBUTES_WHO
PUBLIC
SYNONYM - PQH_SPECIAL_ATTRIBUTES

[top of page]

Table: PQH_SS_APPROVAL_HISTORY

Description: Self Service Transaction History - Approval History
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_SS_APPROVAL_HISTORY.USER_NAME FND_USER

[top of page]

HR.PQH_SS_APPROVAL_HISTORY does not reference any database object

HR.PQH_SS_APPROVAL_HISTORY is referenced by following:

APPS
SYNONYM - PQH_SS_APPROVAL_HISTORY
TRIGGER - PQH_SS_APPROVAL_HISTORY_WHO
PUBLIC
SYNONYM - PQH_SS_APPROVAL_HISTORY

[top of page]

Table: PQH_SS_PRINT_DATA

Description: Temporary table to hold value for SS pdf printing

[top of page]

HR.PQH_SS_PRINT_DATA does not reference any database object

HR.PQH_SS_PRINT_DATA is referenced by following:

APPS
SYNONYM - PQH_SS_PRINT_DATA
TRIGGER - PQH_SS_PRINT_DATA_WHO
PUBLIC
SYNONYM - PQH_SS_PRINT_DATA

[top of page]

Table: PQH_SS_PRINT_LABEL_TEMP

Description: Temporary Table to process Document Labels for display on Doc Management

[top of page]

HR.PQH_SS_PRINT_LABEL_TEMP does not reference any database object

HR.PQH_SS_PRINT_LABEL_TEMP is referenced by following:

APPS
SYNONYM - PQH_SS_PRINT_LABEL_TEMP
TRIGGER - PQH_SS_PRINT_LABEL_TEMP_WHO
PUBLIC
SYNONYM - PQH_SS_PRINT_LABEL_TEMP

[top of page]

Table: PQH_SS_STEP_HISTORY

Description: Self Service Transaction History - Step History

[top of page]

HR.PQH_SS_STEP_HISTORY does not reference any database object

HR.PQH_SS_STEP_HISTORY is referenced by following:

APPS
SYNONYM - PQH_SS_STEP_HISTORY
TRIGGER - PQH_SS_STEP_HISTORY_WHO
PUBLIC
SYNONYM - PQH_SS_STEP_HISTORY

[top of page]

Table: PQH_SS_TRANSACTION_HISTORY

Description: Self Service Transaction History - Transaction History

[top of page]

HR.PQH_SS_TRANSACTION_HISTORY does not reference any database object

HR.PQH_SS_TRANSACTION_HISTORY is referenced by following:

APPS
SYNONYM - PQH_SS_TRANSACTION_HISTORY
TRIGGER - PQH_SS_TRANSACTION_HISTORY_WHO
PUBLIC
SYNONYM - PQH_SS_TRANSACTION_HISTORY

[top of page]

Table: PQH_SS_VALUE_HISTORY

Description: Self Service Transaction History - Item Value History

[top of page]

HR.PQH_SS_VALUE_HISTORY does not reference any database object

HR.PQH_SS_VALUE_HISTORY is referenced by following:

APPS
SYNONYM - PQH_SS_VALUE_HISTORY
TRIGGER - PQH_SS_VALUE_HISTORY_WHO
PUBLIC
SYNONYM - PQH_SS_VALUE_HISTORY

[top of page]

Table: PQH_TABLE_ROUTE

Description: Table information for dynamic queries
Primary Key: PQH_TABLE_ROUTE_PK
  1. TABLE_ROUTE_ID
Primary Key: PQH_TABLE_ROUTE_UK1
  1. TABLE_ALIAS
Primary Key: PQH_TABLE_ROUTE_UK2
  1. DISPLAY_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_TABLE_ROUTE.SHADOW_TABLE_ROUTE_ID PQH_TABLE_ROUTE
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_ATTRIBUTES.MASTER_TABLE_ROUTE_ID PQH_TABLE_ROUTE
PQH_COPY_ENTITY_FUNCTIONS.TABLE_ROUTE_ID PQH_TABLE_ROUTE
PQH_COPY_ENTITY_PREFS.TABLE_ROUTE_ID PQH_TABLE_ROUTE
PQH_PROCESS_LOG.TXN_TABLE_ROUTE_ID PQH_TABLE_ROUTE
PQH_TABLE_ROUTE.SHADOW_TABLE_ROUTE_ID PQH_TABLE_ROUTE
PQH_TRANSACTION_CATEGORIES.CONSOLIDATED_TABLE_ROUTE_ID PQH_TABLE_ROUTE
PQH_TRANSACTION_CATEGORIES.MASTER_TABLE_ROUTE_ID PQH_TABLE_ROUTE
PQH_TXN_CATEGORY_ATTRIBUTES.TRANSACTION_TABLE_ROUTE_ID PQH_TABLE_ROUTE

[top of page]

HR.PQH_TABLE_ROUTE does not reference any database object

HR.PQH_TABLE_ROUTE is referenced by following:

APPS
SYNONYM - PQH_TABLE_ROUTE
TRIGGER - PQH_TABLE_ROUTE_WHO
PUBLIC
SYNONYM - PQH_TABLE_ROUTE

[top of page]

Table: PQH_TABLE_ROUTE_TL

Description: Translated Table Information
Primary Key: PQH_TABLE_ROUTE_TL_PK
  1. TABLE_ROUTE_ID
  2. LANGUAGE

[top of page]

HR.PQH_TABLE_ROUTE_TL does not reference any database object

HR.PQH_TABLE_ROUTE_TL is referenced by following:

APPS
SYNONYM - PQH_TABLE_ROUTE_TL
TRIGGER - PQH_TABLE_ROUTE_TL041457_WHO
PUBLIC
SYNONYM - PQH_TABLE_ROUTE_TL

[top of page]

Table: PQH_TEMPLATES

Description: Position control data security
Primary Key: PQH_TEMPLATES_PK
  1. TEMPLATE_ID
Primary Key: PQH_TEMPLATES_UK
  1. SHORT_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_TEMPLATES.TRANSACTION_CATEGORY_ID PQH_TRANSACTION_CATEGORIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_REF_TEMPLATES.PARENT_TEMPLATE_ID PQH_TEMPLATES
PQH_REF_TEMPLATES.BASE_TEMPLATE_ID PQH_TEMPLATES
PQH_ROLE_TEMPLATES.TEMPLATE_ID PQH_TEMPLATES
PQH_TEMPLATE_ATTRIBUTES.TEMPLATE_ID PQH_TEMPLATES
PQH_TRANSACTION_TEMPLATES.TEMPLATE_ID PQH_TEMPLATES

[top of page]

HR.PQH_TEMPLATES does not reference any database object

HR.PQH_TEMPLATES is referenced by following:

APPS
SYNONYM - PQH_TEMPLATES
TRIGGER - PQH_TEMPLATES_WHO
PUBLIC
SYNONYM - PQH_TEMPLATES

[top of page]

Table: PQH_TEMPLATES_TL

Description: Translation for Templates
Primary Key: PQH_TEMPLATES_TL_PK
  1. TEMPLATE_ID
  2. LANGUAGE

[top of page]

HR.PQH_TEMPLATES_TL does not reference any database object

HR.PQH_TEMPLATES_TL is referenced by following:

APPS
SYNONYM - PQH_TEMPLATES_TL
TRIGGER - PQH_TEMPLATES_TL041515_WHO
PUBLIC
SYNONYM - PQH_TEMPLATES_TL

[top of page]

Table: PQH_TEMPLATE_ATTRIBUTES

Description: List of attributes and their security level that are defined for a template
Primary Key: PQH_TEMPLATE_ATTRIBUTES_PK
  1. TEMPLATE_ATTRIBUTE_ID
Primary Key: PQH_TEMPLATE_ATTRIBUTES_UK
  1. ATTRIBUTE_ID
  2. TEMPLATE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_TEMPLATE_ATTRIBUTES.ATTRIBUTE_ID PQH_ATTRIBUTES
PQH_TEMPLATE_ATTRIBUTES.TEMPLATE_ID PQH_TEMPLATES

[top of page]

HR.PQH_TEMPLATE_ATTRIBUTES does not reference any database object

HR.PQH_TEMPLATE_ATTRIBUTES is referenced by following:

APPS
SYNONYM - PQH_TEMPLATE_ATTRIBUTES
TRIGGER - PQH_TEMPLATE_ATTRIBUTES_WHO
PUBLIC
SYNONYM - PQH_TEMPLATE_ATTRIBUTES

[top of page]

Table: PQH_TJR_SHADOW

Description: Transaction Job Requirements Shadow Table
Primary Key: PQH_TJR_SHADOW_PK
  1. TXN_JOB_REQUIREMENT_ID

[top of page]

HR.PQH_TJR_SHADOW does not reference any database object

HR.PQH_TJR_SHADOW is referenced by following:

APPS
SYNONYM - PQH_TJR_SHADOW
TRIGGER - PQH_TJR_SHADOW_WHO
PUBLIC
SYNONYM - PQH_TJR_SHADOW

[top of page]

Table: PQH_TRANSACTION_CATEGORIES

Description: Setup information to allow selective routing of transactions
Primary Key: PQH_TRANSACTION_CATEGORIES_PK
  1. TRANSACTION_CATEGORY_ID
Primary Key: PQH_TRANSACTION_CATEGORIES_UK
  1. SHORT_NAME
  2. BUSINESS_GROUP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_TRANSACTION_CATEGORIES.CONSOLIDATED_TABLE_ROUTE_ID PQH_TABLE_ROUTE
PQH_TRANSACTION_CATEGORIES.MASTER_TABLE_ROUTE_ID PQH_TABLE_ROUTE
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_COPY_ENTITY_TXNS.TRANSACTION_CATEGORY_ID PQH_TRANSACTION_CATEGORIES
PQH_COPY_ENTITY_TXNS.WF_TRANSACTION_CATEGORY_ID PQH_TRANSACTION_CATEGORIES
PQH_FYI_NOTIFY.TRANSACTION_CATEGORY_ID PQH_TRANSACTION_CATEGORIES
PQH_POSITION_TRANSACTIONS.WF_TRANSACTION_CATEGORY_ID PQH_TRANSACTION_CATEGORIES
PQH_ROLE_TEMPLATES.TRANSACTION_CATEGORY_ID PQH_TRANSACTION_CATEGORIES
PQH_ROUTING_CATEGORIES.TRANSACTION_CATEGORY_ID PQH_TRANSACTION_CATEGORIES
PQH_ROUTING_HISTORY.TRANSACTION_CATEGORY_ID PQH_TRANSACTION_CATEGORIES
PQH_TEMPLATES.TRANSACTION_CATEGORY_ID PQH_TRANSACTION_CATEGORIES
PQH_TRANSACTION_TEMPLATES.TRANSACTION_CATEGORY_ID PQH_TRANSACTION_CATEGORIES
PQH_TXN_CATEGORY_ATTRIBUTES.TRANSACTION_CATEGORY_ID PQH_TRANSACTION_CATEGORIES
PQH_WORKSHEETS.WF_TRANSACTION_CATEGORY_ID PQH_TRANSACTION_CATEGORIES

[top of page]

HR.PQH_TRANSACTION_CATEGORIES does not reference any database object

HR.PQH_TRANSACTION_CATEGORIES is referenced by following:

APPS
SYNONYM - PQH_TRANSACTION_CATEGORIES
TRIGGER - PQH_TRANSACTION_CATEGORIES_WHO
PUBLIC
SYNONYM - PQH_TRANSACTION_CATEGORIES

[top of page]

Table: PQH_TRANSACTION_CATEGORIES_TL

Description: Transalation for Transaction Category
Primary Key: PQH_TXN_CATEGORIES_TL_PK
  1. TRANSACTION_CATEGORY_ID
  2. LANGUAGE

[top of page]

HR.PQH_TRANSACTION_CATEGORIES_TL does not reference any database object

HR.PQH_TRANSACTION_CATEGORIES_TL is referenced by following:

APPS
TRIGGER - PQH_TRANSACTION_CATE041444_WHO
SYNONYM - PQH_TRANSACTION_CATEGORIES_TL
PUBLIC
SYNONYM - PQH_TRANSACTION_CATEGORIES_TL

[top of page]

Table: PQH_TRANSACTION_TEMPLATES

Description: Task templates which determines the type/security of a transaction is stored here
Primary Key: PQH_TRANSACTION_TEMPLATES_PK
  1. TRANSACTION_TEMPLATE_ID
Primary Key: PQH_TRANSACTION_TEMPLATE_UK
  1. TEMPLATE_ID
  2. TRANSACTION_ID
  3. TRANSACTION_CATEGORY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_TRANSACTION_TEMPLATES.TRANSACTION_CATEGORY_ID PQH_TRANSACTION_CATEGORIES
PQH_TRANSACTION_TEMPLATES.TEMPLATE_ID PQH_TEMPLATES

[top of page]

HR.PQH_TRANSACTION_TEMPLATES does not reference any database object

HR.PQH_TRANSACTION_TEMPLATES is referenced by following:

APPS
SYNONYM - PQH_TRANSACTION_TEMPLATES
TRIGGER - PQH_TRANSACTION_TEMPLATES_WHO
PUBLIC
SYNONYM - PQH_TRANSACTION_TEMPLATES

[top of page]

Table: PQH_TXN_CATEGORY_ATTRIBUTES

Description: Intersection entity between transaction category and table attributes
Primary Key: PQH_TXN_CATEGORY_ATTRIBUTES_PK
  1. TXN_CATEGORY_ATTRIBUTE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_TXN_CATEGORY_ATTRIBUTES.TRANSACTION_TABLE_ROUTE_ID PQH_TABLE_ROUTE
PQH_TXN_CATEGORY_ATTRIBUTES.ATTRIBUTE_ID PQH_ATTRIBUTES
PQH_TXN_CATEGORY_ATTRIBUTES.TRANSACTION_CATEGORY_ID PQH_TRANSACTION_CATEGORIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_COPY_ENTITY_TXNS.TXN_CATEGORY_ATTRIBUTE_ID PQH_TXN_CATEGORY_ATTRIBUTES
PQH_SPECIAL_ATTRIBUTES.TXN_CATEGORY_ATTRIBUTE_ID PQH_TXN_CATEGORY_ATTRIBUTES

[top of page]

HR.PQH_TXN_CATEGORY_ATTRIBUTES does not reference any database object

HR.PQH_TXN_CATEGORY_ATTRIBUTES is referenced by following:

APPS
SYNONYM - PQH_TXN_CATEGORY_ATTRIBUTES
TRIGGER - PQH_TXN_CATEGORY_ATTRIBUTE_WHO
PUBLIC
SYNONYM - PQH_TXN_CATEGORY_ATTRIBUTES

[top of page]

Table: PQH_TXN_CATEGORY_DOCUMENTS

Description: Intersection entity between transaction category and documents. Also hold the type associated with the document in the transaction category context.
Primary Key: PQH_TXN_CATEGORY_DOCUMENTS_PK
  1. DOCUMENT_ID
  2. TRANSACTION_CATEGORY_ID

[top of page]

HR.PQH_TXN_CATEGORY_DOCUMENTS does not reference any database object

HR.PQH_TXN_CATEGORY_DOCUMENTS is referenced by following:

APPS
SYNONYM - PQH_TXN_CATEGORY_DOCUMENTS
TRIGGER - PQH_TXN_CATEGORY_DOCUMENTS_WHO
PUBLIC
SYNONYM - PQH_TXN_CATEGORY_DOCUMENTS

[top of page]

Table: PQH_TXN_JOB_REQUIREMENTS

Description: Transaction table for per_job_requirements ( part of position control )
Primary Key: PQH_TXN_JOB_REQUIREMENTS_PK
  1. TXN_JOB_REQUIREMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_TXN_JOB_REQUIREMENTS.JOB_REQUIREMENT_ID PER_JOB_REQUIREMENTS
PQH_TXN_JOB_REQUIREMENTS.POSITION_TRANSACTION_ID PQH_POSITION_TRANSACTIONS
PQH_TXN_JOB_REQUIREMENTS.BUSINESS_GROUP_ID HR_ALL_ORGANIZATION_UNITS
PQH_TXN_JOB_REQUIREMENTS.ANALYSIS_CRITERIA_ID PER_ANALYSIS_CRITERIA
PQH_TXN_JOB_REQUIREMENTS.JOB_ID PER_JOBS

[top of page]

HR.PQH_TXN_JOB_REQUIREMENTS does not reference any database object

HR.PQH_TXN_JOB_REQUIREMENTS is referenced by following:

APPS
SYNONYM - PQH_TXN_JOB_REQUIREMENTS
TRIGGER - PQH_TXN_JOB_REQUIREMENTS_WHO
PUBLIC
SYNONYM - PQH_TXN_JOB_REQUIREMENTS

[top of page]

Table: PQH_WIZARD_CANVASES

Description: Store Navigational details for Wizard forms
Primary Key: PQH_WIZARD_CANVASES_PK
  1. WIZARD_CANVAS_ID

[top of page]

HR.PQH_WIZARD_CANVASES does not reference any database object

HR.PQH_WIZARD_CANVASES is referenced by following:

APPS
SYNONYM - PQH_WIZARD_CANVASES
TRIGGER - PQH_WIZARD_CANVASES_WHO
PUBLIC
SYNONYM - PQH_WIZARD_CANVASES

[top of page]

Table: PQH_WORKSHEETS

Description: Transaction data for working on budget version
Primary Key: PQH_WORKSHEETS_PK
  1. WORKSHEET_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_WORKSHEETS.BUDGET_ID PQH_BUDGETS
PQH_WORKSHEETS.BUDGET_VERSION_ID PQH_BUDGET_VERSIONS
PQH_WORKSHEETS.WF_TRANSACTION_CATEGORY_ID PQH_TRANSACTION_CATEGORIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_WORKSHEET_DETAILS.WORKSHEET_ID PQH_WORKSHEETS

[top of page]

HR.PQH_WORKSHEETS does not reference any database object

HR.PQH_WORKSHEETS is referenced by following:

APPS
SYNONYM - PQH_WORKSHEETS
TRIGGER - PQH_WORKSHEETS_WHO
PUBLIC
SYNONYM - PQH_WORKSHEETS

[top of page]

Table: PQH_WORKSHEET_BDGT_ELMNTS

Description: Element wise distribution of measurement units
Primary Key: PQH_WORKSHEET_BDGT_ELMNTS_PK
  1. WORKSHEET_BDGT_ELMNT_ID
Primary Key: PQH_WORKSHEET_BDGT_ELMNTS_UK
  1. WORKSHEET_BUDGET_SET_ID
  2. ELEMENT_TYPE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_WORKSHEET_BDGT_ELMNTS.WORKSHEET_BUDGET_SET_ID PQH_WORKSHEET_BUDGET_SETS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_WORKSHEET_FUND_SRCS.WORKSHEET_BDGT_ELMNT_ID PQH_WORKSHEET_BDGT_ELMNTS

[top of page]

HR.PQH_WORKSHEET_BDGT_ELMNTS does not reference any database object

HR.PQH_WORKSHEET_BDGT_ELMNTS is referenced by following:

APPS
SYNONYM - PQH_WORKSHEET_BDGT_ELMNTS
TRIGGER - PQH_WORKSHEET_BDGT_ELMNTS_WHO
PUBLIC
SYNONYM - PQH_WORKSHEET_BDGT_ELMNTS

[top of page]

Table: PQH_WORKSHEET_BUDGET_SETS

Description: Budget set wise distribution of worksheet
Primary Key: PQH_WORKSHEET_BUDGET_SETS_PK
  1. WORKSHEET_BUDGET_SET_ID
Primary Key: PQH_WORKSHEET_BUDGET_SETS_UK
  1. WORKSHEET_PERIOD_ID
  2. DFLT_BUDGET_SET_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_WORKSHEET_BUDGET_SETS.WORKSHEET_PERIOD_ID PQH_WORKSHEET_PERIODS
PQH_WORKSHEET_BUDGET_SETS.DFLT_BUDGET_SET_ID PQH_DFLT_BUDGET_SETS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_WORKSHEET_BDGT_ELMNTS.WORKSHEET_BUDGET_SET_ID PQH_WORKSHEET_BUDGET_SETS

[top of page]

HR.PQH_WORKSHEET_BUDGET_SETS does not reference any database object

HR.PQH_WORKSHEET_BUDGET_SETS is referenced by following:

APPS
SYNONYM - PQH_WORKSHEET_BUDGET_SETS
TRIGGER - PQH_WORKSHEET_BUDGET_SETS_WHO
PUBLIC
SYNONYM - PQH_WORKSHEET_BUDGET_SETS

[top of page]

Table: PQH_WORKSHEET_BUDGET_SETS_EFC

Description: This is a Copy of PQH_WORKSHEET_BUDGET_SETS table populated by EFC (Euro as functinoal currency) process.
Primary Key: PQH_WORKSHEET_BUDGET_S_EFC_PK
  1. WORKSHEET_BUDGET_SET_ID
  2. EFC_ACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_WORKSHEET_BUDGET_SETS_EFC.EFC_ACTION_ID HR_EFC_ACTIONS

[top of page]

HR.PQH_WORKSHEET_BUDGET_SETS_EFC does not reference any database object

HR.PQH_WORKSHEET_BUDGET_SETS_EFC is referenced by following:

APPS
SYNONYM - PQH_WORKSHEET_BUDGET_SETS_EFC
PUBLIC
SYNONYM - PQH_WORKSHEET_BUDGET_SETS_EFC

[top of page]

Table: PQH_WORKSHEET_DETAILS

Description: Work table of Hr entities for Budget information
Primary Key: PQH_WORKSHEET_DETAILS_PK
  1. WORKSHEET_DETAIL_ID
Primary Key: PQH_WORKSHEET_DETAILS_UK
  1. ACTION_CD
  2. WORKSHEET_ID
  3. GRADE_ID
  4. POSITION_ID
  5. JOB_ID
  6. ORGANIZATION_ID
  7. POSITION_TRANSACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_WORKSHEET_DETAILS.ORGANIZATION_ID HR_ALL_ORGANIZATION_UNITS
PQH_WORKSHEET_DETAILS.BUDGET_DETAIL_ID PQH_BUDGET_DETAILS
PQH_WORKSHEET_DETAILS.POSITION_TRANSACTION_ID PQH_POSITION_TRANSACTIONS
PQH_WORKSHEET_DETAILS.JOB_ID PER_JOBS
PQH_WORKSHEET_DETAILS.GRADE_ID PER_GRADES
PQH_WORKSHEET_DETAILS.WORKSHEET_ID PQH_WORKSHEETS
PQH_WORKSHEET_DETAILS.PARENT_WORKSHEET_DETAIL_ID PQH_WORKSHEET_DETAILS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_WORKSHEET_DETAILS.PARENT_WORKSHEET_DETAIL_ID PQH_WORKSHEET_DETAILS
PQH_WORKSHEET_PERIODS.WORKSHEET_DETAIL_ID PQH_WORKSHEET_DETAILS

[top of page]

HR.PQH_WORKSHEET_DETAILS does not reference any database object

HR.PQH_WORKSHEET_DETAILS is referenced by following:

APPS
SYNONYM - PQH_WORKSHEET_DETAILS
TRIGGER - PQH_WORKSHEET_DETAILS_WHO
PUBLIC
SYNONYM - PQH_WORKSHEET_DETAILS

[top of page]

Table: PQH_WORKSHEET_DETAILS_EFC

Description: This is a Copy of PQH_WORKSHEET_DETAILS table populated by EFC (Euro as functinoal currency) process.
Primary Key: PQH_WORKSHEET_DETAILS_EFC_PK
  1. WORKSHEET_DETAIL_ID
  2. EFC_ACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_WORKSHEET_DETAILS_EFC.EFC_ACTION_ID HR_EFC_ACTIONS

[top of page]

HR.PQH_WORKSHEET_DETAILS_EFC does not reference any database object

HR.PQH_WORKSHEET_DETAILS_EFC is referenced by following:

APPS
SYNONYM - PQH_WORKSHEET_DETAILS_EFC
PUBLIC
SYNONYM - PQH_WORKSHEET_DETAILS_EFC

[top of page]

Table: PQH_WORKSHEET_FUND_SRCS

Description: cost allocation for the budget element
Primary Key: PQH_WORKSHEET_FUND_SRCS_PK
  1. WORKSHEET_FUND_SRC_ID
Primary Key: PQH_WORKSHEET_FUND_SRCS_UK
  1. WORKSHEET_BDGT_ELMNT_ID
  2. COST_ALLOCATION_KEYFLEX_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_WORKSHEET_FUND_SRCS.WORKSHEET_BDGT_ELMNT_ID PQH_WORKSHEET_BDGT_ELMNTS
PQH_WORKSHEET_FUND_SRCS.COST_ALLOCATION_KEYFLEX_ID PAY_COST_ALLOCATION_KEYFLEX

[top of page]

HR.PQH_WORKSHEET_FUND_SRCS does not reference any database object

HR.PQH_WORKSHEET_FUND_SRCS is referenced by following:

APPS
SYNONYM - PQH_WORKSHEET_FUND_SRCS
TRIGGER - PQH_WORKSHEET_FUND_SRCS_WHO
PUBLIC
SYNONYM - PQH_WORKSHEET_FUND_SRCS

[top of page]

Table: PQH_WORKSHEET_PERIODS

Description: Period wise details of transaction data for budget version
Primary Key: PQH_WORKSHEET_PERIODS_PK
  1. WORKSHEET_PERIOD_ID
Primary Key: PQH_WORKSHEET_PERIODS_UK
  1. START_TIME_PERIOD_ID
  2. END_TIME_PERIOD_ID
  3. WORKSHEET_DETAIL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_WORKSHEET_PERIODS.WORKSHEET_DETAIL_ID PQH_WORKSHEET_DETAILS
PQH_WORKSHEET_PERIODS.START_TIME_PERIOD_ID PER_TIME_PERIODS
PQH_WORKSHEET_PERIODS.END_TIME_PERIOD_ID PER_TIME_PERIODS
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQH_WORKSHEET_BUDGET_SETS.WORKSHEET_PERIOD_ID PQH_WORKSHEET_PERIODS

[top of page]

HR.PQH_WORKSHEET_PERIODS does not reference any database object

HR.PQH_WORKSHEET_PERIODS is referenced by following:

APPS
SYNONYM - PQH_WORKSHEET_PERIODS
TRIGGER - PQH_WORKSHEET_PERIODS_WHO
PUBLIC
SYNONYM - PQH_WORKSHEET_PERIODS

[top of page]

Table: PQH_WORKSHEET_PERIODS_EFC

Description: This is a Copy of PQH_WORKSHEET_PERIODS table populated by EFC (Euro as functinoal currency) process.
Primary Key: PQH_WORKSHEET_PERIODS_EFC_PK
  1. WORKSHEET_PERIOD_ID
  2. EFC_ACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQH_WORKSHEET_PERIODS_EFC.EFC_ACTION_ID HR_EFC_ACTIONS

[top of page]

HR.PQH_WORKSHEET_PERIODS_EFC does not reference any database object

HR.PQH_WORKSHEET_PERIODS_EFC is referenced by following:

APPS
SYNONYM - PQH_WORKSHEET_PERIODS_EFC
PUBLIC
SYNONYM - PQH_WORKSHEET_PERIODS_EFC

[top of page]

View: PQH_ATTRIBUTES_VL

[top of page]

APPS.PQH_ATTRIBUTES_VL references the following:

APPS
SYNONYM - PQH_ATTRIBUTES
SYNONYM - PQH_ATTRIBUTES_TL
APPS.PQH_ATTRIBUTES_VL is referenced by following:

APPS
PACKAGE BODY - BEN_PLAN_DESIGN_TXNS_API
PACKAGE BODY - PQH_ATTRIBUTE_RANGES_PKG
PACKAGE BODY - PQH_GEN_FORM
PACKAGE BODY - PQH_REFRESH_DATA
VIEW - PQH_ROUTING_HIST_ATTRIBS_V
VIEW - PQH_SPECIAL_ATTRIBUTES_V
PACKAGE BODY - PQH_TAT_BUS
VIEW - PQH_TEMPLATE_ATTRIBUTES_V
PACKAGE BODY - PQH_TEM_BUS
VIEW - PQH_TXN_CATEGORY_ATTRIBUTES_V
PACKAGE BODY - PQH_UTILITY
PACKAGE BODY - PQH_WORKFLOW
PUBLIC
SYNONYM - PQH_ATTRIBUTES_VL

[top of page]

View: PQH_ATTRIBUTE_RANGES_V1

[top of page]

APPS.PQH_ATTRIBUTE_RANGES_V1 references the following:

APPS
SYNONYM - PQH_ATTRIBUTE_RANGES
APPS.PQH_ATTRIBUTE_RANGES_V1 is referenced by following:

PUBLIC
SYNONYM - PQH_ATTRIBUTE_RANGES_V1

[top of page]

View: PQH_ATTRIBUTE_RANGES_V2

[top of page]

APPS.PQH_ATTRIBUTE_RANGES_V2 references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - PQH_ATTRIBUTE_RANGES
VIEW - PQH_ROUTING_LIST_MEMBERS_V
PACKAGE - PQH_UTILITY
APPS.PQH_ATTRIBUTE_RANGES_V2 is referenced by following:

PUBLIC
SYNONYM - PQH_ATTRIBUTE_RANGES_V2

[top of page]

View: PQH_ATTRIBUTE_RANGES_V3

[top of page]

APPS.PQH_ATTRIBUTE_RANGES_V3 references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - PQH_ATTRIBUTE_RANGES
VIEW - PQH_ROUTING_LIST_MEMBERS_V
PACKAGE - PQH_TCT_WIZARD_PKG
APPS.PQH_ATTRIBUTE_RANGES_V3 is referenced by following:

APPS
PACKAGE BODY - PQH_TCT_WIZARD_PKG
PUBLIC
SYNONYM - PQH_ATTRIBUTE_RANGES_V3

[top of page]

View: PQH_ATTRIBUTE_RANGES_V4

[top of page]

APPS.PQH_ATTRIBUTE_RANGES_V4 references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - PQH_ATTRIBUTE_RANGES
VIEW - PQH_ROUTING_LIST_MEMBERS_V
PACKAGE - PQH_TCT_WIZARD_PKG
APPS.PQH_ATTRIBUTE_RANGES_V4 is referenced by following:

PUBLIC
SYNONYM - PQH_ATTRIBUTE_RANGES_V4

[top of page]

View: PQH_BDGT_CMMTMNT_ELMNTS_V

[top of page]

APPS.PQH_BDGT_CMMTMNT_ELMNTS_V references the following:

APPS
VIEW - FF_FORMULAS_F_V
PACKAGE - FND_GLOBAL
PACKAGE - HR_API
PACKAGE - HR_CHKFMT
PACKAGE - HR_GENERAL
VIEW - HR_LOOKUPS
SYNONYM - PAY_BALANCE_TYPES
VIEW - PAY_ELEMENT_TYPES_V
PACKAGE - PAY_INPUT_VALUES_PKG
VIEW - PAY_INPUT_VALUES_V
SYNONYM - PQH_BDGT_CMMTMNT_ELMNTS
SYNONYM - PQH_BUDGETS
APPS.PQH_BDGT_CMMTMNT_ELMNTS_V is referenced by following:

PUBLIC
SYNONYM - PQH_BDGT_CMMTMNT_ELMNTS_V

[top of page]

View: PQH_BDGT_POOL_REALLOCTIONS_V

[top of page]

APPS.PQH_BDGT_POOL_REALLOCTIONS_V references the following:

APPS
SYNONYM - HR_ALL_POSITIONS_F_TL
SYNONYM - PQH_BDGT_POOL_REALLOCTIONS
SYNONYM - PQH_BUDGET_POOLS
APPS.PQH_BDGT_POOL_REALLOCTIONS_V is referenced by following:

PUBLIC
SYNONYM - PQH_BDGT_POOL_REALLOCTIONS_V

[top of page]

View: PQH_BDGT_REALLOC_FOLDERS_V

[top of page]

APPS.PQH_BDGT_REALLOC_FOLDERS_V references the following:

APPS
SYNONYM - PQH_BUDGET_POOLS
APPS.PQH_BDGT_REALLOC_FOLDERS_V is referenced by following:

PUBLIC
SYNONYM - PQH_BDGT_REALLOC_FOLDERS_V

[top of page]

View: PQH_BUDGETS_V

[top of page]

APPS.PQH_BUDGETS_V references the following:

APPS
VIEW - GL_SETS_OF_BOOKS
PACKAGE - HR_GENERAL
VIEW - PAY_CALENDARS_V
SYNONYM - PER_ORGANIZATION_STRUCTURES
SYNONYM - PER_ORG_STRUCTURE_VERSIONS
VIEW - PER_SHARED_TYPES_VL
SYNONYM - PQH_BUDGETS
SYNONYM - PQH_DFLT_BUDGET_SETS
PACKAGE - PQH_UTILITY
APPS.PQH_BUDGETS_V is referenced by following:

APPS
VIEW - HRFV_WORKFORCE_BUDGETS
VIEW - PQH_BUDGET_DETAILS_V
VIEW - PQH_ORGANIZATION_BUDGETS_V
VIEW - PQH_PC_ORG_SUMMARY_V
VIEW - PQH_POSITION_BUDGETS_V
VIEW - PQH_POSITION_ELEMENT_TYPES_V
PUBLIC
SYNONYM - PQH_BUDGETS_V

[top of page]

View: PQH_BUDGET_DETAILS_V

[top of page]

APPS.PQH_BUDGET_DETAILS_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - PER_TIME_PERIODS
VIEW - PQH_BUDGETS_V
SYNONYM - PQH_BUDGET_DETAILS
SYNONYM - PQH_BUDGET_PERIODS
SYNONYM - PQH_BUDGET_VERSIONS
PACKAGE - PQH_MGMT_RPT_PKG
PACKAGE - PQH_UTILITY
APPS.PQH_BUDGET_DETAILS_V is referenced by following:

PUBLIC
SYNONYM - PQH_BUDGET_DETAILS_V

[top of page]

View: PQH_BUDGET_POOLS_V

[top of page]

APPS.PQH_BUDGET_POOLS_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - PQH_BUDGET_POOLS
APPS.PQH_BUDGET_POOLS_V is referenced by following:

PUBLIC
SYNONYM - PQH_BUDGET_POOLS_V

[top of page]

View: PQH_CMMTMNT_ENTITIES_V

[top of page]

APPS.PQH_CMMTMNT_ENTITIES_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - PQH_BUDGETS
SYNONYM - PQH_BUDGET_DETAILS
SYNONYM - PQH_BUDGET_VERSIONS
APPS.PQH_CMMTMNT_ENTITIES_V is referenced by following:

APPS
PACKAGE BODY - PQH_COMMITMENT_PKG
VIEW - PQH_ENTITY_ELEMENT_TYPES_V
PUBLIC
SYNONYM - PQH_CMMTMNT_ENTITIES_V

[top of page]

View: PQH_COPY_ENTITY_CONTEXTS_V

[top of page]

APPS.PQH_COPY_ENTITY_CONTEXTS_V references the following:

APPS
VIEW - FND_APPLICATION_VL
VIEW - FND_RESPONSIBILITY_VL
VIEW - FND_TERRITORIES_VL
SYNONYM - PQH_COPY_ENTITY_CONTEXTS
VIEW - PQH_TRANSACTION_CATEGORIES_VL
APPS.PQH_COPY_ENTITY_CONTEXTS_V is referenced by following:

PUBLIC
SYNONYM - PQH_COPY_ENTITY_CONTEXTS_V

[top of page]

View: PQH_COPY_ENTITY_POSITIONS_V

[top of page]

APPS.PQH_COPY_ENTITY_POSITIONS_V references the following:

APPS
PACKAGE - FND_DATE
SYNONYM - PQH_COPY_ENTITY_RESULTS
APPS.PQH_COPY_ENTITY_POSITIONS_V is referenced by following:

PUBLIC
SYNONYM - PQH_COPY_ENTITY_POSITIONS_V

[top of page]

View: PQH_COPY_ENTITY_POSUPD_V

[top of page]

APPS.PQH_COPY_ENTITY_POSUPD_V references the following:

APPS
PACKAGE - FND_DATE
SYNONYM - PQH_COPY_ENTITY_RESULTS
APPS.PQH_COPY_ENTITY_POSUPD_V is referenced by following:

PUBLIC
SYNONYM - PQH_COPY_ENTITY_POSUPD_V

[top of page]

View: PQH_COPY_ENTITY_PREFS_V

[top of page]

APPS.PQH_COPY_ENTITY_PREFS_V references the following:

APPS
SYNONYM - PQH_COPY_ENTITY_PREFS
SYNONYM - PQH_TABLE_ROUTE
APPS.PQH_COPY_ENTITY_PREFS_V is referenced by following:

PUBLIC
SYNONYM - PQH_COPY_ENTITY_PREFS_V

[top of page]

View: PQH_CORPS_CAREER_PATHS_V

[top of page]

APPS.PQH_CORPS_CAREER_PATHS_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - PER_GEN_HIERARCHY_NODES
PACKAGE - PQH_CORPS_COPY
SYNONYM - PQH_CORPS_DEFINITIONS
APPS.PQH_CORPS_CAREER_PATHS_V is referenced by following:

PUBLIC
SYNONYM - PQH_CORPS_CAREER_PATHS_V

[top of page]

View: PQH_CORPS_DEFINITIONS_V

[top of page]

APPS.PQH_CORPS_DEFINITIONS_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - PER_GRADES_TL
VIEW - PER_GRADE_SPINES
SYNONYM - PER_PARENT_SPINES
SYNONYM - PER_SPINAL_POINTS
VIEW - PER_SPINAL_POINT_STEPS
SYNONYM - PQH_CORPS_DEFINITIONS
APPS.PQH_CORPS_DEFINITIONS_V is referenced by following:

PUBLIC
SYNONYM - PQH_CORPS_DEFINITIONS_V

[top of page]

View: PQH_CORPS_DOCUMENTS_V

[top of page]

APPS.PQH_CORPS_DOCUMENTS_V references the following:

APPS
PACKAGE - FND_DATE
PACKAGE - HR_GENERAL
SYNONYM - PQH_CORPS_EXTRA_INFO
APPS.PQH_CORPS_DOCUMENTS_V is referenced by following:

PUBLIC
SYNONYM - PQH_CORPS_DOCUMENTS_V

[top of page]

View: PQH_CORPS_EXAMS_V

[top of page]

APPS.PQH_CORPS_EXAMS_V references the following:

APPS
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
SYNONYM - PQH_CORPS_EXTRA_INFO
APPS.PQH_CORPS_EXAMS_V is referenced by following:

PUBLIC
SYNONYM - PQH_CORPS_EXAMS_V

[top of page]

View: PQH_CORPS_FILERES_V

[top of page]

APPS.PQH_CORPS_FILERES_V references the following:

APPS
PACKAGE - FND_NUMBER
PACKAGE - HR_GENERAL
SYNONYM - PQH_CORPS_EXTRA_INFO
APPS.PQH_CORPS_FILERES_V is referenced by following:

PUBLIC
SYNONYM - PQH_CORPS_FILERES_V

[top of page]

View: PQH_CORPS_GRADES_V

[top of page]

APPS.PQH_CORPS_GRADES_V references the following:

APPS
SYNONYM - PER_GRADES_TL
SYNONYM - PQH_CORPS_EXTRA_INFO
APPS.PQH_CORPS_GRADES_V is referenced by following:

PUBLIC
SYNONYM - PQH_CORPS_GRADES_V

[top of page]

View: PQH_CORPS_NATURE_HGRID_V

[top of page]

APPS.PQH_CORPS_NATURE_HGRID_V references the following:

PUBLIC
SYNONYM - DUAL
- DUAL
APPS.PQH_CORPS_NATURE_HGRID_V is referenced by following:

PUBLIC
SYNONYM - PQH_CORPS_NATURE_HGRID_V

[top of page]

View: PQH_CORPS_ORGANIZATIONS_V

[top of page]

APPS.PQH_CORPS_ORGANIZATIONS_V references the following:

APPS
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
SYNONYM - PQH_CORPS_EXTRA_INFO
APPS.PQH_CORPS_ORGANIZATIONS_V is referenced by following:

PUBLIC
SYNONYM - PQH_CORPS_ORGANIZATIONS_V

[top of page]

View: PQH_CORPS_RULES_V

[top of page]

APPS.PQH_CORPS_RULES_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - PQH_CORPS_EXTRA_INFO
APPS.PQH_CORPS_RULES_V is referenced by following:

PUBLIC
SYNONYM - PQH_CORPS_RULES_V

[top of page]

View: PQH_CORPS_TRAININGS_V

[top of page]

APPS.PQH_CORPS_TRAININGS_V references the following:

APPS
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
SYNONYM - PER_QUALIFICATION_TYPES_TL
SYNONYM - PQH_CORPS_EXTRA_INFO
APPS.PQH_CORPS_TRAININGS_V is referenced by following:

PUBLIC
SYNONYM - PQH_CORPS_TRAININGS_V

[top of page]

View: PQH_DE_CS_GRADES_V

[top of page]

APPS.PQH_DE_CS_GRADES_V references the following:

APPS
SYNONYM - PER_GEN_HIERARCHY
SYNONYM - PER_GEN_HIERARCHY_NODES
SYNONYM - PER_GEN_HIERARCHY_VERSIONS
APPS.PQH_DE_CS_GRADES_V is referenced by following:

PUBLIC
SYNONYM - PQH_DE_CS_GRADES_V

[top of page]

View: PQH_ENTITY_ELEMENT_TYPES_V

[top of page]

APPS.PQH_ENTITY_ELEMENT_TYPES_V references the following:

APPS
PACKAGE - HR_GENERAL
VIEW - PAY_ELEMENT_TYPES
SYNONYM - PQH_BUDGET_ELEMENTS
SYNONYM - PQH_BUDGET_PERIODS
SYNONYM - PQH_BUDGET_SETS
VIEW - PQH_CMMTMNT_ENTITIES_V
APPS.PQH_ENTITY_ELEMENT_TYPES_V is referenced by following:

PUBLIC
SYNONYM - PQH_ENTITY_ELEMENT_TYPES_V

[top of page]

View: PQH_FR_CAGR_ENTITLEMENTS_V

[top of page]

APPS.PQH_FR_CAGR_ENTITLEMENTS_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - PER_ALL_ASSIGNMENTS_F
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - PER_CAGR_ENTITLEMENT_ITEMS
SYNONYM - PER_CAGR_ENTITLEMENT_RESULTS
APPS.PQH_FR_CAGR_ENTITLEMENTS_V is referenced by following:

PUBLIC
SYNONYM - PQH_FR_CAGR_ENTITLEMENTS_V

[top of page]

View: PQH_FR_STAT_SITUATIONS_V

[top of page]

APPS.PQH_FR_STAT_SITUATIONS_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - PQH_FR_STAT_SITUATIONS
PACKAGE - PQH_FR_STAT_SIT_UTIL
APPS.PQH_FR_STAT_SITUATIONS_V is referenced by following:

APPS
PACKAGE BODY - PQH_FR_ASSIGNMENT_CHK
PACKAGE BODY - PQH_FR_EMP_STAT_SIT_UTILITY
PACKAGE BODY - PQH_FR_STAT_SIT_UTIL
PACKAGE BODY - PQH_FR_UTILITY
PACKAGE BODY - PQH_PSU_BUS
PUBLIC
SYNONYM - PQH_FR_STAT_SITUATIONS_V

[top of page]

View: PQH_INFO_TYPE_SECURITY_RIT_V

[top of page]

APPS.PQH_INFO_TYPE_SECURITY_RIT_V references the following:

APPS
SYNONYM - PER_INFO_TYPE_SECURITY
SYNONYM - PQH_ROLE_INFO_TYPES
APPS.PQH_INFO_TYPE_SECURITY_RIT_V is referenced by following:

PUBLIC
SYNONYM - PQH_INFO_TYPE_SECURITY_RIT_V

[top of page]

View: PQH_ORGANIZATION_BUDGETS_V

[top of page]

APPS.PQH_ORGANIZATION_BUDGETS_V references the following:

APPS
PACKAGE - HR_GENERAL
VIEW - PQH_BUDGETS_V
SYNONYM - PQH_BUDGET_DETAILS
SYNONYM - PQH_BUDGET_VERSIONS
PACKAGE - PQH_UTILITY
APPS.PQH_ORGANIZATION_BUDGETS_V is referenced by following:

PUBLIC
SYNONYM - PQH_ORGANIZATION_BUDGETS_V

[top of page]

View: PQH_PC_ORG_HIERARCHIES_V

[top of page]

APPS.PQH_PC_ORG_HIERARCHIES_V references the following:

APPS
SYNONYM - FND_SESSIONS
PACKAGE - HR_GENERAL
SYNONYM - PER_ORGANIZATION_STRUCTURES
SYNONYM - PER_ORG_STRUCTURE_ELEMENTS
SYNONYM - PER_ORG_STRUCTURE_VERSIONS
PACKAGE - PQH_PSF_BUS
APPS.PQH_PC_ORG_HIERARCHIES_V is referenced by following:

PUBLIC
SYNONYM - PQH_PC_ORG_HIERARCHIES_V

[top of page]

View: PQH_PC_ORG_SUMMARY_V

[top of page]

APPS.PQH_PC_ORG_SUMMARY_V references the following:

APPS
PACKAGE - FND_PROFILE
PACKAGE - HR_GENERAL
VIEW - PQH_BUDGETS_V
SYNONYM - PQH_BUDGET_DETAILS
SYNONYM - PQH_BUDGET_VERSIONS
VIEW - PQH_POSN_CTL_HIERARCHY_V
PACKAGE - PQH_PSF_BUS
PACKAGE - PQH_UTILITY
APPS.PQH_PC_ORG_SUMMARY_V is referenced by following:

PUBLIC
SYNONYM - PQH_PC_ORG_SUMMARY_V

[top of page]

View: PQH_POSITION_BUDGETS_V

[top of page]

APPS.PQH_POSITION_BUDGETS_V references the following:

APPS
PACKAGE - HR_GENERAL
VIEW - PAY_ELEMENT_TYPES
VIEW - PQH_BUDGETS_V
SYNONYM - PQH_BUDGET_DETAILS
SYNONYM - PQH_BUDGET_ELEMENTS
SYNONYM - PQH_BUDGET_PERIODS
SYNONYM - PQH_BUDGET_SETS
SYNONYM - PQH_BUDGET_VERSIONS
PACKAGE - PQH_UTILITY
APPS.PQH_POSITION_BUDGETS_V is referenced by following:

PUBLIC
SYNONYM - PQH_POSITION_BUDGETS_V

[top of page]

View: PQH_POSITION_ELEMENT_TYPES_V

[top of page]

APPS.PQH_POSITION_ELEMENT_TYPES_V references the following:

APPS
PACKAGE - HR_GENERAL
VIEW - PAY_ELEMENT_TYPES
VIEW - PQH_BUDGETS_V
SYNONYM - PQH_BUDGET_DETAILS
SYNONYM - PQH_BUDGET_ELEMENTS
SYNONYM - PQH_BUDGET_PERIODS
SYNONYM - PQH_BUDGET_SETS
SYNONYM - PQH_BUDGET_VERSIONS
PACKAGE - PQH_UTILITY
APPS.PQH_POSITION_ELEMENT_TYPES_V is referenced by following:

PUBLIC
SYNONYM - PQH_POSITION_ELEMENT_TYPES_V

[top of page]

View: PQH_POSITION_EXTRA_INFO_V

[top of page]

APPS.PQH_POSITION_EXTRA_INFO_V references the following:

APPS
SYNONYM - PER_POSITION_EXTRA_INFO
APPS.PQH_POSITION_EXTRA_INFO_V is referenced by following:

PUBLIC
SYNONYM - PQH_POSITION_EXTRA_INFO_V

[top of page]

View: PQH_POSITION_ROLES_V

[top of page]

APPS.PQH_POSITION_ROLES_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - PER_POSITION_EXTRA_INFO
APPS.PQH_POSITION_ROLES_V is referenced by following:

APPS
PACKAGE BODY - PQH_RLS_BUS
PACKAGE BODY - PQH_WF
PUBLIC
SYNONYM - PQH_POSITION_ROLES_V

[top of page]

View: PQH_POSITION_TRANSACTIONS_V

[top of page]

APPS.PQH_POSITION_TRANSACTIONS_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - PQH_POSITION_TRANSACTIONS
PACKAGE - PQH_UTILITY
APPS.PQH_POSITION_TRANSACTIONS_V is referenced by following:

PUBLIC
SYNONYM - PQH_POSITION_TRANSACTIONS_V

[top of page]

View: PQH_POSN_CTL_HIERARCHY_V

[top of page]

APPS.PQH_POSN_CTL_HIERARCHY_V references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - HR_ALL_ORGANIZATION_UNITS
PACKAGE - HR_GENERAL
SYNONYM - PER_ORG_STRUCTURE_ELEMENTS
PACKAGE - PQH_PSF_BUS
APPS.PQH_POSN_CTL_HIERARCHY_V is referenced by following:

APPS
VIEW - PQH_PC_ORG_SUMMARY_V
PUBLIC
SYNONYM - PQH_POSN_CTL_HIERARCHY_V

[top of page]

View: PQH_PTX_HISTORY_V

[top of page]

APPS.PQH_PTX_HISTORY_V references the following:

APPS
SYNONYM - HR_ALL_POSITIONS_F
SYNONYM - HR_ALL_POSITIONS_F_TL
PACKAGE - HR_GENERAL
SYNONYM - PER_DEPLOYMENT_FACTORS
SYNONYM - PQH_POSITION_TRANSACTIONS
PACKAGE - PQH_UTILITY
APPS.PQH_PTX_HISTORY_V is referenced by following:

PUBLIC
SYNONYM - PQH_PTX_HISTORY_V

[top of page]

View: PQH_REALLOC_FOLDER_TXN_V

[top of page]

APPS.PQH_REALLOC_FOLDER_TXN_V references the following:

APPS
SYNONYM - PQH_BUDGET_POOLS
APPS.PQH_REALLOC_FOLDER_TXN_V is referenced by following:

PUBLIC
SYNONYM - PQH_REALLOC_FOLDER_TXN_V

[top of page]

View: PQH_REALLOC_TXN_DETAILS_V

[top of page]

APPS.PQH_REALLOC_TXN_DETAILS_V references the following:

APPS
SYNONYM - PQH_BDGT_POOL_REALLOCTIONS
SYNONYM - PQH_BUDGET_POOLS
APPS.PQH_REALLOC_TXN_DETAILS_V is referenced by following:

APPS
PACKAGE BODY - PQH_BDGT_REALLOC_UTILITY
PUBLIC
SYNONYM - PQH_REALLOC_TXN_DETAILS_V

[top of page]

View: PQH_REALLOC_TXN_PERIODS_V

[top of page]

APPS.PQH_REALLOC_TXN_PERIODS_V references the following:

APPS
SYNONYM - PQH_BDGT_POOL_REALLOCTIONS
APPS.PQH_REALLOC_TXN_PERIODS_V is referenced by following:

PUBLIC
SYNONYM - PQH_REALLOC_TXN_PERIODS_V

[top of page]

View: PQH_REF_TEMPLATES_V

[top of page]

APPS.PQH_REF_TEMPLATES_V references the following:

APPS
PACKAGE - FND_GLOBAL
PACKAGE - HR_API
VIEW - HR_LOOKUPS
SYNONYM - PQH_REF_TEMPLATES
VIEW - PQH_TEMPLATES_VL
APPS.PQH_REF_TEMPLATES_V is referenced by following:

PUBLIC
SYNONYM - PQH_REF_TEMPLATES_V

[top of page]

View: PQH_ROLES_V

[top of page]

APPS.PQH_ROLES_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - PQH_ROLES
APPS.PQH_ROLES_V is referenced by following:

PUBLIC
SYNONYM - PQH_ROLES_V

[top of page]

View: PQH_ROLE_PEOPLE_V

[top of page]

APPS.PQH_ROLE_PEOPLE_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - PER_PEOPLE_EXTRA_INFO
VIEW - PER_PEOPLE_X
SYNONYM - PQH_ROLES
APPS.PQH_ROLE_PEOPLE_V is referenced by following:

PUBLIC
SYNONYM - PQH_ROLE_PEOPLE_V

[top of page]

View: PQH_ROLE_TEMPLATES_V

[top of page]

APPS.PQH_ROLE_TEMPLATES_V references the following:

APPS
SYNONYM - PQH_ROLE_TEMPLATES
SYNONYM - PQH_TEMPLATES
SYNONYM - PQH_TRANSACTION_CATEGORIES
APPS.PQH_ROLE_TEMPLATES_V is referenced by following:

PUBLIC
SYNONYM - PQH_ROLE_TEMPLATES_V

[top of page]

View: PQH_ROLE_USERS_V

[top of page]

APPS.PQH_ROLE_USERS_V references the following:

APPS
SYNONYM - FND_SESSIONS
SYNONYM - FND_USER
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - PER_PEOPLE_EXTRA_INFO
SYNONYM - PQH_ROLES
APPS.PQH_ROLE_USERS_V is referenced by following:

APPS
PACKAGE BODY - PQH_RCT_BUS
PACKAGE BODY - PQH_RLM_BUS
PACKAGE BODY - PQH_RLS_BUS
PACKAGE BODY - PQH_WF
PUBLIC
SYNONYM - PQH_ROLE_USERS_V

[top of page]

View: PQH_ROLE_USERS_V1

[top of page]

APPS.PQH_ROLE_USERS_V1 references the following:

APPS
SYNONYM - FND_SESSIONS
SYNONYM - FND_USER
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - PER_PEOPLE_EXTRA_INFO
SYNONYM - PQH_ROLES
APPS.PQH_ROLE_USERS_V1 is referenced by following:

PUBLIC
SYNONYM - PQH_ROLE_USERS_V1

[top of page]

View: PQH_ROUTING_CATEGORIES_V

[top of page]

APPS.PQH_ROUTING_CATEGORIES_V references the following:

APPS
SYNONYM - FND_USER
VIEW - HR_ALL_POSITIONS
PACKAGE - HR_GENERAL
SYNONYM - PER_POSITION_STRUCTURES
SYNONYM - PQH_ROLES
SYNONYM - PQH_ROUTING_CATEGORIES
SYNONYM - PQH_ROUTING_LISTS
PACKAGE - PQH_TCT_WIZARD_PKG
APPS.PQH_ROUTING_CATEGORIES_V is referenced by following:

APPS
PACKAGE BODY - PQH_TCT_WIZARD_PKG
PUBLIC
SYNONYM - PQH_ROUTING_CATEGORIES_V

[top of page]

View: PQH_ROUTING_HISTORY_V

[top of page]

APPS.PQH_ROUTING_HISTORY_V references the following:

APPS
SYNONYM - FND_USER
PACKAGE - HR_GENERAL
SYNONYM - PQH_ROLES
SYNONYM - PQH_ROUTING_HISTORY
SYNONYM - PQH_ROUTING_LIST_MEMBERS
PACKAGE - PQH_WF
APPS.PQH_ROUTING_HISTORY_V is referenced by following:

APPS
PACKAGE BODY - PQH_BUDGET
PUBLIC
SYNONYM - PQH_ROUTING_HISTORY_V

[top of page]

View: PQH_ROUTING_HIST_ATTRIBS_V

[top of page]

APPS.PQH_ROUTING_HIST_ATTRIBS_V references the following:

APPS
PACKAGE - FND_DATE
VIEW - PQH_ATTRIBUTES_VL
SYNONYM - PQH_ROUTING_HIST_ATTRIBS
APPS.PQH_ROUTING_HIST_ATTRIBS_V is referenced by following:

PUBLIC
SYNONYM - PQH_ROUTING_HIST_ATTRIBS_V

[top of page]

View: PQH_ROUTING_LIST_MEMBERS_V

[top of page]

APPS.PQH_ROUTING_LIST_MEMBERS_V references the following:

APPS
SYNONYM - FND_USER
SYNONYM - PQH_ROLES
SYNONYM - PQH_ROUTING_LIST_MEMBERS
APPS.PQH_ROUTING_LIST_MEMBERS_V is referenced by following:

APPS
VIEW - PQH_ATTRIBUTE_RANGES_V2
VIEW - PQH_ATTRIBUTE_RANGES_V3
VIEW - PQH_ATTRIBUTE_RANGES_V4
PUBLIC
SYNONYM - PQH_ROUTING_LIST_MEMBERS_V

[top of page]

View: PQH_RULES_V

[top of page]

APPS.PQH_RULES_V references the following:

APPS
SYNONYM - FND_NEW_MESSAGES
SYNONYM - PQH_RULES
APPS.PQH_RULES_V is referenced by following:

PUBLIC
SYNONYM - PQH_RULES_V

[top of page]

View: PQH_RULE_SETS_V

[top of page]

APPS.PQH_RULE_SETS_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - HR_ALL_ORGANIZATION_UNITS
PACKAGE - HR_API
VIEW - HR_LOOKUPS
VIEW - PER_BUSINESS_GROUPS
SYNONYM - PER_ORGANIZATION_STRUCTURES
VIEW - PQH_RULE_SETS_VL
APPS.PQH_RULE_SETS_V is referenced by following:

PUBLIC
SYNONYM - PQH_RULE_SETS_V

[top of page]

View: PQH_RULE_SETS_VL

[top of page]

APPS.PQH_RULE_SETS_VL references the following:

APPS
SYNONYM - PQH_RULE_SETS
SYNONYM - PQH_RULE_SETS_TL
APPS.PQH_RULE_SETS_VL is referenced by following:

APPS
PACKAGE BODY - PQH_RST_BUS
VIEW - PQH_RULE_SETS_V
PACKAGE BODY - PQH_UTILITY
PUBLIC
SYNONYM - PQH_RULE_SETS_VL

[top of page]

View: PQH_SPECIAL_ATTRIBUTES_V

[top of page]

APPS.PQH_SPECIAL_ATTRIBUTES_V references the following:

APPS
VIEW - PQH_ATTRIBUTES_VL
PACKAGE - PQH_CONTEXT
SYNONYM - PQH_COPY_ENTITY_CONTEXTS
SYNONYM - PQH_SPECIAL_ATTRIBUTES
VIEW - PQH_TABLE_ROUTE_VL
SYNONYM - PQH_TXN_CATEGORY_ATTRIBUTES
APPS.PQH_SPECIAL_ATTRIBUTES_V is referenced by following:

PUBLIC
SYNONYM - PQH_SPECIAL_ATTRIBUTES_V

[top of page]

View: PQH_TABLE_ROUTE_VL

[top of page]

APPS.PQH_TABLE_ROUTE_VL references the following:

APPS
SYNONYM - PQH_TABLE_ROUTE
SYNONYM - PQH_TABLE_ROUTE_TL
APPS.PQH_TABLE_ROUTE_VL is referenced by following:

APPS
PACKAGE BODY - BEN_PD_COPY_TO_BEN_ONE
VIEW - BEN_PLAN_DESIGN_HGRID_VW
PACKAGE BODY - BEN_PLAN_DESIGN_TXNS_API
PACKAGE BODY - PQH_GSP_HR_TO_STAGE
PACKAGE BODY - PQH_GSP_PRGRULES
VIEW - PQH_SPECIAL_ATTRIBUTES_V
PUBLIC
SYNONYM - PQH_TABLE_ROUTE_VL

[top of page]

View: PQH_TEMPLATES_V

[top of page]

APPS.PQH_TEMPLATES_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_TERRITORIES_VL
PACKAGE - HR_API
VIEW - HR_LOOKUPS
VIEW - PQH_TEMPLATES_VL
VIEW - PQH_TRANSACTION_CATEGORIES_VL
APPS.PQH_TEMPLATES_V is referenced by following:

PUBLIC
SYNONYM - PQH_TEMPLATES_V

[top of page]

View: PQH_TEMPLATES_VL

[top of page]

APPS.PQH_TEMPLATES_VL references the following:

APPS
SYNONYM - PQH_TEMPLATES
SYNONYM - PQH_TEMPLATES_TL
APPS.PQH_TEMPLATES_VL is referenced by following:

APPS
VIEW - PQH_REF_TEMPLATES_V
PACKAGE BODY - PQH_RFT_BUS
PACKAGE BODY - PQH_RFT_SHD
PACKAGE BODY - PQH_TAT_BUS
PACKAGE BODY - PQH_TAT_SHD
VIEW - PQH_TEMPLATES_V
PACKAGE BODY - PQH_TEM_BUS
PUBLIC
SYNONYM - PQH_TEMPLATES_VL

[top of page]

View: PQH_TEMPLATE_ATTRIBUTES_V

[top of page]

APPS.PQH_TEMPLATE_ATTRIBUTES_V references the following:

APPS
VIEW - PQH_ATTRIBUTES_VL
SYNONYM - PQH_TEMPLATES
SYNONYM - PQH_TEMPLATE_ATTRIBUTES
SYNONYM - PQH_TXN_CATEGORY_ATTRIBUTES
APPS.PQH_TEMPLATE_ATTRIBUTES_V is referenced by following:

PUBLIC
SYNONYM - PQH_TEMPLATE_ATTRIBUTES_V

[top of page]

View: PQH_TRANSACTIONS_V

[top of page]

APPS.PQH_TRANSACTIONS_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - PQH_POSITION_TRANSACTIONS
SYNONYM - PQH_TRANSACTION_CATEGORIES
PACKAGE - PQH_WF
PACKAGE - PQH_WKS_BUDGET
SYNONYM - PQH_WORKSHEETS
SYNONYM - PQH_WORKSHEET_DETAILS
APPS.PQH_TRANSACTIONS_V is referenced by following:

PUBLIC
SYNONYM - PQH_TRANSACTIONS_V

[top of page]

View: PQH_TRANSACTION_CATEGORIES_V

[top of page]

APPS.PQH_TRANSACTION_CATEGORIES_V references the following:

APPS
PACKAGE - FND_GLOBAL
PACKAGE - HR_API
VIEW - HR_LOOKUPS
SYNONYM - PQH_TABLE_ROUTE
VIEW - PQH_TRANSACTION_CATEGORIES_VL
APPS.PQH_TRANSACTION_CATEGORIES_V is referenced by following:

PUBLIC
SYNONYM - PQH_TRANSACTION_CATEGORIES_V

[top of page]

View: PQH_TRANSACTION_CATEGORIES_VL

[top of page]

APPS.PQH_TRANSACTION_CATEGORIES_VL references the following:

APPS
SYNONYM - PQH_TRANSACTION_CATEGORIES
SYNONYM - PQH_TRANSACTION_CATEGORIES_TL
APPS.PQH_TRANSACTION_CATEGORIES_VL is referenced by following:

APPS
VIEW - PQH_COPY_ENTITY_CONTEXTS_V
PACKAGE BODY - PQH_CTL_UPD
PACKAGE BODY - PQH_GENERIC
PACKAGE BODY - PQH_GEN_FORM
PACKAGE BODY - PQH_RLM_BUS
PACKAGE BODY - PQH_RLT_BUS
PACKAGE BODY - PQH_TCT_SHD
PACKAGE BODY - PQH_TCT_WIZARD_PKG
VIEW - PQH_TEMPLATES_V
PACKAGE BODY - PQH_TEM_BUS
VIEW - PQH_TRANSACTION_CATEGORIES_V
PUBLIC
SYNONYM - PQH_TRANSACTION_CATEGORIES_VL

[top of page]

View: PQH_TRANSACTION_TEMPLATES_V

[top of page]

APPS.PQH_TRANSACTION_TEMPLATES_V references the following:

APPS
SYNONYM - PQH_TEMPLATES
SYNONYM - PQH_TRANSACTION_TEMPLATES
APPS.PQH_TRANSACTION_TEMPLATES_V is referenced by following:

PUBLIC
SYNONYM - PQH_TRANSACTION_TEMPLATES_V

[top of page]

View: PQH_TXN_CATEGORY_ATTRIBUTES_V

[top of page]

APPS.PQH_TXN_CATEGORY_ATTRIBUTES_V references the following:

APPS
PACKAGE - FND_GLOBAL
PACKAGE - HR_API
VIEW - HR_LOOKUPS
VIEW - PQH_ATTRIBUTES_VL
SYNONYM - PQH_TXN_CATEGORY_ATTRIBUTES
APPS.PQH_TXN_CATEGORY_ATTRIBUTES_V is referenced by following:

PUBLIC
SYNONYM - PQH_TXN_CATEGORY_ATTRIBUTES_V

[top of page]

View: PQH_TXN_JOB_REQUIREMENTS_V

[top of page]

APPS.PQH_TXN_JOB_REQUIREMENTS_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - PQH_TXN_JOB_REQUIREMENTS
APPS.PQH_TXN_JOB_REQUIREMENTS_V is referenced by following:

PUBLIC
SYNONYM - PQH_TXN_JOB_REQUIREMENTS_V

[top of page]

View: PQH_WORKSHEET_ORGANIZATIONS_V

[top of page]

APPS.PQH_WORKSHEET_ORGANIZATIONS_V references the following:

APPS
SYNONYM - PER_ORG_STRUCTURE_ELEMENTS
PACKAGE - PQH_BUDGET
APPS.PQH_WORKSHEET_ORGANIZATIONS_V is referenced by following:

APPS
PACKAGE BODY - PQH_BUDGET
PACKAGE BODY - PQH_WKS_BUDGET
PUBLIC
SYNONYM - PQH_WORKSHEET_ORGANIZATIONS_V

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract