VIEW: APPS.PER_CAL_SCOPE_VALUES_V

Source

View Text - Preformatted

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 = 'PER_CAL_GEO' AND pgh.HIERARCHY_ID = pgv.HIERARCHY_ID AND pgv.VERSION_NUMBER = 1 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

View Text - HTML Formatted

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 = 'PER_CAL_GEO'
AND PGH.HIERARCHY_ID = PGV.HIERARCHY_ID
AND PGV.VERSION_NUMBER = 1
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