View: HXC_TEMPLATE_SET_V

Product:	HXC - Time and Labor Engine
Description:
Implementation/DBA Data:	APPS.HXC_TEMPLATE_SET_V

View Text

SELECT TEMPLATE_NAME NAME
, 'PUBLIC'||'|'||SUBSTR(TO_CHAR(TEMPLATE_ID)
, 1
, 15) CODE
FROM HXC_TEMPLATE_SUMMARY HTS
WHERE HTS.TEMPLATE_TYPE = 'PUBLIC'
AND BUSINESS_GROUP_ID = DECODE(FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP')
, 'N'
, FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
, BUSINESS_GROUP_ID) UNION SELECT MEANING NAME
, 'DYNAMIC'||'|'||LOOKUP_CODE CODE
FROM HR_LOOKUPS HL
WHERE HL.LOOKUP_TYPE = 'HXC_DYNAMIC_TEMPLATES'
AND LOOKUP_CODE <> 'APP|HXT'

Columns