SELECT RCF.RECRUITMENT_ACTIVITY_FOR_ID, RCF.BUSINESS_GROUP_ID, RCF.VACANCY_ID, RCF.RECRUITMENT_ACTIVITY_ID, RCF.LAST_UPDATE_DATE, RCF.LAST_UPDATED_BY, RCF.CREATED_BY, RCF.CREATION_DATE, CASE WHEN RCF.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, RCF.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_RECRUITMENT_ACTIVITY_FOR RCF WITH READ ONLY
SELECT RCF.RECRUITMENT_ACTIVITY_FOR_ID
, RCF.BUSINESS_GROUP_ID
, RCF.VACANCY_ID
, RCF.RECRUITMENT_ACTIVITY_ID
, RCF.LAST_UPDATE_DATE
, RCF.LAST_UPDATED_BY
, RCF.CREATED_BY
, RCF.CREATION_DATE
, CASE WHEN RCF.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, RCF.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_RECRUITMENT_ACTIVITY_FOR RCF WITH READ ONLY
|
|
|