VIEW: APPS.HRI_CL_ORG_HRCY_N_V

Source

View Text - Preformatted

SELECT ost.organization_structure_id ID , ost.name VALUE , hr_general.start_of_time START_DATE , hr_general.end_of_time END_DATE , fnd_global.resp_id RESPONSIBILITY_ID , ost.primary_structure_flag primary_structure_flag_code , ost.business_group_id business_group_id , CASE WHEN ( NVL(ost.business_group_id, -1) = NVL(NVL(hr_bis.get_sec_profile_bg_id, ost.business_group_id),-1) ) THEN 'Y' ELSE 'N' END bg_security_flag_code , CASE WHEN ( HRI_OLTP_VIEW_SECURITY.EXIST_ORGH_FOR_SECURITY(ost.organization_structure_id) = 'TRUE' ) THEN 'Y' ELSE 'N' END hri_security_flag_code FROM per_organization_structures ost

View Text - HTML Formatted

SELECT OST.ORGANIZATION_STRUCTURE_ID ID
, OST.NAME VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, FND_GLOBAL.RESP_ID RESPONSIBILITY_ID
, OST.PRIMARY_STRUCTURE_FLAG PRIMARY_STRUCTURE_FLAG_CODE
, OST.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CASE WHEN ( NVL(OST.BUSINESS_GROUP_ID
, -1) = NVL(NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, OST.BUSINESS_GROUP_ID)
, -1) ) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
, CASE WHEN ( HRI_OLTP_VIEW_SECURITY.EXIST_ORGH_FOR_SECURITY(OST.ORGANIZATION_STRUCTURE_ID) = 'TRUE' ) THEN 'Y' ELSE 'N' END HRI_SECURITY_FLAG_CODE
FROM PER_ORGANIZATION_STRUCTURES OST