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: HR.PQP_PENSION_TYPES_F#

Object Details

Object Name:	PQP_PENSION_TYPES_F#
Object Type:	VIEW
Owner:	HR
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
PENSION_TYPE_ID	NUMBER	(10)	Yes
EFFECTIVE_START_DATE	DATE		Yes
EFFECTIVE_END_DATE	DATE		Yes
PENSION_TYPE_NAME	VARCHAR2	(240)	Yes
PENSION_CATEGORY	VARCHAR2	(30)	Yes
PENSION_PROVIDER_TYPE	VARCHAR2	(30)
SALARY_CALCULATION_METHOD	VARCHAR2	(30)
THRESHOLD_CONVERSION_RULE	VARCHAR2	(30)
CONTRIBUTION_CONVERSION_RULE	VARCHAR2	(30)
ER_ANNUAL_LIMIT	NUMBER	(14)
EE_ANNUAL_LIMIT	NUMBER	(14)
EE_ANNUAL_SALARY_THRESHOLD	NUMBER	(14)
ER_ANNUAL_SALARY_THRESHOLD	NUMBER	(14)
CREATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
BUSINESS_GROUP_ID	NUMBER	(15)
LEGISLATION_CODE	VARCHAR2	(30)
DESCRIPTION	VARCHAR2	(240)
MINIMUM_AGE	NUMBER	(3)
EE_CONTRIBUTION_PERCENT	NUMBER	(7)
MAXIMUM_AGE	NUMBER	(3)
ER_CONTRIBUTION_PERCENT	NUMBER	(7)
EE_ANNUAL_CONTRIBUTION	NUMBER	(14)
ER_ANNUAL_CONTRIBUTION	NUMBER	(14)
ANNUAL_PREMIUM_AMOUNT	NUMBER	(14)
EE_CONTRIBUTION_BAL_TYPE_ID	NUMBER	(9)
ER_CONTRIBUTION_BAL_TYPE_ID	NUMBER	(9)
BALANCE_INIT_ELEMENT_TYPE_ID	NUMBER	(9)
PTY_ATTRIBUTE_CATEGORY	VARCHAR2	(30)
PTY_ATTRIBUTE1	VARCHAR2	(150)
PTY_ATTRIBUTE2	VARCHAR2	(150)
PTY_ATTRIBUTE3	VARCHAR2	(150)
PTY_ATTRIBUTE4	VARCHAR2	(150)
PTY_ATTRIBUTE5	VARCHAR2	(150)
PTY_ATTRIBUTE6	VARCHAR2	(150)
PTY_ATTRIBUTE7	VARCHAR2	(150)
PTY_ATTRIBUTE8	VARCHAR2	(150)
PTY_ATTRIBUTE9	VARCHAR2	(150)
PTY_ATTRIBUTE10	VARCHAR2	(150)
PTY_ATTRIBUTE11	VARCHAR2	(150)
PTY_ATTRIBUTE12	VARCHAR2	(150)
PTY_ATTRIBUTE13	VARCHAR2	(150)
PTY_ATTRIBUTE14	VARCHAR2	(150)
PTY_ATTRIBUTE15	VARCHAR2	(150)
PTY_ATTRIBUTE16	VARCHAR2	(150)
PTY_ATTRIBUTE17	VARCHAR2	(150)
PTY_ATTRIBUTE18	VARCHAR2	(150)
PTY_ATTRIBUTE19	VARCHAR2	(150)
PTY_ATTRIBUTE20	VARCHAR2	(150)
PTY_INFORMATION_CATEGORY	VARCHAR2	(30)
PTY_INFORMATION1	VARCHAR2	(150)
PTY_INFORMATION2	VARCHAR2	(150)
PTY_INFORMATION3	VARCHAR2	(150)
PTY_INFORMATION4	VARCHAR2	(150)
PTY_INFORMATION5	VARCHAR2	(150)
PTY_INFORMATION6	VARCHAR2	(150)
PTY_INFORMATION7	VARCHAR2	(150)
PTY_INFORMATION8	VARCHAR2	(150)
PTY_INFORMATION9	VARCHAR2	(150)
PTY_INFORMATION10	VARCHAR2	(150)
PTY_INFORMATION11	VARCHAR2	(150)
PTY_INFORMATION12	VARCHAR2	(150)
PTY_INFORMATION13	VARCHAR2	(150)
PTY_INFORMATION14	VARCHAR2	(150)
PTY_INFORMATION15	VARCHAR2	(150)
PTY_INFORMATION16	VARCHAR2	(150)
PTY_INFORMATION17	VARCHAR2	(150)
PTY_INFORMATION18	VARCHAR2	(150)
PTY_INFORMATION19	VARCHAR2	(150)
PTY_INFORMATION20	VARCHAR2	(150)
EE_CONTRIBUTION_FIXED_RATE	NUMBER	(8)
ER_CONTRIBUTION_FIXED_RATE	NUMBER	(8)
SPECIAL_PENSION_TYPE_CODE	VARCHAR2	(30)
PENSION_SUB_CATEGORY	VARCHAR2	(30)
PENSION_BASIS_CALC_METHOD	VARCHAR2	(30)
PENSION_SALARY_BALANCE	NUMBER	(9)
RECURRING_BONUS_PERCENT	NUMBER	(7)
NON_RECURRING_BONUS_PERCENT	NUMBER	(7)
RECURRING_BONUS_BALANCE	NUMBER	(9)
NON_RECURRING_BONUS_BALANCE	NUMBER	(9)
STD_TAX_REDUCTION	VARCHAR2	(30)
SPL_TAX_REDUCTION	VARCHAR2	(30)
SIG_SAL_SPL_TAX_REDUCTION	VARCHAR2	(30)
SIG_SAL_NON_TAX_REDUCTION	VARCHAR2	(30)
SIG_SAL_STD_TAX_REDUCTION	VARCHAR2	(30)
SII_STD_TAX_REDUCTION	VARCHAR2	(30)
SII_SPL_TAX_REDUCTION	VARCHAR2	(30)
SII_NON_TAX_REDUCTION	VARCHAR2	(30)
PREVIOUS_YEAR_BONUS_INCLUDED	VARCHAR2	(30)
RECURRING_BONUS_PERIOD	VARCHAR2	(30)
NON_RECURRING_BONUS_PERIOD	VARCHAR2	(30)
EE_AGE_THRESHOLD	VARCHAR2	(30)
ER_AGE_THRESHOLD	VARCHAR2	(30)
EE_AGE_CONTRIBUTION	VARCHAR2	(30)
ER_AGE_CONTRIBUTION	VARCHAR2	(30)

