View: PAYBV_DEFINED_BALANCE

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAYBV_DEFINED_BALANCE

View Text

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

Columns