DBA Data[Home] [Help]

VIEW: APPS.HRBV_SPINAL_POINTS_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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