eTRM uses javascript that opens and focuses a separate window to display reports.
Your browser does not appear to support javascript. This should not prevent you from using
eTRM but it does mean the window focus feature will not work. Please check the contents of
other windows on your desktop if you click on a link that does not appear to do anything.
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®,
OracleDevConnect SM, Oracle® Discoverer,
Oracle® Expert, Oracle Financials®, OracleGOLD SM,
OracleIncident SM, OracleJSP,
OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURY SM,
OracleMetaLink SM, Oraclemetals SM, OracleMobile, Oracle Names®,
Oracle NetSolutions®, Oracle® One, Oracle Open Gateways®,
Oracle OpenWorld®, OraclePLATINUM SM,
Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®,
Oracle Quality®, Oracle Secure Network Services®, OracleSILVER SM,
Oracle® SQL/Services, Oracle® SQL*TutorSM,
OracleSTERLING SM, 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
STATE_CODE
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
Primary Key: PQP_ALIEN_STATE_TREATIES_PK
ALIEN_STATE_TREATY_INFO_ID
EFFECTIVE_START_DATE
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:
APPS
SYNONYM - PQP_ALIEN_STATE_TREATIES_F
TRIGGER - PQP_ALIEN_STATE_TREATIES_F_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - PQP_ALIEN_TRANSACTION_DATA
TRIGGER - PQP_ALIEN_TRANSACTION_DATA_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - PQP_ANALYZED_ALIEN_DATA
TRIGGER - PQP_ANALYZED_ALIEN_DATA_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - PQP_ANALYZED_ALIEN_DETAILS
TRIGGER - PQP_ANALYZED_ALIEN_DETAILS_WHO
PUBLIC
SYNONYM - 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
ASSIGNMENT_ATTRIBUTE_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
Primary Key: PQP_ASSIGNMENT_ATTRIBUTES_PK
ASSIGNMENT_ATTRIBUTE_ID
EFFECTIVE_START_DATE
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:
APPS
TRIGGER - PQPASSIGNMENTATTRIBUTE_77I_DYT
TRIGGER - PQPASSIGNMENTATTRIBU_2133D_DYT
SYNONYM - PQP_ASSIGNMENT_ATTRIBUTES_F
TRIGGER - PQP_ASSIGNMENT_ATTRIBUTES_WHO
PUBLIC
SYNONYM - 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
MODULE_ID
[top of page]
HR.PQP_CONFIGURATION_MODULES does not reference any database object
HR.PQP_CONFIGURATION_MODULES is referenced by following:
APPS
SYNONYM - PQP_CONFIGURATION_MODULES
TRIGGER - PQP_CONFIGURATION_MODULES_WHO
PUBLIC
SYNONYM - 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
MODULE_ID
LEGISLATION_CODE
CONFIGURATION_TYPE
[top of page]
HR.PQP_CONFIGURATION_TYPES does not reference any database object
HR.PQP_CONFIGURATION_TYPES is referenced by following:
APPS
SYNONYM - PQP_CONFIGURATION_TYPES
TRIGGER - PQP_CONFIGURATION_TYPES_WHO
PUBLIC
SYNONYM - 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
CONFIGURATION_VALUE_ID
[top of page]
HR.PQP_CONFIGURATION_VALUES does not reference any database object
HR.PQP_CONFIGURATION_VALUES is referenced by following:
APPS
SYNONYM - PQP_CONFIGURATION_VALUES
TRIGGER - PQP_CONFIGURATION_VALUES_WHO
PUBLIC
SYNONYM - 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
EXCEPTION_REPORT_ID
Primary Key: PQP_EXCEPTION_REPORTS_PK
EXCEPTION_REPORT_ID
[top of page]
HR.PQP_EXCEPTION_REPORTS does not reference any database object
HR.PQP_EXCEPTION_REPORTS is referenced by following:
APPS
SYNONYM - PQP_EXCEPTION_REPORTS
TRIGGER - PQP_EXCEPTION_REPORTS_WHO
PUBLIC
SYNONYM - PQP_EXCEPTION_REPORTS
[top of page]
Table: PQP_EXCEPTION_REPORTS_TL
Description: Translation table to store the exception report definitions.
Primary Key: PEL_PK
EXCEPTION_REPORT_ID
LANGUAGE
Primary Key: PQP_EXCEPTION_REPORTS_TL_PK
EXCEPTION_REPORT_ID
LANGUAGE
[top of page]
HR.PQP_EXCEPTION_REPORTS_TL does not reference any database object
HR.PQP_EXCEPTION_REPORTS_TL is referenced by following:
APPS
TRIGGER - PQP_EXCEPTION_REPORT041339_WHO
SYNONYM - PQP_EXCEPTION_REPORTS_TL
PUBLIC
SYNONYM - 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
EXCEPTION_GROUP_ID
Primary Key: PQP_EXCEPTION_REPORT_GROUPS_PK
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:
APPS
SYNONYM - PQP_EXCEPTION_REPORT_GROUPS
TRIGGER - PQP_EXCEPTION_REPORT_GROUP_WHO
PUBLIC
SYNONYM - 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
DATABASE_ITEM_SUFFIX
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:
APPS
SYNONYM - PQP_EXCEPTION_REPORT_SUFFIX
TRIGGER - PQP_EXCEPTION_REPORT_SUFFI_WHO
PUBLIC
SYNONYM - 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
EXT_DFN_ID
Primary Key: PQP_EXTRACT_ATTRIBUTES_PK
EXTRACT_ATTRIBUTE_ID
Primary Key: PQP_EXTRACT_ATTRIBUTES_UK1
EXT_DFN_ID
[top of page]
HR.PQP_EXTRACT_ATTRIBUTES does not reference any database object
HR.PQP_EXTRACT_ATTRIBUTES is referenced by following:
APPS
SYNONYM - PQP_EXTRACT_ATTRIBUTES
TRIGGER - PQP_EXTRACT_ATTRIBUTES_WHO
PUBLIC
SYNONYM - 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:
APPS
SYNONYM - PQP_EXT_CROSS_PERSON_RECORDS
TRIGGER - PQP_EXT_CROSS_PERSON_RECOR_WHO
PUBLIC
SYNONYM - 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
FLXDU_COLUMN_ID
[top of page]
HR.PQP_FLXDU_COLUMNS does not reference any database object
HR.PQP_FLXDU_COLUMNS is referenced by following:
APPS
SYNONYM - PQP_FLXDU_COLUMNS
TRIGGER - PQP_FLXDU_COLUMNS_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - PQP_FLXDU_FUNC_ATTRIBUTES
TRIGGER - PQP_FLXDU_FUNC_ATTRIBUTES_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - PQP_FLXDU_XML_TAGS
TRIGGER - PQP_FLXDU_XML_TAGS_WHO
PUBLIC
SYNONYM - 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
GAP_ABSENCE_PLAN_ID
Primary Key: PQP_GAP_ABSENCE_PLANS_UK1
ABSENCE_ATTENDANCE_ID
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:
APPS
SYNONYM - PQP_GAP_ABSENCE_PLANS
TRIGGER - PQP_GAP_ABSENCE_PLANS_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - PQP_GAP_DAILY_ABSENCES
TRIGGER - PQP_GAP_DAILY_ABSENCES_WHO
PUBLIC
SYNONYM - PQP_GAP_DAILY_ABSENCES
[top of page]
Table: PQP_GAP_DURATION_SUMMARY
Primary Key: PQP_GAP_DURATION_SUMMARY_PK
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:
APPS
SYNONYM - PQP_GAP_DURATION_SUMMARY
TRIGGER - PQP_GAP_DURATION_SUMMARY_WHO
PUBLIC
SYNONYM - 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
PENSION_TYPE_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
Primary Key: PQP_PENSION_TYPES_PK
PENSION_TYPE_ID
EFFECTIVE_START_DATE
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:
APPS
SYNONYM - PQP_PENSION_TYPES_F
TRIGGER - PQP_PENSION_TYPES_F_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - PQP_SERVICE_HISTORY_PERIODS
TRIGGER - PQP_SERVICE_HISTORY_PERIOD_WHO
PUBLIC
SYNONYM - 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
VEHICLE_ALLOCATION_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
Primary Key: PQP_VEHICLE_ALLOCATIONS_PK
VEHICLE_ALLOCATION_ID
EFFECTIVE_START_DATE
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:
APPS
SYNONYM - PQP_VEHICLE_ALLOCATIONS_F
TRIGGER - PQP_VEHICLE_ALLOCATIONS_F_WHO
[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
VEHICLE_DETAILS_ID
[top of page]
HR.PQP_VEHICLE_DETAILS does not reference any database object
HR.PQP_VEHICLE_DETAILS is referenced by following:
APPS
SYNONYM - PQP_VEHICLE_DETAILS
TRIGGER - PQP_VEHICLE_DETAILS_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - PQP_VEHICLE_DETAILS_EFC
PUBLIC
SYNONYM - 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
VEHICLE_REPOSITORY_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
Primary Key: PQP_VEHICLE_REPOSITORY_PK
VEHICLE_REPOSITORY_ID
EFFECTIVE_START_DATE
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:
APPS
SYNONYM - PQP_VEHICLE_REPOSITORY_F
TRIGGER - PQP_VEHICLE_REPOSITORY_F_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - PQP_VEH_ALLOC_EXTRA_INFO
TRIGGER - PQP_VEH_ALLOC_EXTRA_INFO_WHO
[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
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:
APPS
SYNONYM - PQP_VEH_ALLOC_INFO_TYPES
TRIGGER - PQP_VEH_ALLOC_INFO_TYPES_WHO
[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
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:
APPS
SYNONYM - PQP_VEH_REPOS_EXTRA_INFO
TRIGGER - PQP_VEH_REPOS_EXTRA_INFO_WHO
PUBLIC
SYNONYM - 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
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:
APPS
SYNONYM - PQP_VEH_REPOS_INFO_TYPES
TRIGGER - PQP_VEH_REPOS_INFO_TYPES_WHO
PUBLIC
SYNONYM - 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
PACKAGE - FND_GLOBAL
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 referenced by following:
PUBLIC
SYNONYM - PQP_ASSIGNMENT_ATTRIBUTES_D
[top of page]
View: PQP_ASSIGNMENT_ATTRIBUTES_V
[top of page]
APPS.PQP_ASSIGNMENT_ATTRIBUTES_V references the following:
APPS
PACKAGE - FND_GLOBAL
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 referenced by following:
PUBLIC
SYNONYM - PQP_ASSIGNMENT_ATTRIBUTES_V
[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 referenced by following:
APPS
PACKAGE BODY - PQP_GB_PENSION_FUNCTIONS
PACKAGE - PQP_GB_PENSION_FUNCTIONS
PACKAGE BODY - PQP_GB_PENSION_SCHEME_TEMPLATE
PUBLIC
SYNONYM - PQP_GB_PENSION_SCHEMES_V
[top of page]
View: PQP_GB_PENSION_TEMPLATE_V
[top of page]
APPS.PQP_GB_PENSION_TEMPLATE_V references the following:
APPS
PACKAGE - FND_GLOBAL
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 referenced by following:
PUBLIC
SYNONYM - PQP_GB_PENSION_TEMPLATE_V
[top of page]
View: PQP_GB_STAKEHOLDER_TEMPLATE_V
[top of page]
APPS.PQP_GB_STAKEHOLDER_TEMPLATE_V references the following:
APPS
PACKAGE - FND_GLOBAL
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 referenced by following:
PUBLIC
SYNONYM - PQP_GB_STAKEHOLDER_TEMPLATE_V
[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_GLOBAL
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 referenced by following:
PUBLIC
SYNONYM - PQP_OMP_TEMPLATE_V
[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_GLOBAL
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 referenced by following:
PUBLIC
SYNONYM - PQP_OSP_TEMPLATE_V
[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 referenced by following:
PUBLIC
SYNONYM - PQP_PROFESSIONAL_BODY_TEMP_V
[top of page]
View: PQP_UNION_TEMPLATE_V
[top of page]
APPS.PQP_UNION_TEMPLATE_V references the following:
APPS
PACKAGE - FND_GLOBAL
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 referenced by following:
PUBLIC
SYNONYM - PQP_UNION_TEMPLATE_V
[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 referenced by following:
PUBLIC
SYNONYM - PQP_VEHICLE_TEMPLATE_V
[top of page]