View: PER_CAL_SCOPE_VALUES_V

Product:	PER - Human Resources
Description:
Implementation/DBA Data:	APPS.PER_CAL_SCOPE_VALUES_V

View Text

SELECT PGH.HIERARCHY_ID
, PGH.BUSINESS_GROUP_ID
, PGH.NAME
, PGH.TYPE
, PGV.HIERARCHY_VERSION_ID
, PGV.VERSION_NUMBER
, PGN.HIERARCHY_NODE_ID
, PGN.ENTITY_ID
, PGN.NODE_TYPE
, PGN.PARENT_HIERARCHY_NODE_ID
, HR_CAL_ENTRY_VALUE_API.GET_DISPLAY_VALUE(PGN.ENTITY_ID
, PGN.NODE_TYPE
, NULL
, NULL)
, ENV.CAL_ENTRY_VALUE_ID
, DECODE(ENV.CAL_ENTRY_VALUE_ID
, NULL
, 'N'
, 'Y')
, ENV.PARENT_ENTRY_VALUE_ID
, ENV.OVERRIDE_NAME
, ENV.OVERRIDE_TYPE
, ENV.USAGE_FLAG
, DECODE(PGN.HIERARCHY_NODE_ID
, NULL
, '1.'
, HR_CAL_ENTRY_VALUE_API.GET_NODE_LEVEL(PGN.HIERARCHY_NODE_ID
, PGV.HIERARCHY_VERSION_ID))
FROM PER_GEN_HIERARCHY PGH
, PER_GEN_HIERARCHY_VERSIONS PGV
, PER_GEN_HIERARCHY_NODES PGN
, PER_CAL_ENTRY_VALUES ENV
WHERE PGH.TYPE LIKE 'PER_CAL%'
AND PGH.HIERARCHY_ID = PGV.HIERARCHY_ID
AND PGV.VERSION_NUMBER = (SELECT MIN (PGV1.VERSION_NUMBER)
FROM PER_GEN_HIERARCHY_VERSIONS PGV1
WHERE PGH.HIERARCHY_ID = PGV1.HIERARCHY_ID)
AND PGV.HIERARCHY_VERSION_ID = PGN.HIERARCHY_VERSION_ID
AND PGN.HIERARCHY_NODE_ID = ENV.HIERARCHY_NODE_ID(+)
AND ENV.CALENDAR_ENTRY_ID (+) = HR_CAL_ENTRY_VALUE_API.GET_G_CURRENT_ENTRY_ID

Columns