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

TABLE - HR.PQP_ALIEN_STATE_TREATIES_F
TABLE - HR.PQP_ALIEN_TRANSACTION_DATA
TABLE - HR.PQP_ANALYZED_ALIEN_DATA
TABLE - HR.PQP_ANALYZED_ALIEN_DETAILS
TABLE - HR.PQP_ASSIGNMENT_ATTRIBUTES_F
TABLE - HR.PQP_CONFIGURATION_MODULES
TABLE - HR.PQP_CONFIGURATION_TYPES
TABLE - HR.PQP_CONFIGURATION_VALUES
TABLE - HR.PQP_EXCEPTION_REPORTS
TABLE - HR.PQP_EXCEPTION_REPORTS_TL
TABLE - HR.PQP_EXCEPTION_REPORT_GROUPS
TABLE - HR.PQP_EXCEPTION_REPORT_SUFFIX
TABLE - HR.PQP_EXTRACT_ATTRIBUTES
TABLE - HR.PQP_EXT_CROSS_PERSON_RECORDS
TABLE - HR.PQP_FLXDU_COLUMNS
TABLE - HR.PQP_FLXDU_FUNC_ATTRIBUTES
TABLE - HR.PQP_FLXDU_XML_TAGS
TABLE - HR.PQP_GAP_ABSENCE_PLANS
TABLE - HR.PQP_GAP_DAILY_ABSENCES
TABLE - HR.PQP_GAP_DURATION_SUMMARY
TABLE - HR.PQP_PENSION_TYPES_F
TABLE - HR.PQP_SERVICE_HISTORY_PERIODS
TABLE - HR.PQP_VEHICLE_ALLOCATIONS_F
TABLE - HR.PQP_VEHICLE_DETAILS
TABLE - HR.PQP_VEHICLE_DETAILS_EFC
TABLE - HR.PQP_VEHICLE_REPOSITORY_F
TABLE - HR.PQP_VEH_ALLOC_EXTRA_INFO
TABLE - HR.PQP_VEH_ALLOC_INFO_TYPES
TABLE - HR.PQP_VEH_REPOS_EXTRA_INFO
TABLE - HR.PQP_VEH_REPOS_INFO_TYPES
VIEW - APPS.PQP_ASSIGNMENT_ATTRIBUTES_D
VIEW - APPS.PQP_ASSIGNMENT_ATTRIBUTES_V
VIEW - APPS.PQP_GB_PENSION_SCHEMES_V
VIEW - APPS.PQP_GB_PENSION_TEMPLATE_V
VIEW - APPS.PQP_GB_STAKEHOLDER_TEMPLATE_V
VIEW - APPS.PQP_OMP_TEMPLATE_V
VIEW - APPS.PQP_OSP_TEMPLATE_V
VIEW - APPS.PQP_PROFESSIONAL_BODY_TEMP_V
VIEW - APPS.PQP_UNION_TEMPLATE_V
VIEW - APPS.PQP_VEHICLE_TEMPLATE_V

Table: PQP_ALIEN_STATE_TREATIES_F

Description: Table to store the State Alien treaty details.
Primary Key: PQP_ALIEN_STATE_TREATIES_FK
  1. STATE_CODE
  2. EFFECTIVE_START_DATE
  3. EFFECTIVE_END_DATE
Primary Key: PQP_ALIEN_STATE_TREATIES_PK
  1. ALIEN_STATE_TREATY_INFO_ID
  2. EFFECTIVE_START_DATE
  3. EFFECTIVE_END_DATE

[top of page]

HR.PQP_ALIEN_STATE_TREATIES_F does not reference any database object

HR.PQP_ALIEN_STATE_TREATIES_F is referenced by following:

HR
VIEW - PQP_ALIEN_STATE_TREATIES_F#

[top of page]

Table: PQP_ALIEN_TRANSACTION_DATA

Description: This table stores the Alien treaty analysis data transactions received from Third party vendors.
Primary Key: PQP_ALIEN_TRANSACTION_DATA_PK
  1. ALIEN_TRANSACTION_ID

