SELECT PSP.SEQUENCE, PSP.SPINAL_POINT, PSP.SPINAL_POINT_ID, PSP.BUSINESS_GROUP_ID, PSP.PARENT_SPINE_ID, PSP.LAST_UPDATE_DATE, PSP.LAST_UPDATED_BY, PSP.CREATED_BY, PSP.CREATION_DATE, CASE WHEN PSP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PSP.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_SPINAL_POINTS PSP WITH READ ONLY
SELECT PSP.SEQUENCE
, PSP.SPINAL_POINT
, PSP.SPINAL_POINT_ID
, PSP.BUSINESS_GROUP_ID
, PSP.PARENT_SPINE_ID
, PSP.LAST_UPDATE_DATE
, PSP.LAST_UPDATED_BY
, PSP.CREATED_BY
, PSP.CREATION_DATE
, CASE WHEN PSP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PSP.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_SPINAL_POINTS PSP WITH READ ONLY
|
|
|