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_SCHEMES_V

Object Details

Object Name:	PQP_GB_PENSION_SCHEMES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PQP.PQP_GB_PENSION_SCHEMES_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
PENSION_SCHEME_NAME	VARCHAR2	(150)		Name of the Pension Scheme
PENSION_CATEGORY	VARCHAR2	(150)		Pension Category
PENSION_YEAR_START_DT	DATE			Start Date of the Pension Year
PENSION_PROVIDER_ID	NUMBER	(15)	Yes	Foreign key to HR_ALL_ORGANIZATION_UNITS
PENSION_PROVIDER_NAME	VARCHAR2	(240)	Yes	Name of the Pension Provider
PENSION_TYPE_ID	NUMBER	(10)	Yes	Foreign key to pqp_pension_types_f
PENSION_TYPE_NAME	VARCHAR2	(240)	Yes	Name of the Pension Type
EMPLOYEE_DEDUCTION_METHOD	VARCHAR2	(150)		Method used for Employee Deductions
SCON	VARCHAR2	(150)		S.C.O.N.
ECON	VARCHAR2	(150)		E.C.O.N.
SCHEME_REFERENCE_NUMBER	VARCHAR2	(150)		Scheme Reference Number
EMPLOYER_REFERENCE_NUMBER	VARCHAR2	(150)		Employer Reference Number
ASSOCIATED_OCP_ELE_TYPE_ID	NUMBER			Associated Occupational Pension Scheme Id
ASSOCIATED_OCP_SCHEME	VARCHAR2	(150)		Associated Occupational Pension Scheme Name
ADDITIONAL_CONTRIBUTION	VARCHAR2	(150)		Additional Contirbution
ADDED_YEARS	VARCHAR2	(150)		Added Years
FAMILY_WIDOWER	VARCHAR2	(150)		Family and Widower
EMPLOYER_COMPONENT	VARCHAR2	(1)		Employer Component
EMPLOYER_DEDUCTION_METHOD	VARCHAR2	(150)		Employer Deduction Method
SCHEME_PREFIX	VARCHAR2	(150)		Scheme Prefix
PENSION_SCHEME_TYPE	VARCHAR2	(150)		Pension Scheme Type
PENSIONABLE_SALARY_BALANCE_ID	NUMBER	(9)	Yes	Foreign key to pay_balance_types
PENSIONABLE_SALARY_BALANCE	VARCHAR2	(80)	Yes	Name of the Pensionable Salary Balance
ELEMENT_TYPE_ID	NUMBER	(9)	Yes	Primary key of base element
EFFECTIVE_START_DATE	DATE		Yes	Effective Start Date
EFFECTIVE_END_DATE	DATE		Yes	Effective End Date
ELEMENT_NAME	VARCHAR2	(80)	Yes	Name of the Base Element
BUSINESS_GROUP_ID	NUMBER	(15)		Foreign key to HR_ALL_ORGANIZATION_UNITS
LEGISLATION_CODE	VARCHAR2	(30)		Legislation code
REPORTING_NAME	VARCHAR2	(80)		Reporting name of base element
DESCRIPTION	VARCHAR2	(240)		Description of base element
CLASSIFICATION_ID	NUMBER	(9)	Yes	Foreign key to HR_ORG_CLASSIFICATIONS
CLASSIFICATION_NAME	VARCHAR2	(80)	Yes	Classification of base element
THIRD_PARTY_PAYMENT	VARCHAR2	(1)		Flag to denote if this is a Third Party Payment
ITERATIVE_PROCESSING	VARCHAR2	(30)		Iterative Processing Flag
POST_TERMINATION_RULE	VARCHAR2	(30)	Yes	Post Termination Rule
STANDARD_LINK	VARCHAR2	(30)	Yes	Standard Link Flag
ARREARAGE	VARCHAR2	(150)		Arrearage Flag
PARTIAL_DEDUCTION	VARCHAR2	(150)		Partial Deductions Flag
FWC_ADDED_YEARS	VARCHAR2	(150)		Added Years Family Widower Benefit
CREATED_BY	NUMBER	(15)		Created By
CREATION_DATE	DATE			Creation Date
LAST_UPDATE_DATE	DATE			Last Update Date
LAST_UPDATED_BY	NUMBER	(15)		Last Updated By
LAST_UPDATE_LOGIN	NUMBER	(15)		Last Update Login

Query Text

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


SELECT PENSION_SCHEME_NAME
,      PENSION_CATEGORY
,      PENSION_YEAR_START_DT
,      PENSION_PROVIDER_ID
,      PENSION_PROVIDER_NAME
,      PENSION_TYPE_ID
,      PENSION_TYPE_NAME
,      EMPLOYEE_DEDUCTION_METHOD
,      SCON
,      ECON
,      SCHEME_REFERENCE_NUMBER
,      EMPLOYER_REFERENCE_NUMBER
,      ASSOCIATED_OCP_ELE_TYPE_ID
,      ASSOCIATED_OCP_SCHEME
,      ADDITIONAL_CONTRIBUTION
,      ADDED_YEARS
,      FAMILY_WIDOWER
,      EMPLOYER_COMPONENT
,      EMPLOYER_DEDUCTION_METHOD
,      SCHEME_PREFIX
,      PENSION_SCHEME_TYPE
,      PENSIONABLE_SALARY_BALANCE_ID
,      PENSIONABLE_SALARY_BALANCE
,      ELEMENT_TYPE_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      ELEMENT_NAME
,      BUSINESS_GROUP_ID
,      LEGISLATION_CODE
,      REPORTING_NAME
,      DESCRIPTION
,      CLASSIFICATION_ID
,      CLASSIFICATION_NAME
,      THIRD_PARTY_PAYMENT
,      ITERATIVE_PROCESSING
,      POST_TERMINATION_RULE
,      STANDARD_LINK
,      ARREARAGE
,      PARTIAL_DEDUCTION
,      FWC_ADDED_YEARS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM APPS.PQP_GB_PENSION_SCHEMES_V;

Dependencies

[top of page]

APPS.PQP_GB_PENSION_SCHEMES_V references the following:

APPS: FND_DATE - show dependent code; FND_NUMBER - show dependent code; HR_ALL_ORGANIZATION_UNITS; PAY_BALANCE_TYPES; PAY_ELEMENT_CLASSIFICATIONS; PAY_ELEMENT_TYPES_F; PAY_ELEMENT_TYPE_EXTRA_INFO; PQP_PENSION_TYPES_F

APPS.PQP_GB_PENSION_SCHEMES_V is referenced by following:

APPS: PAY_GB_ENROLL_PENSION - show dependent code; PAY_GB_ENROLL_PENSION - show dependent code; PQP_GB_PENSION_FUNCTIONS - show dependent code; PQP_GB_PENSION_FUNCTIONS - show dependent code; PQP_GB_PENSION_SCHEME_TEMPLATE - show dependent code