SELECT ORS.NAME, ORS.COMMENTS, ORS.POSITION_CONTROL_STRUCTURE_FLG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ORS.POSITION_CONTROL_STRUCTURE_FLG), '_DF:PER:PER_ORGANIZATION_STRUCTURES:ORS', ORS.PRIMARY_STRUCTURE_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ORS.PRIMARY_STRUCTURE_FLAG), ORS.ORGANIZATION_STRUCTURE_ID, ORS.BUSINESS_GROUP_ID, ORS.LAST_UPDATE_DATE, ORS.LAST_UPDATED_BY, ORS.CREATED_BY, ORS.CREATION_DATE, CASE WHEN ORS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, ORS.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_ORGANIZATION_STRUCTURES ORS WITH READ ONLY
SELECT ORS.NAME
, ORS.COMMENTS
, ORS.POSITION_CONTROL_STRUCTURE_FLG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ORS.POSITION_CONTROL_STRUCTURE_FLG)
, '_DF:PER:PER_ORGANIZATION_STRUCTURES:ORS'
, ORS.PRIMARY_STRUCTURE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ORS.PRIMARY_STRUCTURE_FLAG)
, ORS.ORGANIZATION_STRUCTURE_ID
, ORS.BUSINESS_GROUP_ID
, ORS.LAST_UPDATE_DATE
, ORS.LAST_UPDATED_BY
, ORS.CREATED_BY
, ORS.CREATION_DATE
, CASE WHEN ORS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ORS.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_ORGANIZATION_STRUCTURES ORS WITH READ ONLY
|
|
|