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_PENSION_TEMPLATE_V

Object Details

Object Name:	PQP_GB_PENSION_TEMPLATE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PQP.PQP_GB_PENSION_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)	Yes	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 pension scheme
CONTRIBUTION_METHOD	VARCHAR2	(150)		Method of contribution to pension scheme
ADDITIONAL_CONTRIBUTIONS	VARCHAR2	(150)		Allow additional contributions to scheme?
EXCEPTIONAL_CONTRIBUTIONS	VARCHAR2	(150)		Allow exceptional contributions to scheme?
EMPLOYER_CONTRIBUTIONS	VARCHAR2	(1)		Allow employer contributions to scheme?
EMPLOYER_CONTRIBUTION_RATE	VARCHAR2	(150)		Rate of employer contribution
EMPLOYER_CONTRIBUTION_TYPE	VARCHAR2	(150)		Percentage of flat rate
EMPLOYER_CONTRIBUTION_TYPE_NM	VARCHAR2	(80)		Percentage or flat rate
BUY_BACK_ADDED_YEARS	VARCHAR2	(150)		Buy back added years AVC allowed?
FAMILY_WIDOWER_BENEFIT	VARCHAR2	(150)		Family benefit AVC allowed
AVC_PERCENTAGE	VARCHAR2	(1)		Percentage AVC allowed?
AVC_PERCENTAGE_PROVIDER	VARCHAR2	(150)		Percentage AVC provider
AVC_FIXED_RATE	VARCHAR2	(1)		Fixed rate AVC allowed?
AVC_FIXED_RATE_PROVIDER	VARCHAR2	(150)		Fixed rate AVC provider
LIFE_ASSURANCE	VARCHAR2	(1)		Life assurance AVC allowed?
LIFE_ASSURANCE_PROVIDER	VARCHAR2	(150)		Life assurance AVC provider
EMPLOYEE_DEFAULT_CONTRIBUTION	VARCHAR2	(150)		Default contribution payable by employee
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
,      ADDITIONAL_CONTRIBUTIONS
,      EXCEPTIONAL_CONTRIBUTIONS
,      EMPLOYER_CONTRIBUTIONS
,      EMPLOYER_CONTRIBUTION_RATE
,      EMPLOYER_CONTRIBUTION_TYPE
,      EMPLOYER_CONTRIBUTION_TYPE_NM
,      BUY_BACK_ADDED_YEARS
,      FAMILY_WIDOWER_BENEFIT
,      AVC_PERCENTAGE
,      AVC_PERCENTAGE_PROVIDER
,      AVC_FIXED_RATE
,      AVC_FIXED_RATE_PROVIDER
,      LIFE_ASSURANCE
,      LIFE_ASSURANCE_PROVIDER
,      EMPLOYEE_DEFAULT_CONTRIBUTION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM APPS.PQP_GB_PENSION_TEMPLATE_V;

Dependencies

[top of page]

APPS.PQP_GB_PENSION_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_PENSION_TEMPLATE_V is not referenced by any database object