Query Text

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


SELECT PENSION_TYPE_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      PENSION_TYPE_NAME
,      PENSION_CATEGORY
,      PENSION_PROVIDER_TYPE
,      SALARY_CALCULATION_METHOD
,      THRESHOLD_CONVERSION_RULE
,      CONTRIBUTION_CONVERSION_RULE
,      ER_ANNUAL_LIMIT
,      EE_ANNUAL_LIMIT
,      EE_ANNUAL_SALARY_THRESHOLD
,      ER_ANNUAL_SALARY_THRESHOLD
,      CREATED_BY
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      LAST_UPDATED_BY
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_LOGIN
,      BUSINESS_GROUP_ID
,      LEGISLATION_CODE
,      DESCRIPTION
,      MINIMUM_AGE
,      EE_CONTRIBUTION_PERCENT
,      MAXIMUM_AGE
,      ER_CONTRIBUTION_PERCENT
,      EE_ANNUAL_CONTRIBUTION
,      ER_ANNUAL_CONTRIBUTION
,      ANNUAL_PREMIUM_AMOUNT
,      EE_CONTRIBUTION_BAL_TYPE_ID
,      ER_CONTRIBUTION_BAL_TYPE_ID
,      BALANCE_INIT_ELEMENT_TYPE_ID
,      PTY_ATTRIBUTE_CATEGORY
,      PTY_ATTRIBUTE1
,      PTY_ATTRIBUTE2
,      PTY_ATTRIBUTE3
,      PTY_ATTRIBUTE4
,      PTY_ATTRIBUTE5
,      PTY_ATTRIBUTE6
,      PTY_ATTRIBUTE7
,      PTY_ATTRIBUTE8
,      PTY_ATTRIBUTE9
,      PTY_ATTRIBUTE10
,      PTY_ATTRIBUTE11
,      PTY_ATTRIBUTE12
,      PTY_ATTRIBUTE13
,      PTY_ATTRIBUTE14
,      PTY_ATTRIBUTE15
,      PTY_ATTRIBUTE16
,      PTY_ATTRIBUTE17
,      PTY_ATTRIBUTE18
,      PTY_ATTRIBUTE19
,      PTY_ATTRIBUTE20
,      PTY_INFORMATION_CATEGORY
,      PTY_INFORMATION1
,      PTY_INFORMATION2
,      PTY_INFORMATION3
,      PTY_INFORMATION4
,      PTY_INFORMATION5
,      PTY_INFORMATION6
,      PTY_INFORMATION7
,      PTY_INFORMATION8
,      PTY_INFORMATION9
,      PTY_INFORMATION10
,      PTY_INFORMATION11
,      PTY_INFORMATION12
,      PTY_INFORMATION13
,      PTY_INFORMATION14
,      PTY_INFORMATION15
,      PTY_INFORMATION16
,      PTY_INFORMATION17
,      PTY_INFORMATION18
,      PTY_INFORMATION19
,      PTY_INFORMATION20
,      EE_CONTRIBUTION_FIXED_RATE
,      ER_CONTRIBUTION_FIXED_RATE
,      SPECIAL_PENSION_TYPE_CODE
,      PENSION_SUB_CATEGORY
,      PENSION_BASIS_CALC_METHOD
,      PENSION_SALARY_BALANCE
,      RECURRING_BONUS_PERCENT
,      NON_RECURRING_BONUS_PERCENT
,      RECURRING_BONUS_BALANCE
,      NON_RECURRING_BONUS_BALANCE
,      STD_TAX_REDUCTION
,      SPL_TAX_REDUCTION
,      SIG_SAL_SPL_TAX_REDUCTION
,      SIG_SAL_NON_TAX_REDUCTION
,      SIG_SAL_STD_TAX_REDUCTION
,      SII_STD_TAX_REDUCTION
,      SII_SPL_TAX_REDUCTION
,      SII_NON_TAX_REDUCTION
,      PREVIOUS_YEAR_BONUS_INCLUDED
,      RECURRING_BONUS_PERIOD
,      NON_RECURRING_BONUS_PERIOD
,      EE_AGE_THRESHOLD
,      ER_AGE_THRESHOLD
,      EE_AGE_CONTRIBUTION
,      ER_AGE_CONTRIBUTION
FROM HR.PQP_PENSION_TYPES_F#;

Dependencies

[top of page]

HR.PQP_PENSION_TYPES_F# references the following:

HR: PQP_PENSION_TYPES_F

HR.PQP_PENSION_TYPES_F# is referenced by following:

APPS: PQP_PENSION_TYPES_F; PQP_PENSION_TYPES_F_WHO