[top of page]

HR.PQP_ALIEN_TRANSACTION_DATA does not reference any database object

HR.PQP_ALIEN_TRANSACTION_DATA is referenced by following:

HR
VIEW - PQP_ALIEN_TRANSACTION_DATA#

[top of page]

Table: PQP_ANALYZED_ALIEN_DATA

Description: Table to store the analyzed alien data.
Primary Key: PQP_ANALYZED_ALIEN_DATA_PK
  1. ANALYZED_DATA_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQP_ANALYZED_ALIEN_DETAILS.ANALYZED_DATA_ID PQP_ANALYZED_ALIEN_DATA

[top of page]

HR.PQP_ANALYZED_ALIEN_DATA does not reference any database object

HR.PQP_ANALYZED_ALIEN_DATA is referenced by following:

HR
VIEW - PQP_ANALYZED_ALIEN_DATA#

[top of page]

Table: PQP_ANALYZED_ALIEN_DETAILS

Description: Table to store the analyzed alien details.
Primary Key: PQP_ANALYZED_ALIEN_DETAILS_PK
  1. ANALYZED_DATA_DETAILS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQP_ANALYZED_ALIEN_DETAILS.ANALYZED_DATA_ID PQP_ANALYZED_ALIEN_DATA

[top of page]

HR.PQP_ANALYZED_ALIEN_DETAILS does not reference any database object

HR.PQP_ANALYZED_ALIEN_DETAILS is referenced by following:

HR
VIEW - PQP_ANALYZED_ALIEN_DETAILS#

[top of page]

Table: PQP_ASSIGNMENT_ATTRIBUTES_F

Description: PQP_ASSIGNMENT_ATTRIBUTES_F is the DateTracked table which holds a variety of information required by the public sector payroll product at assignment level. This information includes the contract type and details of work patterns. Even thou
Primary Key: PQP_ASSIGNMENT_ATTRIBUTES_F_PK
  1. ASSIGNMENT_ATTRIBUTE_ID
  2. EFFECTIVE_START_DATE
  3. EFFECTIVE_END_DATE

[top of page]

HR.PQP_ASSIGNMENT_ATTRIBUTES_F does not reference any database object

HR.PQP_ASSIGNMENT_ATTRIBUTES_F is referenced by following:

HR
VIEW - PQP_ASSIGNMENT_ATTRIBUTES_F#

[top of page]

Table: PQP_CONFIGURATION_MODULES

Description: Table used to keep track of modules that has configuration values setup.
Primary Key: PQP_CONFIGURATION_MODULES_PK
  1. MODULE_ID

[top of page]

HR.PQP_CONFIGURATION_MODULES does not reference any database object

HR.PQP_CONFIGURATION_MODULES is referenced by following:

HR
VIEW - PQP_CONFIGURATION_MODULES#

[top of page]

Table: PQP_CONFIGURATION_TYPES

Description: Entity used to store the information types (configuration types) for each module stored in pqp_configuration_modules. Each row identifies one configuration type and the values for this type is stored in pqp_configuration_values table.
Primary Key: PQP_CONFIGURATION_TYPES_U1
  1. MODULE_ID
  2. LEGISLATION_CODE
  3. CONFIGURATION_TYPE

[top of page]

HR.PQP_CONFIGURATION_TYPES does not reference any database object

HR.PQP_CONFIGURATION_TYPES is referenced by following:

HR
VIEW - PQP_CONFIGURATION_TYPES#

[top of page]

Table: PQP_CONFIGURATION_VALUES

Description: Table used for all generic configuration details, both seeded and user defined.
Primary Key: PQP_CONFIGURATION_VALUES_PK
  1. CONFIGURATION_VALUE_ID

[top of page]

HR.PQP_CONFIGURATION_VALUES does not reference any database object

HR.PQP_CONFIGURATION_VALUES is referenced by following:

HR
VIEW - PQP_CONFIGURATION_VALUES#

[top of page]

Table: PQP_EXCEPTION_REPORTS

