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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.PQP_UNION_TEMPLATE_V

Object Details

Object Name:	PQP_UNION_TEMPLATE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PQP.PQP_UNION_TEMPLATE_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ELEMENT_TYPE_ID	NUMBER	(9)	Yes	Primary key of base element
BUSINESS_GROUP_ID	NUMBER	(15)		Foreign key to HR_ALL_ORGANIZATION_UNITS
LEGISLATION_CODE	VARCHAR2	(30)		Legislation code
CLASSIFICATION_ID	NUMBER	(9)	Yes	Foreign key to HR_ORG_CLASSIFICATIONS
CLASSIFICATION_NAME	VARCHAR2	(80)	Yes	Classification name of base element
PROCESSING_TYPE	VARCHAR2	(30)	Yes	Processing type of base element
ELEMENT_NAME	VARCHAR2	(80)	Yes	Name of base element
REPORTING_NAME	VARCHAR2	(80)		Reporting name of base element
DESCRIPTION	VARCHAR2	(240)		Description of base element
ORGANIZATION_ID	VARCHAR2	(150)		Foreign key to HR_ALL_ORGANIZATION_UNITS
UNION_NAME	VARCHAR2	(240)	Yes	Name of union descibed by this element
UNION_LEVEL_BALANCE	VARCHAR2	(150)		Name of balance for all templates associated with same union
RATE_TYPE	VARCHAR2	(150)		Rate type lookup code
RATE_TYPE_NAME	VARCHAR2	(80)		Rate type meaning
FUND_LIST	VARCHAR2	(150)		List of available political funds
OVERRIDE_AMOUNT	VARCHAR2	(1)		Override amount if non-standard contribution
TAX_RELIEF	VARCHAR2	(1)		Tax relief available on contributions?
SUPPLEMENTARY_LEVY	VARCHAR2	(1)		Optional supplementary levy payable?
LAST_UPDATE_DATE	DATE			Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)		Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column
CREATED_BY	NUMBER	(15)		Standard WHO column
CREATION_DATE	DATE			Standard WHO column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ELEMENT_TYPE_ID
,      BUSINESS_GROUP_ID
,      LEGISLATION_CODE
,      CLASSIFICATION_ID
,      CLASSIFICATION_NAME
,      PROCESSING_TYPE
,      ELEMENT_NAME
,      REPORTING_NAME
,      DESCRIPTION
,      ORGANIZATION_ID
,      UNION_NAME
,      UNION_LEVEL_BALANCE
,      RATE_TYPE
,      RATE_TYPE_NAME
,      FUND_LIST
,      OVERRIDE_AMOUNT
,      TAX_RELIEF
,      SUPPLEMENTARY_LEVY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM APPS.PQP_UNION_TEMPLATE_V;

Dependencies

[top of page]

APPS.PQP_UNION_TEMPLATE_V references the following:

APPS: FND_SESSIONS; HR_ALL_ORGANIZATION_UNITS; HR_API - show dependent code; HR_LOOKUPS; HR_ORGANIZATION_INFORMATION; PAY_ELEMENT_CLASSIFICATIONS; PAY_ELEMENT_TYPES_F; PAY_ELEMENT_TYPE_EXTRA_INFO; PAY_INPUT_VALUES_F

APPS.PQP_UNION_TEMPLATE_V is not referenced by any database object