VIEW: APPS.PAYBV_MONETARY_UNIT_V

Source

View Text - Preformatted

SELECT MU.MONETARY_UNIT_NAME , MU.RELATIVE_VALUE , MU.COMMENTS , MU.CURRENCY_CODE , MU.MONETARY_UNIT_ID , MU.BUSINESS_GROUP_ID , MU.LEGISLATION_CODE , MU.LAST_UPDATE_DATE , MU.LAST_UPDATED_BY , MU.LAST_UPDATE_LOGIN , MU.CREATED_BY , MU.CREATION_DATE , CASE WHEN ((MU.BUSINESS_GROUP_ID IS NULL AND MU.LEGISLATION_CODE IS NULL) OR (MU.BUSINESS_GROUP_ID IS NULL AND MU.LEGISLATION_CODE = NVL(hr_bis.get_legislation_code,MU.LEGISLATION_CODE)) OR (MU.BUSINESS_GROUP_ID= NVL(hr_bis.get_sec_profile_bg_id, MU.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PAY_MONETARY_UNITS MU WITH READ ONLY

View Text - HTML Formatted

SELECT MU.MONETARY_UNIT_NAME
, MU.RELATIVE_VALUE
, MU.COMMENTS
, MU.CURRENCY_CODE
, MU.MONETARY_UNIT_ID
, MU.BUSINESS_GROUP_ID
, MU.LEGISLATION_CODE
, MU.LAST_UPDATE_DATE
, MU.LAST_UPDATED_BY
, MU.LAST_UPDATE_LOGIN
, MU.CREATED_BY
, MU.CREATION_DATE
, CASE WHEN ((MU.BUSINESS_GROUP_ID IS NULL
AND MU.LEGISLATION_CODE IS NULL) OR (MU.BUSINESS_GROUP_ID IS NULL
AND MU.LEGISLATION_CODE = NVL(HR_BIS.GET_LEGISLATION_CODE
, MU.LEGISLATION_CODE)) OR (MU.BUSINESS_GROUP_ID= NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, MU.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PAY_MONETARY_UNITS MU WITH READ ONLY