Description: Table to store the exception report definitions. This table contains both seeded and user defined exception reports based on a balance and dimension.
Primary Key: PET_PK
  1. EXCEPTION_REPORT_ID
Primary Key: PQP_EXCEPTION_REPORTS_PK
  1. EXCEPTION_REPORT_ID

[top of page]

HR.PQP_EXCEPTION_REPORTS does not reference any database object

HR.PQP_EXCEPTION_REPORTS is referenced by following:

HR
VIEW - PQP_EXCEPTION_REPORTS#

[top of page]

Table: PQP_EXCEPTION_REPORTS_TL

Description: Translation table to store the exception report definitions.
Primary Key: PEL_PK
  1. EXCEPTION_REPORT_ID
  2. LANGUAGE
Primary Key: PQP_EXCEPTION_REPORTS_TL_PK
  1. EXCEPTION_REPORT_ID
  2. LANGUAGE

[top of page]

HR.PQP_EXCEPTION_REPORTS_TL does not reference any database object

HR.PQP_EXCEPTION_REPORTS_TL is referenced by following:

HR
VIEW - PQP_EXCEPTION_REPORTS_TL#

[top of page]

Table: PQP_EXCEPTION_REPORT_GROUPS

Description: This table is used to group the exception report definitions so that multiple exception definitions can be run at once.
Primary Key: PEP_PK
  1. EXCEPTION_GROUP_ID
Primary Key: PQP_EXCEPTION_REPORT_GROUPS_PK
  1. EXCEPTION_GROUP_ID

[top of page]

HR.PQP_EXCEPTION_REPORT_GROUPS does not reference any database object

HR.PQP_EXCEPTION_REPORT_GROUPS is referenced by following:

HR
VIEW - PQP_EXCEPTION_REPORT_GROUPS#

[top of page]

Table: PQP_EXCEPTION_REPORT_SUFFIX

Description: Table to store the balance dimension database suffix and its equivalent reporting period.
Primary Key: PQP_EXCEPTION_REPORT_SUFFIX_PK
  1. DATABASE_ITEM_SUFFIX
  2. LEGISLATION_CODE

[top of page]

HR.PQP_EXCEPTION_REPORT_SUFFIX does not reference any database object

HR.PQP_EXCEPTION_REPORT_SUFFIX is referenced by following:

HR
VIEW - PQP_EXCEPTION_REPORT_SUFFIX#

[top of page]

Table: PQP_EXTRACT_ATTRIBUTES

Description: Table to hold extra attributes of system extracts required for the Public Sector Payroll application.
Primary Key: PQP_EXTRACK_ATTRIBUTES_UK1
  1. EXT_DFN_ID
Primary Key: PQP_EXTRACT_ATTRIBUTES_PK
  1. EXTRACT_ATTRIBUTE_ID
Primary Key: PQP_EXTRACT_ATTRIBUTES_UK1
  1. EXT_DFN_ID

[top of page]

HR.PQP_EXTRACT_ATTRIBUTES does not reference any database object

HR.PQP_EXTRACT_ATTRIBUTES is referenced by following:

HR
VIEW - PQP_EXTRACT_ATTRIBUTES#

[top of page]

Table: PQP_EXT_CROSS_PERSON_RECORDS

Description: Table to hold cross person and cross busines group reporting related records used and maintained by Teachers Pension Extract Process.

[top of page]

HR.PQP_EXT_CROSS_PERSON_RECORDS does not reference any database object

HR.PQP_EXT_CROSS_PERSON_RECORDS is referenced by following:

HR
VIEW - PQP_EXT_CROSS_PERSON_RECORDS#

[top of page]

Table: PQP_FLXDU_COLUMNS

Description: This table is used to maintain all the fields for a HR entity types available in a spreadsheet.
Primary Key: PQP_FLXDU_COLUMNS_PK
  1. FLXDU_COLUMN_ID

[top of page]

HR.PQP_FLXDU_COLUMNS does not reference any database object

HR.PQP_FLXDU_COLUMNS is referenced by following:

HR
VIEW - PQP_FLXDU_COLUMNS#

