VIEW: APPS.HRBV_GEN_HIERARCHY_NODES_V

Source

View Text - Preformatted

SELECT PGN.NODE_TYPE, HR_BIS.BIS_DECODE_LOOKUP('HIERARCHY_NODE_TYPE',PGN.NODE_TYPE), PGN.SEQ, PGN.INFORMATION1, PGN.INFORMATION2, PGN.INFORMATION3, PGN.INFORMATION4, PGN.INFORMATION5, PGN.INFORMATION6, PGN.INFORMATION7, PGN.INFORMATION8, PGN.INFORMATION9, PGN.INFORMATION10, PGN.INFORMATION11, PGN.INFORMATION12, PGN.INFORMATION13, PGN.INFORMATION14, PGN.INFORMATION15, PGN.INFORMATION16, PGN.INFORMATION17, PGN.INFORMATION18, PGN.INFORMATION19, PGN.INFORMATION20, PGN.INFORMATION21, PGN.INFORMATION22, PGN.INFORMATION23, PGN.INFORMATION24, PGN.INFORMATION25, PGN.INFORMATION26, PGN.INFORMATION27, PGN.INFORMATION28, PGN.INFORMATION29, PGN.INFORMATION30, PGN.INFORMATION_CATEGORY, PGN.IDENTIFIER_KEY, /* descriptive flexfield */ '_DF:PER:PER_GEN_HIERARCHY_NODES:PGN', /* id columns */ PGN.HIERARCHY_NODE_ID, PGN.BUSINESS_GROUP_ID, PGN.ENTITY_ID, PGN.HIERARCHY_VERSION_ID, PGN.PARENT_HIERARCHY_NODE_ID, /* who columns */ PGN.LAST_UPDATE_DATE, PGN.LAST_UPDATED_BY, PGN.CREATED_BY, PGN.CREATION_DATE, CASE WHEN PGN.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PGN.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_GEN_HIERARCHY_NODES PGN WITH READ ONLY

View Text - HTML Formatted

SELECT PGN.NODE_TYPE
, HR_BIS.BIS_DECODE_LOOKUP('HIERARCHY_NODE_TYPE'
, PGN.NODE_TYPE)
, PGN.SEQ
, PGN.INFORMATION1
, PGN.INFORMATION2
, PGN.INFORMATION3
, PGN.INFORMATION4
, PGN.INFORMATION5
, PGN.INFORMATION6
, PGN.INFORMATION7
, PGN.INFORMATION8
, PGN.INFORMATION9
, PGN.INFORMATION10
, PGN.INFORMATION11
, PGN.INFORMATION12
, PGN.INFORMATION13
, PGN.INFORMATION14
, PGN.INFORMATION15
, PGN.INFORMATION16
, PGN.INFORMATION17
, PGN.INFORMATION18
, PGN.INFORMATION19
, PGN.INFORMATION20
, PGN.INFORMATION21
, PGN.INFORMATION22
, PGN.INFORMATION23
, PGN.INFORMATION24
, PGN.INFORMATION25
, PGN.INFORMATION26
, PGN.INFORMATION27
, PGN.INFORMATION28
, PGN.INFORMATION29
, PGN.INFORMATION30
, PGN.INFORMATION_CATEGORY
, PGN.IDENTIFIER_KEY
, /* DESCRIPTIVE FLEXFIELD */ '_DF:PER:PER_GEN_HIERARCHY_NODES:PGN'
, /* ID COLUMNS */ PGN.HIERARCHY_NODE_ID
, PGN.BUSINESS_GROUP_ID
, PGN.ENTITY_ID
, PGN.HIERARCHY_VERSION_ID
, PGN.PARENT_HIERARCHY_NODE_ID
, /* WHO COLUMNS */ PGN.LAST_UPDATE_DATE
, PGN.LAST_UPDATED_BY
, PGN.CREATED_BY
, PGN.CREATION_DATE
, CASE WHEN PGN.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PGN.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_GEN_HIERARCHY_NODES PGN WITH READ ONLY