Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAYBV_BAL_ATTRIBUTE_DEFAULT_V |
SELECT BAD.BAL_ATTRIBUTE_DEFAULT_ID
, BAD.BALANCE_CATEGORY_ID
, BAD.BALANCE_DIMENSION_ID
, BAD.ATTRIBUTE_ID
, BAD.BUSINESS_GROUP_ID
, BAD.LEGISLATION_CODE
, BAD.LAST_UPDATE_DATE
, BAD.LAST_UPDATED_BY
, BAD.LAST_UPDATE_LOGIN
, BAD.CREATED_BY
, BAD.CREATION_DATE
, CASE WHEN ((BAD.BUSINESS_GROUP_ID IS NULL
AND BAD.LEGISLATION_CODE IS NULL) OR (BAD.BUSINESS_GROUP_ID IS NULL
AND BAD.LEGISLATION_CODE = NVL(HR_BIS.GET_LEGISLATION_CODE
, BAD.LEGISLATION_CODE)) OR (BAD.BUSINESS_GROUP_ID= NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, BAD.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PAY_BAL_ATTRIBUTE_DEFAULTS BAD WITH READ ONLY