[top of page]

Table: PQP_FLXDU_FUNC_ATTRIBUTES

Description: This table is used to identify the functions that are created using the RIW setup.
Primary Key: PQP_FLXDU_FUNC_ATTRIBUTES_PK
  1. FLXDU_FUNC_ATTRIBUTE_ID

[top of page]

HR.PQP_FLXDU_FUNC_ATTRIBUTES does not reference any database object

HR.PQP_FLXDU_FUNC_ATTRIBUTES is referenced by following:

HR
VIEW - PQP_FLXDU_FUNC_ATTRIBUTES#

[top of page]

Table: PQP_FLXDU_XML_TAGS

Description: Table used to maintain all user defined XML tags for spreadsheet-supported fields
Primary Key: PQP_FLXDU_XML_TAGS_PK
  1. FLXDU_XML_TAG_ID

[top of page]

HR.PQP_FLXDU_XML_TAGS does not reference any database object

HR.PQP_FLXDU_XML_TAGS is referenced by following:

HR
VIEW - PQP_FLXDU_XML_TAGS#

[top of page]

Table: PQP_GAP_ABSENCE_PLANS

Description: This table is used to store the generic Absence Plans
Primary Key: PQP_GAP_ABSENCE_PLANS_PK
  1. GAP_ABSENCE_PLAN_ID
Primary Key: PQP_GAP_ABSENCE_PLANS_UK1
  1. ABSENCE_ATTENDANCE_ID
  2. PL_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
PQP_GAP_DAILY_ABSENCES.GAP_ABSENCE_PLAN_ID PQP_GAP_ABSENCE_PLANS

[top of page]

HR.PQP_GAP_ABSENCE_PLANS does not reference any database object

HR.PQP_GAP_ABSENCE_PLANS is referenced by following:

HR
VIEW - PQP_GAP_ABSENCE_PLANS#

[top of page]

Table: PQP_GAP_DAILY_ABSENCES

Description: This table is used to store daily absence details like absence date, work pattern and the level of entitlement for an absence plan.
Primary Key: PQP_GAP_DAILY_ABSENCES_PK
  1. GAP_DAILY_ABSENCE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PQP_GAP_DAILY_ABSENCES.GAP_ABSENCE_PLAN_ID PQP_GAP_ABSENCE_PLANS

[top of page]

HR.PQP_GAP_DAILY_ABSENCES does not reference any database object

HR.PQP_GAP_DAILY_ABSENCES is referenced by following:

HR
VIEW - PQP_GAP_DAILY_ABSENCES#

[top of page]

Table: PQP_GAP_DURATION_SUMMARY

Description:
Primary Key: PQP_GAP_DURATION_SUMMARY_PK
  1. GAP_DURATION_SUMMARY_ID

[top of page]

HR.PQP_GAP_DURATION_SUMMARY does not reference any database object

HR.PQP_GAP_DURATION_SUMMARY is referenced by following:

HR
VIEW - PQP_GAP_DURATION_SUMMARY#

[top of page]

Table: PQP_PENSION_TYPES_F

Description: This table is used to store the pension types.
Primary Key: PQP_PENSION_TYPES_F_PK
  1. PENSION_TYPE_ID
  2. EFFECTIVE_START_DATE
  3. EFFECTIVE_END_DATE
Primary Key: PQP_PENSION_TYPES_PK
  1. PENSION_TYPE_ID
  2. EFFECTIVE_START_DATE
  3. EFFECTIVE_END_DATE

[top of page]

HR.PQP_PENSION_TYPES_F does not reference any database object

HR.PQP_PENSION_TYPES_F is referenced by following:

HR
VIEW - PQP_PENSION_TYPES_F#

[top of page]

Table: PQP_SERVICE_HISTORY_PERIODS

Description: Table to hold information regarding relevant perids of previous employment.
Primary Key: PQP_SERVICE_HISTORY_PERIODS_PK
  1. SERVICE_HISTORY_PERIOD_ID

[top of page]

HR.PQP_SERVICE_HISTORY_PERIODS does not reference any database object

