VIEW: APPS.HRI_CL_POSITION_HRCYVRSN_BX_V

Source

View Text - Preformatted

SELECT pps.position_structure_id ID ,pps.name ||' : '||psv.version_number VALUE ,psv.date_from START_DATE ,NVL(psv.date_to, hr_general.end_of_time) END_DATE ,psv.business_group_id BUSINESS_GROUP_ID ,pps.primary_position_flag PRIMARY_STRUCTURE_FLAG FROM per_position_structures pps ,per_pos_structure_versions psv WHERE pps.position_structure_id = psv.position_structure_id AND TRUNC(SYSDATE) BETWEEN psv.date_from AND NVL(psv.date_to, hr_general.end_of_time) AND pps.business_group_id = NVL(hr_bis.get_sec_profile_bg_id,pps.business_group_id) WITH READ ONLY

View Text - HTML Formatted

SELECT PPS.POSITION_STRUCTURE_ID ID
, PPS.NAME ||' : '||PSV.VERSION_NUMBER VALUE
, PSV.DATE_FROM START_DATE
, NVL(PSV.DATE_TO
, HR_GENERAL.END_OF_TIME) END_DATE
, PSV.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PPS.PRIMARY_POSITION_FLAG PRIMARY_STRUCTURE_FLAG
FROM PER_POSITION_STRUCTURES PPS
, PER_POS_STRUCTURE_VERSIONS PSV
WHERE PPS.POSITION_STRUCTURE_ID = PSV.POSITION_STRUCTURE_ID
AND TRUNC(SYSDATE) BETWEEN PSV.DATE_FROM
AND NVL(PSV.DATE_TO
, HR_GENERAL.END_OF_TIME)
AND PPS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PPS.BUSINESS_GROUP_ID) WITH READ ONLY