VIEW: APPS.HXC_TEMPLATE_SET_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'