Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_PAIRD_RT_V |
SELECT PRD.ROWID ROW_ID
, PRD.PAIRD_RT_ID
, PRD.EFFECTIVE_START_DATE
, PRD.EFFECTIVE_END_DATE
, PRD.USE_PARNT_DED_SCHED_FLAG
, PRD.ASN_ON_CHC_OF_PARNT_FLAG
, PRD.USE_PARNT_PRTL_MO_CD_FLAG
, PRD.ALLOC_SME_AS_PARNT_FLAG
, PRD.USE_PARNT_PYMT_SCHED_FLAG
, PRD.NO_CMBND_MX_AMT_DFND_FLAG
, PRD.CMBND_MX_AMT
, PRD.CMBND_MN_AMT
, PRD.CMBND_MX_PCT_NUM
, PRD.CMBND_MN_PCT_NUM
, PRD.NO_CMBND_MN_AMT_DFND_FLAG
, PRD.NO_CMBND_MN_PCT_DFND_FLAG
, PRD.NO_CMBND_MX_PCT_DFND_FLAG
, PRD.PARNT_ACTY_BASE_RT_ID
, PRD.CHLD_ACTY_BASE_RT_ID
, PRD.BUSINESS_GROUP_ID
, PRD.PRD_ATTRIBUTE_CATEGORY
, PRD.PRD_ATTRIBUTE1
, PRD.PRD_ATTRIBUTE2
, PRD.PRD_ATTRIBUTE3
, PRD.PRD_ATTRIBUTE4
, PRD.PRD_ATTRIBUTE5
, PRD.PRD_ATTRIBUTE6
, PRD.PRD_ATTRIBUTE7
, PRD.PRD_ATTRIBUTE8
, PRD.PRD_ATTRIBUTE9
, PRD.PRD_ATTRIBUTE10
, PRD.PRD_ATTRIBUTE11
, PRD.PRD_ATTRIBUTE12
, PRD.PRD_ATTRIBUTE13
, PRD.PRD_ATTRIBUTE14
, PRD.PRD_ATTRIBUTE15
, PRD.PRD_ATTRIBUTE16
, PRD.PRD_ATTRIBUTE17
, PRD.PRD_ATTRIBUTE18
, PRD.PRD_ATTRIBUTE19
, PRD.PRD_ATTRIBUTE20
, PRD.PRD_ATTRIBUTE21
, PRD.PRD_ATTRIBUTE22
, PRD.PRD_ATTRIBUTE23
, PRD.PRD_ATTRIBUTE24
, PRD.PRD_ATTRIBUTE25
, PRD.PRD_ATTRIBUTE26
, PRD.PRD_ATTRIBUTE27
, PRD.PRD_ATTRIBUTE28
, PRD.PRD_ATTRIBUTE29
, PRD.PRD_ATTRIBUTE30
, PRD.LAST_UPDATE_DATE
, PRD.LAST_UPDATED_BY
, PRD.LAST_UPDATE_LOGIN
, PRD.CREATED_BY
, PRD.CREATION_DATE
, PRD.OBJECT_VERSION_NUMBER
FROM BEN_PAIRD_RT_F PRD
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN PRD.EFFECTIVE_START_DATE
AND PRD.EFFECTIVE_END_DATE