View: PQP_GB_STAKEHOLDER_TEMPLATE_V

Product:	PQP - Public Sector Payroll
Description:	View of all base elements created by the stakeholder pension element template.
Implementation/DBA Data:	APPS.PQP_GB_STAKEHOLDER_TEMPLATE_V

View Text

SELECT PETF.ELEMENT_TYPE_ID
, PETF.BUSINESS_GROUP_ID
, PETF.LEGISLATION_CODE
, PETF.CLASSIFICATION_ID
, PEC.CLASSIFICATION_NAME
, SUBSTR(PETF.ELEMENT_NAME
, 1
, LENGTH(PETF.ELEMENT_NAME) - LENGTH( ' STAKEHOLDER PENSION') ) ELEMENT_NAME
, PETF.REPORTING_NAME
, PETF.DESCRIPTION
, PETEI.EEI_INFORMATION1 SCHEME_TYPE
, PETEI.EEI_INFORMATION2 CONTRIBUTION_METHOD
, DECODE(PETEI.EEI_INFORMATION3
, NULL
, 'N'
, 'Y') EMPLOYER_CONTRIBUTIONS
, PETEI.EEI_INFORMATION3 EMPLOYER_CONTRIBUTION_RATE
, PETEI.EEI_INFORMATION4 EMPLOYER_CONTRIBUTION_TYPE
, HRL.MEANING EMPLOYER_CONTRIBUTION_TYPE_NM
, PETEI.EEI_INFORMATION5 EMPLOYEE_DEFAULT_CONTRIBUTION
, PETF.LAST_UPDATE_DATE
, PETF.LAST_UPDATED_BY
, PETF.LAST_UPDATE_LOGIN
, PETF.CREATED_BY
, PETF.CREATION_DATE
FROM PAY_ELEMENT_TYPES_F PETF
, PAY_ELEMENT_TYPE_EXTRA_INFO PETEI
, PAY_ELEMENT_CLASSIFICATIONS PEC
, HR_LOOKUPS HRL
, FND_SESSIONS SES
WHERE PETF.ELEMENT_TYPE_ID = PETEI.ELEMENT_TYPE_ID
AND PETF.CLASSIFICATION_ID = PEC.CLASSIFICATION_ID
AND PETEI.EEI_INFORMATION4 = HRL.LOOKUP_CODE(+)
AND HRL.LOOKUP_TYPE(+) = 'PQP_GB_EMP_CONTRIBUTION_TYPES'
AND PETEI.INFORMATION_TYPE ='PQP_GB_STAKEHOLDER_INFORMATION'
AND SES.SESSION_ID = USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN PETF.EFFECTIVE_START_DATE
AND PETF.EFFECTIVE_END_DATE

Columns