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_GB_STAKEHOLDER_TEMPLATE_V

Object Details

Object Name:	PQP_GB_STAKEHOLDER_TEMPLATE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PQP.PQP_GB_STAKEHOLDER_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 of base element
ELEMENT_NAME	VARCHAR2	(80)		Name of base element
REPORTING_NAME	VARCHAR2	(80)		Reporting name of base element
DESCRIPTION	VARCHAR2	(240)		Description of base element
SCHEME_TYPE	VARCHAR2	(150)		Type of stakeholder pension scheme
CONTRIBUTION_METHOD	VARCHAR2	(150)		Method of contribution to scheme
EMPLOYER_CONTRIBUTIONS	VARCHAR2	(1)		Employer contributions payable?
EMPLOYER_CONTRIBUTION_RATE	VARCHAR2	(150)		Rate of employer contributions
EMPLOYER_CONTRIBUTION_TYPE	VARCHAR2	(150)		Type of employer contributions
EMPLOYER_CONTRIBUTION_TYPE_NM	VARCHAR2	(80)		Type of employer contributions
EMPLOYEE_DEFAULT_CONTRIBUTION	VARCHAR2	(150)		Default level of employee contribution 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
,      ELEMENT_NAME
,      REPORTING_NAME
,      DESCRIPTION
,      SCHEME_TYPE
,      CONTRIBUTION_METHOD
,      EMPLOYER_CONTRIBUTIONS
,      EMPLOYER_CONTRIBUTION_RATE
,      EMPLOYER_CONTRIBUTION_TYPE
,      EMPLOYER_CONTRIBUTION_TYPE_NM
,      EMPLOYEE_DEFAULT_CONTRIBUTION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM APPS.PQP_GB_STAKEHOLDER_TEMPLATE_V;

Dependencies

[top of page]

APPS.PQP_GB_STAKEHOLDER_TEMPLATE_V references the following:

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

APPS.PQP_GB_STAKEHOLDER_TEMPLATE_V is not referenced by any database object