VIEW: APPS.HRI_CL_POSITION_N_V

Source

View Text - Preformatted

SELECT pos.position_id ID , pos.name VALUE , pos.date_effective start_date , NVL(pos.date_end, hr_general.end_of_time) end_date , pos.name order_by , business_group_id business_group_id , pos.organization_id organization_id , pos.job_id job_id , pos.position_definition_id position_definition_id , CASE WHEN (hr_security.view_all = 'Y' OR hr_security.show_record('PER_ALL_POSITIONS' ,POS.POSITION_ID) = 'TRUE') AND (hr_general.get_xbg_profile = 'Y' OR pos.business_group_id = hr_bis.get_sec_profile_bg_id) THEN 'Y' ELSE 'N' END hr_security_flag_code , CASE WHEN (pos.business_group_id IS NULL OR pos.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, pos.business_group_id)) THEN 'Y' ELSE 'N' END bg_security_flag_code FROM per_positions pos

View Text - HTML Formatted

SELECT POS.POSITION_ID ID
, POS.NAME VALUE
, POS.DATE_EFFECTIVE START_DATE
, NVL(POS.DATE_END
, HR_GENERAL.END_OF_TIME) END_DATE
, POS.NAME ORDER_BY
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, POS.ORGANIZATION_ID ORGANIZATION_ID
, POS.JOB_ID JOB_ID
, POS.POSITION_DEFINITION_ID POSITION_DEFINITION_ID
, CASE WHEN (HR_SECURITY.VIEW_ALL = 'Y' OR HR_SECURITY.SHOW_RECORD('PER_ALL_POSITIONS'
, POS.POSITION_ID) = 'TRUE')
AND (HR_GENERAL.GET_XBG_PROFILE = 'Y' OR POS.BUSINESS_GROUP_ID = HR_BIS.GET_SEC_PROFILE_BG_ID) THEN 'Y' ELSE 'N' END HR_SECURITY_FLAG_CODE
, CASE WHEN (POS.BUSINESS_GROUP_ID IS NULL OR POS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, POS.BUSINESS_GROUP_ID)) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_POSITIONS POS