VIEW: APPS.PAYBV_DEFINED_BALANCE

Source

View Text - Preformatted

SELECT pdb.SAVE_RUN_BALANCE ,pdb.GROSSUP_ALLOWED_FLAG ,hr_bis.bis_decode_lookup('YES_NO', pdb.FORCE_LATEST_BALANCE_FLAG) FORCE_LATEST_BALANCE_FLAG ,pdb.LEGISLATION_CODE ,pdb.LEGISLATION_SUBGROUP ,pdb.FORCE_LATEST_BALANCE_FLAG FORCE_LATEST_BAL_FLAG_CODE ,pdb.DEFINED_BALANCE_ID ,pdb.BALANCE_TYPE_ID ,pdb.BALANCE_DIMENSION_ID ,pdb.BUSINESS_GROUP_ID ,pdb.LAST_UPDATE_DATE ,pdb.LAST_UPDATED_BY ,pdb.LAST_UPDATE_LOGIN ,pdb.CREATED_BY ,pdb.CREATION_DATE ,pdb.OBJECT_VERSION_NUMBER ,CASE WHEN ((pdb.business_group_id IS NULL AND pdb.legislation_code IS NULL) OR (pdb.business_group_id IS NULL AND pdb.legislation_code = NVL(hr_bis.get_legislation_code,pdb.legislation_code)) OR (pdb.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, pdb.business_group_id))) THEN 'Y' ELSE 'N' END bg_security_flag_code FROM pay_defined_balances pdb WITH READ ONLY

View Text - HTML Formatted

SELECT PDB.SAVE_RUN_BALANCE
, PDB.GROSSUP_ALLOWED_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PDB.FORCE_LATEST_BALANCE_FLAG) FORCE_LATEST_BALANCE_FLAG
, PDB.LEGISLATION_CODE
, PDB.LEGISLATION_SUBGROUP
, PDB.FORCE_LATEST_BALANCE_FLAG FORCE_LATEST_BAL_FLAG_CODE
, PDB.DEFINED_BALANCE_ID
, PDB.BALANCE_TYPE_ID
, PDB.BALANCE_DIMENSION_ID
, PDB.BUSINESS_GROUP_ID
, PDB.LAST_UPDATE_DATE
, PDB.LAST_UPDATED_BY
, PDB.LAST_UPDATE_LOGIN
, PDB.CREATED_BY
, PDB.CREATION_DATE
, PDB.OBJECT_VERSION_NUMBER
, CASE WHEN ((PDB.BUSINESS_GROUP_ID IS NULL
AND PDB.LEGISLATION_CODE IS NULL) OR (PDB.BUSINESS_GROUP_ID IS NULL
AND PDB.LEGISLATION_CODE = NVL(HR_BIS.GET_LEGISLATION_CODE
, PDB.LEGISLATION_CODE)) OR (PDB.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PDB.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PAY_DEFINED_BALANCES PDB WITH READ ONLY