HR.PQP_SERVICE_HISTORY_PERIODS is referenced by following:

HR
VIEW - PQP_SERVICE_HISTORY_PERIODS#

[top of page]

Table: PQP_VEHICLE_ALLOCATIONS_F

Description: Table used to keep track of the association of a vehicle to an assignment.
Primary Key: PQP_VEHICLE_ALLOCATIONS_F_PK
  1. VEHICLE_ALLOCATION_ID
  2. EFFECTIVE_START_DATE
  3. EFFECTIVE_END_DATE
Primary Key: PQP_VEHICLE_ALLOCATIONS_PK
  1. VEHICLE_ALLOCATION_ID
  2. EFFECTIVE_START_DATE
  3. EFFECTIVE_END_DATE

[top of page]

HR.PQP_VEHICLE_ALLOCATIONS_F does not reference any database object

HR.PQP_VEHICLE_ALLOCATIONS_F is referenced by following:

HR
VIEW - PQP_VEHICLE_ALLOCATIONS_F#

[top of page]

Table: PQP_VEHICLE_DETAILS

Description: Table to store the vehicle details including private and company vehicles. This table has been superseded by PQP_VEHICLE_REPOSITORY_F which is a datetracked table.
Primary Key: PQP_VEHICLE_DETAILS_PK
  1. VEHICLE_DETAILS_ID

[top of page]

HR.PQP_VEHICLE_DETAILS does not reference any database object

HR.PQP_VEHICLE_DETAILS is referenced by following:

HR
VIEW - PQP_VEHICLE_DETAILS#

[top of page]

Table: PQP_VEHICLE_DETAILS_EFC

Description: Table used for the EFC conversion of the PQP_VEHICLE_DETAILS.
Primary Key: PQP_VEHICLE_DETAILS_PK1
  1. VEHICLE_DETAILS_ID

[top of page]

HR.PQP_VEHICLE_DETAILS_EFC does not reference any database object

HR.PQP_VEHICLE_DETAILS_EFC is referenced by following:

HR
VIEW - PQP_VEHICLE_DETAILS_EFC#

[top of page]

Table: PQP_VEHICLE_REPOSITORY_F

Description: This table is used to store the vehicle details.
Primary Key: PQP_VEHICLE_REPOSITORY_F_PK
  1. VEHICLE_REPOSITORY_ID
  2. EFFECTIVE_START_DATE
  3. EFFECTIVE_END_DATE
Primary Key: PQP_VEHICLE_REPOSITORY_PK
  1. VEHICLE_REPOSITORY_ID
  2. EFFECTIVE_START_DATE
  3. EFFECTIVE_END_DATE

[top of page]

HR.PQP_VEHICLE_REPOSITORY_F does not reference any database object

HR.PQP_VEHICLE_REPOSITORY_F is referenced by following:

HR
VIEW - PQP_VEHICLE_REPOSITORY_F#

[top of page]

Table: PQP_VEH_ALLOC_EXTRA_INFO

Description: This entity is used to store any extra information regarding a Vehicle Allocation. This is an intersection table between PQP_VEHICLE_ALLOCATION_F and PQP_VEH_ALLOC_INFO_TYPES.
Primary Key: PQP_VEH_ALLOC_EXTRA_INFO_PK
  1. VEH_ALLOC_EXTRA_INFO_ID

[top of page]

HR.PQP_VEH_ALLOC_EXTRA_INFO does not reference any database object

HR.PQP_VEH_ALLOC_EXTRA_INFO is referenced by following:

HR
VIEW - PQP_VEH_ALLOC_EXTRA_INFO#

[top of page]

Table: PQP_VEH_ALLOC_INFO_TYPES

Description: Entity used to store the information types for vehicle allocation extra information.
Primary Key: PQP_VEH_ALLOC_INFO_TYPES_PK
  1. INFORMATION_TYPE

[top of page]

HR.PQP_VEH_ALLOC_INFO_TYPES does not reference any database object

HR.PQP_VEH_ALLOC_INFO_TYPES is referenced by following:

