VIEW: APPS.BEN_ELIG_PRBTN_PERD_PRTE_V

Source

View Text - Preformatted

SELECT epn.rowid ,elig_prbtn_perd_prte_id ,EFFECTIVE_START_DATE ,EFFECTIVE_END_DATE ,BUSINESS_GROUP_ID ,eligy_prfl_id ,excld_flag ,probation_period ,probation_unit ,ordr_num , CRITERIA_SCORE , CRITERIA_WEIGHT ,epn_ATTRIBUTE_CATEGORY ,epn_ATTRIBUTE1 ,epn_ATTRIBUTE2 ,epn_ATTRIBUTE3 ,epn_ATTRIBUTE4 ,epn_ATTRIBUTE5 ,epn_ATTRIBUTE6 ,epn_ATTRIBUTE7 ,epn_ATTRIBUTE8 ,epn_ATTRIBUTE9 ,epn_ATTRIBUTE10 ,epn_ATTRIBUTE11 ,epn_ATTRIBUTE12 ,epn_ATTRIBUTE13 ,epn_ATTRIBUTE14 ,epn_ATTRIBUTE15 ,epn_ATTRIBUTE16 ,epn_ATTRIBUTE17 ,epn_ATTRIBUTE18 ,epn_ATTRIBUTE19 ,epn_ATTRIBUTE20 ,epn_ATTRIBUTE21 ,epn_ATTRIBUTE22 ,epn_ATTRIBUTE23 ,epn_ATTRIBUTE24 ,epn_ATTRIBUTE25 ,epn_ATTRIBUTE26 ,epn_ATTRIBUTE27 ,epn_ATTRIBUTE28 ,epn_ATTRIBUTE29 ,epn_ATTRIBUTE30 ,LAST_UPDATE_DATE ,LAST_UPDATED_BY ,LAST_UPDATE_LOGIN ,CREATED_BY ,CREATION_DATE ,OBJECT_VERSION_NUMBER from ben_elig_prbtn_perd_prte_f epn, fnd_sessions se WHERE se.session_id = userenv('sessionid') and effective_date between effective_start_date and effective_end_date

View Text - HTML Formatted

SELECT EPN.ROWID
, ELIG_PRBTN_PERD_PRTE_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, ELIGY_PRFL_ID
, EXCLD_FLAG
, PROBATION_PERIOD
, PROBATION_UNIT
, ORDR_NUM
, CRITERIA_SCORE
, CRITERIA_WEIGHT
, EPN_ATTRIBUTE_CATEGORY
, EPN_ATTRIBUTE1
, EPN_ATTRIBUTE2
, EPN_ATTRIBUTE3
, EPN_ATTRIBUTE4
, EPN_ATTRIBUTE5
, EPN_ATTRIBUTE6
, EPN_ATTRIBUTE7
, EPN_ATTRIBUTE8
, EPN_ATTRIBUTE9
, EPN_ATTRIBUTE10
, EPN_ATTRIBUTE11
, EPN_ATTRIBUTE12
, EPN_ATTRIBUTE13
, EPN_ATTRIBUTE14
, EPN_ATTRIBUTE15
, EPN_ATTRIBUTE16
, EPN_ATTRIBUTE17
, EPN_ATTRIBUTE18
, EPN_ATTRIBUTE19
, EPN_ATTRIBUTE20
, EPN_ATTRIBUTE21
, EPN_ATTRIBUTE22
, EPN_ATTRIBUTE23
, EPN_ATTRIBUTE24
, EPN_ATTRIBUTE25
, EPN_ATTRIBUTE26
, EPN_ATTRIBUTE27
, EPN_ATTRIBUTE28
, EPN_ATTRIBUTE29
, EPN_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
FROM BEN_ELIG_PRBTN_PERD_PRTE_F EPN
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE