Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_RPTG_GRP_V |
SELECT BNR.ROWID ROW_ID
, BNR.RPTG_GRP_ID
, TL.NAME
, BNR.BUSINESS_GROUP_ID
, BNR.RPTG_PRPS_CD
, BNR.RPG_DESC
, BNR.ORDR_NUM
, BNR_ATTRIBUTE_CATEGORY
, BNR_ATTRIBUTE1
, BNR_ATTRIBUTE2
, BNR_ATTRIBUTE3
, BNR_ATTRIBUTE4
, BNR_ATTRIBUTE5
, BNR_ATTRIBUTE6
, BNR_ATTRIBUTE7
, BNR_ATTRIBUTE8
, BNR_ATTRIBUTE9
, BNR_ATTRIBUTE10
, BNR_ATTRIBUTE11
, BNR_ATTRIBUTE12
, BNR_ATTRIBUTE13
, BNR_ATTRIBUTE14
, BNR_ATTRIBUTE15
, BNR_ATTRIBUTE16
, BNR_ATTRIBUTE17
, BNR_ATTRIBUTE18
, BNR_ATTRIBUTE19
, BNR_ATTRIBUTE20
, BNR_ATTRIBUTE21
, BNR_ATTRIBUTE22
, BNR_ATTRIBUTE23
, BNR_ATTRIBUTE24
, BNR_ATTRIBUTE25
, BNR_ATTRIBUTE26
, BNR_ATTRIBUTE27
, BNR_ATTRIBUTE28
, BNR_ATTRIBUTE29
, BNR_ATTRIBUTE30
, TL.FUNCTION_CODE
, LEGISLATION_CODE
, BNR.LAST_UPDATE_DATE
, BNR.LAST_UPDATED_BY
, BNR.LAST_UPDATE_LOGIN
, BNR.CREATED_BY
, BNR.CREATION_DATE
, BNR.OBJECT_VERSION_NUMBER
, DECODE(NVL( BNR.BUSINESS_GROUP_ID
, -1)
, -1
, 'Y'
, 'N') GLOBAL_FLAG
FROM BEN_RPTG_GRP BNR
, BEN_RPTG_GRP_TL TL
WHERE BNR.RPTG_GRP_ID = TL.RPTG_GRP_ID
AND TL.LANGUAGE = USERENV('LANG')