VIEW: APPS.PAYBV_BALANCE_CLASSIFICATION_V

Source

View Text - Preformatted

SELECT hr_bis.bis_decode_lookup('ADD_SUBTRACT', PBC.SCALE) SCALE_M ,PBC.SCALE ,PBC.LEGISLATION_SUBGROUP ,PBC.LEGISLATION_CODE ,PBC.BUSINESS_GROUP_ID ,PBC.BALANCE_CLASSIFICATION_ID ,PBC.BALANCE_TYPE_ID ,PBC.CLASSIFICATION_ID ,PBC.OBJECT_VERSION_NUMBER ,PBC.LAST_UPDATE_DATE ,PBC.LAST_UPDATED_BY ,PBC.LAST_UPDATE_LOGIN ,PBC.CREATED_BY ,PBC.CREATION_DATE ,CASE WHEN ((PBC.BUSINESS_GROUP_ID IS NULL AND PBC.LEGISLATION_CODE IS NULL) OR (PBC.BUSINESS_GROUP_ID IS NULL AND PBC.LEGISLATION_CODE = NVL(hr_bis.get_legislation_code,PBC.LEGISLATION_CODE)) OR (PBC.BUSINESS_GROUP_ID= NVL(hr_bis.get_sec_profile_bg_id, PBC.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PAY_BALANCE_CLASSIFICATIONS PBC WITH READ ONLY

View Text - HTML Formatted

SELECT HR_BIS.BIS_DECODE_LOOKUP('ADD_SUBTRACT'
, PBC.SCALE) SCALE_M
, PBC.SCALE
, PBC.LEGISLATION_SUBGROUP
, PBC.LEGISLATION_CODE
, PBC.BUSINESS_GROUP_ID
, PBC.BALANCE_CLASSIFICATION_ID
, PBC.BALANCE_TYPE_ID
, PBC.CLASSIFICATION_ID
, PBC.OBJECT_VERSION_NUMBER
, PBC.LAST_UPDATE_DATE
, PBC.LAST_UPDATED_BY
, PBC.LAST_UPDATE_LOGIN
, PBC.CREATED_BY
, PBC.CREATION_DATE
, CASE WHEN ((PBC.BUSINESS_GROUP_ID IS NULL
AND PBC.LEGISLATION_CODE IS NULL) OR (PBC.BUSINESS_GROUP_ID IS NULL
AND PBC.LEGISLATION_CODE = NVL(HR_BIS.GET_LEGISLATION_CODE
, PBC.LEGISLATION_CODE)) OR (PBC.BUSINESS_GROUP_ID= NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PBC.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PAY_BALANCE_CLASSIFICATIONS PBC WITH READ ONLY