VIEW: APPS.HRBV_RECRUITMENT_ACTIVITIES_V

Source

View Text - Preformatted

SELECT RAA.CURRENCY_CODE, RAA.DATE_START, RAA.NAME, RAA.ACTUAL_COST, RAA.COMMENTS, RAA.CONTACT_TELEPHONE_NUMBER, RAA.DATE_CLOSING, RAA.DATE_END, RAA.EXTERNAL_CONTACT, RAA.PLANNED_COST, RAA.TYPE, HR_BIS.BIS_DECODE_LOOKUP('REC_TYPE',RAA.TYPE), RAA.STATUS, HR_BIS.BIS_DECODE_LOOKUP('REC_STATUS',RAA.STATUS), RAA.INTERNAL_POSTING, RAA.EXTERNAL_POSTING, RAA.RECRUITING_SITE_RESPONSE, RAA.LAST_POSTED_DATE, '_DF:PER:PER_RECRUITMENT_ACTIVITIES:RAA', RAA.RECRUITMENT_ACTIVITY_ID, RAA.BUSINESS_GROUP_ID, RAA.AUTHORISING_PERSON_ID, RAA.RUN_BY_ORGANIZATION_ID, RAA.INTERNAL_CONTACT_PERSON_ID, RAA.PARENT_RECRUITMENT_ACTIVITY_ID, RAA.POSTING_CONTENT_ID, RAA.RECRUITING_SITE_ID, RAA.LAST_UPDATE_DATE, RAA.LAST_UPDATED_BY, RAA.CREATED_BY, RAA.CREATION_DATE, CASE WHEN RAA.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, RAA.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_RECRUITMENT_ACTIVITIES RAA WITH READ ONLY

View Text - HTML Formatted

SELECT RAA.CURRENCY_CODE
, RAA.DATE_START
, RAA.NAME
, RAA.ACTUAL_COST
, RAA.COMMENTS
, RAA.CONTACT_TELEPHONE_NUMBER
, RAA.DATE_CLOSING
, RAA.DATE_END
, RAA.EXTERNAL_CONTACT
, RAA.PLANNED_COST
, RAA.TYPE
, HR_BIS.BIS_DECODE_LOOKUP('REC_TYPE'
, RAA.TYPE)
, RAA.STATUS
, HR_BIS.BIS_DECODE_LOOKUP('REC_STATUS'
, RAA.STATUS)
, RAA.INTERNAL_POSTING
, RAA.EXTERNAL_POSTING
, RAA.RECRUITING_SITE_RESPONSE
, RAA.LAST_POSTED_DATE
, '_DF:PER:PER_RECRUITMENT_ACTIVITIES:RAA'
, RAA.RECRUITMENT_ACTIVITY_ID
, RAA.BUSINESS_GROUP_ID
, RAA.AUTHORISING_PERSON_ID
, RAA.RUN_BY_ORGANIZATION_ID
, RAA.INTERNAL_CONTACT_PERSON_ID
, RAA.PARENT_RECRUITMENT_ACTIVITY_ID
, RAA.POSTING_CONTENT_ID
, RAA.RECRUITING_SITE_ID
, RAA.LAST_UPDATE_DATE
, RAA.LAST_UPDATED_BY
, RAA.CREATED_BY
, RAA.CREATION_DATE
, CASE WHEN RAA.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, RAA.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_RECRUITMENT_ACTIVITIES RAA WITH READ ONLY