VIEW: APPS.HRBV_REQUISITIONS_V

Source

View Text - Preformatted

SELECT REQ.DATE_FROM, REQ.NAME, REQ.COMMENTS, REQ.DATE_TO, REQ.DESCRIPTION, '_DF:PER:PER_REQUISITIONS:REQ', REQ.REQUISITION_ID, REQ.BUSINESS_GROUP_ID, REQ.PERSON_ID, REQ.LAST_UPDATE_DATE, REQ.LAST_UPDATED_BY, REQ.CREATED_BY, REQ.CREATION_DATE, CASE WHEN REQ.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, REQ.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_REQUISITIONS REQ WITH READ ONLY

View Text - HTML Formatted

SELECT REQ.DATE_FROM
, REQ.NAME
, REQ.COMMENTS
, REQ.DATE_TO
, REQ.DESCRIPTION
, '_DF:PER:PER_REQUISITIONS:REQ'
, REQ.REQUISITION_ID
, REQ.BUSINESS_GROUP_ID
, REQ.PERSON_ID
, REQ.LAST_UPDATE_DATE
, REQ.LAST_UPDATED_BY
, REQ.CREATED_BY
, REQ.CREATION_DATE
, CASE WHEN REQ.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, REQ.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_REQUISITIONS REQ WITH READ ONLY