VIEW: APPS.BEN_PAIRD_RT

Source

View Text - Preformatted

SELECT 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 WHERE PRD.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid')) AND PRD.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid'))

View Text - HTML Formatted

SELECT 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
WHERE PRD.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND PRD.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))