SELECT PIVT.NAME , PIV.INPUT_VALUE_ID , PIV.EFFECTIVE_START_DATE , PIV.EFFECTIVE_END_DATE , CASE WHEN ((PIV.BUSINESS_GROUP_ID IS NULL AND PIV.LEGISLATION_CODE IS NULL) OR (PIV.BUSINESS_GROUP_ID IS NULL AND PIV.LEGISLATION_CODE = NVL(HR_BIS.GET_LEGISLATION_CODE , PIV.LEGISLATION_CODE)) OR (PIV.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID , PIV.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE , PIVT.NAME ORDER_BY FROM PAY_INPUT_VALUES_F PIV , PAY_INPUT_VALUES_F_TL PIVT WHERE PIV.INPUT_VALUE_ID = PIVT.INPUT_VALUE_ID AND PIVT.LANGUAGE = USERENV('LANG') UNION ALL SELECT NULL , -1 , HR_GENERAL.START_OF_TIME , HR_GENERAL.END_OF_TIME , 'Y' , ' ' ORDER_BY FROM DUAL WITH READ ONLY