VIEW: APPS.HRI_CL_RQNVAC_VACNCY_V

Source

View Text - Preformatted

SELECT vac.vacancy_id ID ,vac.name VALUE ,vac.date_from START_DATE ,nvl(vac.date_to,hr_general.end_of_time) END_DATE ,vac.business_group_id BUSINESS_GROUP_ID ,CASE WHEN (hr_security.view_all = 'Y' OR hr_security.show_record('PER_VACANCIES',VAC.VACANCY_ID) = 'TRUE') AND (hr_general.get_xbg_profile = 'Y' OR vac.business_group_id = hr_bis.get_sec_profile_bg_id) THEN 'Y' ELSE 'N' END hr_security_flag_code ,CASE WHEN (vac.business_group_id IS NULL OR vac.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, vac.business_group_id)) THEN 'Y' ELSE 'N' END bg_security_flag_code FROM PER_VACANCIES vac UNION ALL SELECT -1 ID ,'' VALUE ,hr_general.start_of_time START_DATE ,hr_general.end_of_time END_DATE , -1 BUSINESS_GROUP_ID ,'Y' hr_security_flag_code ,'Y' bg_security_flag_code FROM dual WITH READ ONLY

View Text - HTML Formatted

SELECT VAC.VACANCY_ID ID
, VAC.NAME VALUE
, VAC.DATE_FROM START_DATE
, NVL(VAC.DATE_TO
, HR_GENERAL.END_OF_TIME) END_DATE
, VAC.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CASE WHEN (HR_SECURITY.VIEW_ALL = 'Y' OR HR_SECURITY.SHOW_RECORD('PER_VACANCIES'
, VAC.VACANCY_ID) = 'TRUE')
AND (HR_GENERAL.GET_XBG_PROFILE = 'Y' OR VAC.BUSINESS_GROUP_ID = HR_BIS.GET_SEC_PROFILE_BG_ID) THEN 'Y' ELSE 'N' END HR_SECURITY_FLAG_CODE
, CASE WHEN (VAC.BUSINESS_GROUP_ID IS NULL OR VAC.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, VAC.BUSINESS_GROUP_ID)) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_VACANCIES VAC UNION ALL SELECT -1 ID
, '' VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, -1 BUSINESS_GROUP_ID
, 'Y' HR_SECURITY_FLAG_CODE
, 'Y' BG_SECURITY_FLAG_CODE
FROM DUAL WITH READ ONLY