HR
VIEW - PQP_VEH_ALLOC_INFO_TYPES#

[top of page]

Table: PQP_VEH_REPOS_EXTRA_INFO

Description: This entity is used to store any extra information regarding a Vehicle. This is an intersection table between PQP_VEHICLE_REPOSITORY_F and PQP_VEH_REPOS_INFO_TYPES.
Primary Key: PQP_VEH_REPOS_EXTRA_INFO_PK
  1. VEH_REPOS_EXTRA_INFO_ID

[top of page]

HR.PQP_VEH_REPOS_EXTRA_INFO does not reference any database object

HR.PQP_VEH_REPOS_EXTRA_INFO is referenced by following:

HR
VIEW - PQP_VEH_REPOS_EXTRA_INFO#

[top of page]

Table: PQP_VEH_REPOS_INFO_TYPES

Description: Entity used to store the information types for Vehicle Repository Extra information.
Primary Key: PQP_VEH_REPOS_INFO_TYPES_PK
  1. INFORMATION_TYPE

[top of page]

HR.PQP_VEH_REPOS_INFO_TYPES does not reference any database object

HR.PQP_VEH_REPOS_INFO_TYPES is referenced by following:

HR
VIEW - PQP_VEH_REPOS_INFO_TYPES#

[top of page]

View: PQP_ASSIGNMENT_ATTRIBUTES_D

[top of page]

APPS.PQP_ASSIGNMENT_ATTRIBUTES_D references the following:

APPS
VIEW - FND_USER_VIEW
PACKAGE - HR_API
VIEW - HR_LOOKUPS
SYNONYM - PAY_RATES
SYNONYM - PAY_USER_TABLES
SYNONYM - PER_SPINAL_POINTS
SYNONYM - PQP_ASSIGNMENT_ATTRIBUTES_F
SYNONYM - PQP_VEHICLE_DETAILS

APPS.PQP_ASSIGNMENT_ATTRIBUTES_D is not referenced by any database object

[top of page]

View: PQP_ASSIGNMENT_ATTRIBUTES_V

[top of page]

APPS.PQP_ASSIGNMENT_ATTRIBUTES_V references the following:

APPS
PACKAGE - HR_API
VIEW - HR_LOOKUPS
SYNONYM - PAY_RATES
SYNONYM - PAY_USER_TABLES
SYNONYM - PER_SPINAL_POINTS
SYNONYM - PQP_ASSIGNMENT_ATTRIBUTES_F
SYNONYM - PQP_VEHICLE_DETAILS

APPS.PQP_ASSIGNMENT_ATTRIBUTES_V is not referenced by any database object

[top of page]

View: PQP_GB_PENSION_SCHEMES_V

[top of page]

APPS.PQP_GB_PENSION_SCHEMES_V references the following:

APPS
PACKAGE - FND_DATE
PACKAGE - FND_NUMBER
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - PAY_BALANCE_TYPES
SYNONYM - PAY_ELEMENT_CLASSIFICATIONS
SYNONYM - PAY_ELEMENT_TYPES_F
SYNONYM - PAY_ELEMENT_TYPE_EXTRA_INFO
SYNONYM - PQP_PENSION_TYPES_F

APPS.PQP_GB_PENSION_SCHEMES_V is not referenced by any database object

[top of page]

View: PQP_GB_PENSION_TEMPLATE_V

[top of page]

APPS.PQP_GB_PENSION_TEMPLATE_V references the following:

APPS
SYNONYM - FND_SESSIONS
PACKAGE - HR_API
VIEW - HR_LOOKUPS
SYNONYM - PAY_ELEMENT_CLASSIFICATIONS
SYNONYM - PAY_ELEMENT_TYPES_F
SYNONYM - PAY_ELEMENT_TYPE_EXTRA_INFO

APPS.PQP_GB_PENSION_TEMPLATE_V is not referenced by any database object

[top of page]

View: PQP_GB_STAKEHOLDER_TEMPLATE_V

[top of page]

APPS.PQP_GB_STAKEHOLDER_TEMPLATE_V references the following:

