VIEW: APPS.HRI_CL_ORG_HRCYVRSN_N_V

Source

View Text - Preformatted

SELECT osv.org_structure_version_id ID , ost.name||' : '||to_char(osv.version_number) VALUE , osv.date_from START_DATE , nvl(osv.date_to,hr_general.end_of_time) END_DATE , ost.name organization_hierarchy_name , osv.version_number version_number , fnd_global.resp_id responsibility_id , osv.business_group_id business_group_id , ost.primary_structure_flag primary_structure_flag_code , CASE WHEN ( NVL(osv.business_group_id, -1) = NVL(NVL(hr_bis.get_sec_profile_bg_id, osv.business_group_id),-1) ) THEN 'Y' ELSE 'N' END bg_security_flag_code , CASE WHEN ( HRI_OLTP_VIEW_SECURITY.EXIST_ORGHVRSN_FOR_SECURITY(osv.org_structure_version_id) = 'TRUE' ) THEN 'Y' ELSE 'N' END hri_security_flag_code FROM per_org_structure_versions osv , per_organization_structures ost WHERE osv.organization_structure_id = ost.organization_structure_id WITH READ ONLY

View Text - HTML Formatted

SELECT OSV.ORG_STRUCTURE_VERSION_ID ID
, OST.NAME||' : '||TO_CHAR(OSV.VERSION_NUMBER) VALUE
, OSV.DATE_FROM START_DATE
, NVL(OSV.DATE_TO
, HR_GENERAL.END_OF_TIME) END_DATE
, OST.NAME ORGANIZATION_HIERARCHY_NAME
, OSV.VERSION_NUMBER VERSION_NUMBER
, FND_GLOBAL.RESP_ID RESPONSIBILITY_ID
, OSV.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, OST.PRIMARY_STRUCTURE_FLAG PRIMARY_STRUCTURE_FLAG_CODE
, CASE WHEN ( NVL(OSV.BUSINESS_GROUP_ID
, -1) = NVL(NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, OSV.BUSINESS_GROUP_ID)
, -1) ) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
, CASE WHEN ( HRI_OLTP_VIEW_SECURITY.EXIST_ORGHVRSN_FOR_SECURITY(OSV.ORG_STRUCTURE_VERSION_ID) = 'TRUE' ) THEN 'Y' ELSE 'N' END HRI_SECURITY_FLAG_CODE
FROM PER_ORG_STRUCTURE_VERSIONS OSV
, PER_ORGANIZATION_STRUCTURES OST
WHERE OSV.ORGANIZATION_STRUCTURE_ID = OST.ORGANIZATION_STRUCTURE_ID WITH READ ONLY