VIEW: APPS.PAYBV_BALANCE_FEEDS_F_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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