APPS
SYNONYM - FND_SESSIONS
PACKAGE - HR_API
VIEW - HR_LOOKUPS
SYNONYM - PAY_ELEMENT_CLASSIFICATIONS
SYNONYM - PAY_ELEMENT_TYPES_F
SYNONYM - PAY_ELEMENT_TYPE_EXTRA_INFO

APPS.PQP_GB_STAKEHOLDER_TEMPLATE_V is not referenced by any database object

[top of page]

View: PQP_OMP_TEMPLATE_V

[top of page]

APPS.PQP_OMP_TEMPLATE_V references the following:

APPS
SYNONYM - BEN_PL_F
SYNONYM - BEN_PL_TYP_F
PACKAGE - FND_NUMBER
SYNONYM - FND_SESSIONS
PACKAGE - HR_API
VIEW - HR_LOOKUPS
SYNONYM - PAY_ELEMENT_CLASSIFICATIONS
SYNONYM - PAY_ELEMENT_TEMPLATES
SYNONYM - PAY_ELEMENT_TYPES_F
SYNONYM - PAY_ELEMENT_TYPE_EXTRA_INFO
SYNONYM - PAY_TEMPLATE_CORE_OBJECTS
SYNONYM - PAY_USER_TABLES

APPS.PQP_OMP_TEMPLATE_V is not referenced by any database object

[top of page]

View: PQP_OSP_TEMPLATE_V

[top of page]

APPS.PQP_OSP_TEMPLATE_V references the following:

APPS
SYNONYM - BEN_PL_F
SYNONYM - BEN_PL_TYP_F
PACKAGE - FND_DATE
PACKAGE - FND_NUMBER
SYNONYM - FND_SESSIONS
PACKAGE - HR_API
VIEW - HR_LOOKUPS
SYNONYM - PAY_ELEMENT_CLASSIFICATIONS
SYNONYM - PAY_ELEMENT_TEMPLATES
SYNONYM - PAY_ELEMENT_TYPES_F
SYNONYM - PAY_ELEMENT_TYPE_EXTRA_INFO
SYNONYM - PAY_TEMPLATE_CORE_OBJECTS
SYNONYM - PAY_USER_TABLES

APPS.PQP_OSP_TEMPLATE_V is not referenced by any database object

[top of page]

View: PQP_PROFESSIONAL_BODY_TEMP_V

[top of page]

APPS.PQP_PROFESSIONAL_BODY_TEMP_V references the following:

APPS
SYNONYM - FND_SESSIONS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - HR_ORGANIZATION_INFORMATION
SYNONYM - PAY_ELEMENT_CLASSIFICATIONS
SYNONYM - PAY_ELEMENT_TYPES_F
SYNONYM - PAY_ELEMENT_TYPE_EXTRA_INFO

APPS.PQP_PROFESSIONAL_BODY_TEMP_V is not referenced by any database object

[top of page]

View: PQP_UNION_TEMPLATE_V

[top of page]

APPS.PQP_UNION_TEMPLATE_V references the following:

APPS
SYNONYM - FND_SESSIONS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
PACKAGE - HR_API
VIEW - HR_LOOKUPS
SYNONYM - HR_ORGANIZATION_INFORMATION
SYNONYM - PAY_ELEMENT_CLASSIFICATIONS
SYNONYM - PAY_ELEMENT_TYPES_F
SYNONYM - PAY_ELEMENT_TYPE_EXTRA_INFO
SYNONYM - PAY_INPUT_VALUES_F

APPS.PQP_UNION_TEMPLATE_V is not referenced by any database object

[top of page]

View: PQP_VEHICLE_TEMPLATE_V

[top of page]

APPS.PQP_VEHICLE_TEMPLATE_V references the following:

APPS
SYNONYM - FND_SESSIONS
SYNONYM - PAY_ELEMENT_TYPES_F
SYNONYM - PAY_ELEMENT_TYPE_EXTRA_INFO

APPS.PQP_VEHICLE_TEMPLATE_V is not referenced by any database object

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