VIEW: APPS.HRI_CL_ORG_HRCYVRSN_B_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 , fnd_global.resp_id responsibility_id , osv.business_group_id business_group_id , ost.primary_structure_flag primary_structure_flag FROM per_org_structure_versions osv , per_organization_structures ost WHERE osv.organization_structure_id = ost.organization_structure_id AND (osv.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, osv.business_group_id) OR (osv.business_group_id IS NULL AND hr_bis.get_sec_profile_bg_id IS NULL)) 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
, FND_GLOBAL.RESP_ID RESPONSIBILITY_ID
, OSV.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, OST.PRIMARY_STRUCTURE_FLAG PRIMARY_STRUCTURE_FLAG
FROM PER_ORG_STRUCTURE_VERSIONS OSV
, PER_ORGANIZATION_STRUCTURES OST
WHERE OSV.ORGANIZATION_STRUCTURE_ID = OST.ORGANIZATION_STRUCTURE_ID
AND (OSV.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, OSV.BUSINESS_GROUP_ID) OR (OSV.BUSINESS_GROUP_ID IS NULL
AND HR_BIS.GET_SEC_PROFILE_BG_ID IS NULL)) WITH READ ONLY